Skip to Content
avatar image
Former Member

DB2 SQL statement clarification required

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 10, 2008 at 06:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2008 at 07:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2008 at 08:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded