DB2 SQL statement clarification required

[Former Member]

Good evening,

Hoping someone can help me as my Portal system is currently down and I have been unable to resolve the issue. Please refer to point 3 of Sap Note 1156313 :

3. Deploy the change. This should create an empty table WCR_USERSTAT with the new structure.

Does someone know what is meant by this statement? Please,

Anette

[former_member235924 · Accepted solution]

Hello,

I had the same problem in our BI JAVA.

After renaming the table WCR_USERSTAT (step 2 in the note) I went back to the JSPM and resumed the deployment of the Support Packages. This time it worked.

In our case the table was empty, so I didn't have to copy the data afterwards.

Thanks,

Ingrid

[former_member235924]

Hi,

no problem. Just in case you run into the other problem also: I also had to follow instructions of OSS note 1086067 for a similar error with table KBMC_URIMAPPER.

Good luck,

Ingrid

[Former Member]

Thank-you Ingrid.

I am so embarressed that I misunderstood this so badly - only excuse is lack of sleep. Thank-you for your reply.

Anette