CA Service Management

Hello,

When we run pdm_wspupd at our DEV Environment we receive those logs:

Pdm_wspupd - Update wspcol table from wsp_schema.sch

Reading wsp_schema.sch to for current DBMS information...
Reading wspcol table for WSP schema information...

Column alg.z_causa_raiz not found in wsp_schema.sch - deleting wspcol row
Column alg.z_inc_*** not found in wsp_schema.sch - deleting wspcol row
Column alg.z_tipo not found in wsp_schema.sch - deleting wspcol row

[...]

pdm_wspupd found 0 WSP-maintained column(s) to update and 105 to delete.
Please verify that your DBMS has been manually updated to correspond to
wsp_schema.sch, then reply Y to update wspcol or anything else to cancel.
pdm_wspupd terminating as requested. No database updates were made.

but those columns exists at wsp_schema.sch.

Anyone has experienced that?

Ricardo, I think the utility did the right thing...

Column alg.z_causa_raiz not found in wsp_schema.sch - deleting wspcol row

if it didn't delete the row in wspcol table, you would have in-sync for the schema file and table.

One question that you would need to address is...why you have some rows in wspcol table but not in wsp_schema.sch file? Thanks _Chi

Hi Chi,

In fact z_causa_raiz exists in wsp_schema.sch. All those fields exists (And are being used).

Ricardo, that is weird...either the output message is misleading or there is a bug somewhere. Please open a Support

case so we can get to the bottom of this. By the way, is z_causa_raiz in wsp_schema.log file? Thanks _Chi

Yes, the same occurs with another 100 custom fields created.

Ok, I'll open a case. thanks