Error during upgrade SPS9 using SUM

[#1]

Hello all,

During NetWeaver 7.4 upgrade from SPS5 to SPS9 on our consolidation system in step 5.5 Pre-processing, I've got below error:

I've tried to repeat that action but it did not help. In previous week I've finished exactly the same upgrade on development system and I did not have any

problems. For now I have no clue why it is does work. If it is upgrade fault or might be problem on sybase side.

In logs I've seen something weird:

"Error while setting identity property for column C""RR_ID of logging table /1CRR/LT00001387"" "" "' raised".

It seems that table above can not be activated, I've spoke with our DBA's and they claimed that for them DB looks OK .....

If someone will have any solution I will be grateful.

Thanks in advance for your support.

Regards,

Karolina Plebanek

[Former Member]

Hello Karolina,

In your error you can see that there is an issue setting the identity property for column CRR_ID on table "/1CRR/LT00001387" which is the logging table related to table /ASU/SSMCONTENTP. I guess this is the way of linking this table back to what you see in crr_control.

Now what you need to determine is why the CRR_ID (incremental number) cannot be updated/set for "/1CRR/LT00001387".

1. As a cross check, ask your DBA to check the columns of table "/1CRR/LT00001386" and see what value is assigned to CRR_ID for this table. Logically (based on the assumption above) it would be 1386.

2. Ask you DBA to check the DB logs to see if anything is being logged during the failed creation of "/1CRR/LT00001387" In the SQL cache I would imagine you could see the SQL statement that was executed.

3. Even though I doubt it has anything to do with your problem, please check table /ASU/SSMCONTENTP with tx: SE11 and reactivate it if necessary.

4. Try repeating the phase with the INIT option (nothing to lose by trying).

5. In parallel, open a message with SAP. It's what you pay your license fee for.

KR,

Amerjit