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]

Dear Ms. Plebanek,

We were upgrading our sandbox ERP 6.0 EHP7  from SPS4 to SPS10, with SUM1.0 SP16 and selected nZDM (near-Zero Downtime Maintenance Technology) for upgrade.

We faced the same issue, got ST22 dumps in shadow instance and background job cancellation.  I searched in SCN and found this thread.

But in our case, we raised an OSS ticket to SAP. As per SAP's reply, there was a table named TTXVR which was having two versions. It was due to incomplete conversion of table TTXVR from POOLED to TRANSPARENT.

One version of this table is showing POOLED (which is active version) and other one is TRANSPARENT with inactive version.

As per SAP's suggestion, we reset the upgrade and then dropped the TRANSPARENT version of the table. Then restarted the SUM. Now our upgrade has finished successfully on our SANDBOX server.

This might be the reason, in your case too. Hope this post may helpful to other consultants, who may face this kind of issue in their upgrades.

Best Regards

Yogananda Kumar Pilla.