Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in Preprocessing on upgrade from NW7.01 to NW7.31

Dear all,

we take a testupgrade of our BW NW 7.01 System to BW NW 7.31. In phase MAIN_SHDIMP/SUBMOD_SHD2_RUN/RUN_RSGENLOD the process stops with an error. I logon to the shadow instance as DDIC and find the following shortdump:

Category               ABAP Programming Error

Runtime Errors         SAPSQL_ARRAY_INSERT_DUPREC

Except.                CX_SY_OPEN_SQL_DB

ABAP Program           CL_SGEN_DB====================CP

Application Component  BC-UPG

also the scheduled job RSGEN_LOAD_SHADOW for this step stops after 10 sec, because of the above shortdump.

Furthermore i try to start the SGEN manually, but the transaction doesn*t start. I get only the message:

Invalid mode for log

Message no. TSGEN030

and the session close.

i can't find any solution for this problem.

our environment:

HP-UX 11.31

MaxDB 7.9.08.005

source release:

NW 7.01 SP11

target release:

NW 7.31 SP05

We use the Software Update Manager (SUM) SP05 Patch 09.

I hope anybody can help us.

Kind Regards

Oliver

DUMP.txt.zip (13456 B)
Former Member
Former Member replied

Dear all,

first of all we still wait for an answer of SAP.

But i found the problem and a workaround to continue the upgrade.

the methode "IF_SGEN_DB~INSERT_GENSETM" had a wrong IF query.

so i did the following.

1.) logon to shadow system

2.) set a external breakpoint in methode  "IF_SGEN_DB~INSERT_GENSETM" in line 11 (IF lv_entries > 0.)

3.) restart phase in SUM

4.) go to SM50 and look after upgrade process

5.) mark the process and go to program/session or administration (in Release 7.31) -> program -> debugging

6.) press F8 until the breakpoint

7.) change value of lv_entries from 0 to 1.

8.) press F8 until the batchjob is finished

I hope SAP send me a correct solution for this problem.

Kind Regards

Oliver

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question