PlanVersion::deleteSchema: Schema 00201PLV0000001~DDIC schema handle 7

[Former Member]

Hello,

I have checked livecache trace file with /sapapo/om01 in which one line says:

PlanVersion::deleteSchema: Schema 00201PLV0000001~DDIC schema handle 74 has been dropped by user DDIC

What does it mean? Is this normal or indicate some problem?

Thanks in advance.

Regards,

Tushar

[former_member229109 · Accepted solution]

Hello Tushar,

In case the schema will dropped by user on the system the errors will be written in the LCA trace 1 & knldiag.err files to keep the track of the dropping schemas & by which user. In case the planning version was deleted by mistake, it's possible to see when & whom.

As you know the if you run the liveCache tests with /nLCA03 or /n/sapapo/om03, the schema, temporarily objects are created for the test run, the GUID of these objects have a _{. After the test finished successfully the temporally objects are dropped. And schema 00201PLV0000001}DDIC too. You see after ~ the user name, who run the test.

Thank you and best regards, Natalia Khlopina