Upgrade in hangs in XPRAS_UPG phase

[Former Member]

We are experimenting an hang situation during the upgrade from 46C sandbox system to ECC6 Sr3, latest patches.

The upgrade is in phase XPRAS_UPG, and in Sap we see the job RDDEXECL running from very long time (more than 1 days); in SM50 we see the several programmes (SAPLSTXG and others) working with sequential read, update or delete actions on the table STXL.

But neither the job log is updated or the logs into the put directory on the filesystem.

Before the upgrade we applied the note 558197 (that one for the script dba_ind_column,....), and we enlarged the shared_pool_size and shared_pool_reserved_size as described into the upgrade guide.

We run also the del_priv_ind script as suggested by Prepare.

We try also to stop and restart the upgrade, but nothing change; it continue to stay in hangs on the STXL table in phase XPRAS_UPG.

The latest row of the SAPR700ZG1.SID is :

"Post-import method 'AFTER_IMP_FORM' started for FORM 'L' ....."

Is the first time we see this situation during an upgrade.

Any suggestion ?

[Former Member]

solved creating an Index on the table , following a very very old note for Ms-SQl.....

[Former Member]

Hi,

Is this your first test upgrade in the Landscape? How many records the table has?

Is not uncommon that XPRAS_UPG takes a long time, in one system I won´t forget the downtime took 72 hours running ! and most of this time was during XPRAS_UPG so if this is taking so long and it is working it will be better to let it finish and analize the upgrade report. Normaly when some processes are running the log files are not updated because they don´t trace all work done by the processes. Have you analize if Hard disks are working more than normal during this phase? if so then let if finish and you will be able to see why it took so long.

Good luck

[JPReyes]

Try updating the statistics and run the SP again.

Regards

Juan

[Former Member]

thanks for the feedback.

It is already done. We did them also with Compute for the STXL table, but nothing change.

We found note "843617 - Perf. problem with "AFTER_IMP_FORM" after-import method" but the corrections are already in place.

I suspect it's a program error, but I'm not able to find any Oss note for this release about performances updating the STXL table.

Other suggestions ?

[JPReyes]

Maybe an OSS message is in order.

Regards

Juan