Preprocessing error. Checks after phase SHADOW_IMPORT_INC were negative!

[Former Member]

Dear SAP gurus,

I am performing an SAP update ECC60 EHP3 to EHP5 (Linux, Oracle 10.2)and I got stuck at Preprocessing phase with the following error:

Checks after phase MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_INC were negative!

Last error code set: Unresolved requests in buffer <SID>

Check log files 'SHDALLIMP.ELG' and '/usr/sap/trans/<SID>/EHPI/abap/log/SAPehpi.ECO'

...

Choose action:

-Repeat phase

-Initialize phase

-Exit

/usr/sap/<SID>EHPI/abap/log # more SHDALLIMP.ELG

**************************************************

• LIST OF ERRORS AND RETURN CODES *******

**************************************************

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SHADOW IMPORT ERRORS and RETURN CODE in SAPKW70201.<SID>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2EETW000 1 duplicate key error during insert into table SEOTYPEPLS~ occured

2EETW000 sap_dext called with msgnr "256":

2EETW000 -

---

db call info -

---

2EETW000 function: db_xrtab

2EETW000 fcode: RT_MI_LOAD

2EETW000 tabname: SEOCOMPO~

2EETW000 len (char): 0

2EETW000 key:

2EETW000 retcode: 256

1 ETP111 exit code : "12"

I read in another thread that this might be an issue related with the buffer. However, it's not very clear to me how to solve this.

Has anyone of you experience this?Any suggestions?

Thanks in advance, Marc

[Former Member · Accepted solution]

more /usr/sap/<SID>/EHPI/abap/log/SAPehpi.ECO

u2026..

/usr/sap/<SID>/EHPI/abap/exenew/R3trans finished (0012).

This is /usr/sap/<SID>/EHPI/abap/exenew/R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).

unicode enabled version

/usr/sap/<SID>/EHPI/abap/exenew/R3trans finished (0004).

This is /usr/sap/<SID>/EHPI/abap/exenew/R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).

unicode enabled version

/usr/sap/<SID>/EHPI/abap/exenew/R3trans finished (0000).

This is /usr/sap/<SID>/EHPI/abap/exenew/R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).

unicode enabled version

/usr/sap/<SID>/EHPI/abap/exenew/R3trans finished (0004).

ERROR: stopping on error 12 during SHADOW IMPORT

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter DBCONFPATH is no longer used.

stopping on error 12 during SHADOW IMPORT

tp returncode summary:

TOOLS: Highest return code of single steps was: 12

SWARNS: Highest tp internal severe warning was: 0151

tp finished with return code: 151

meaning:

Some warning regarding buffer entries

Process with ID 8149 terminated with status 151

The R3Trans version:

:/usr/sap/<SID>/EHPI/abap/exenew # ./R3trans

This is ./R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).

unicode enabled version

usage: ./R3trans [<options>] <control_file>

The control_file describes what R3trans has to do.

The following options are possible:

-c f1 f2 : Copy file f1 to f2 with character set conversion.

-d : DB connect. Test if SAP database is available.

-i file : Import from file without using a control file.

-l file : List the contents of file to the log file.

-m file : List the contents of file to allow tp to create a cofile.

-t : Test. All database changes are rolled back.

-t4 : Trace level 4. Switch on developer trace.

-u <int> : Unconditional modes. See below.

-v : Verbose. Write more details to the log file.

-w file : Log file. The default log file is 'trans.log'.

-x : DB connect without access on any SAP table.

./R3trans finished (0012).

Regards, Marc

[sunny_pahuja2 · Accepted solution]

Hi,

Check SAP note 1074030.

Also, try to updated R3tarns to latest version in upgrade kernel directory.

Thanks

Sunny

[Former Member · Accepted solution]

Thanks Sunny for your answer.

I checked R3trans

./R3trans -d

This is ./R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SBX/SYS/exe/run') or dbms_type ('ORA')"

./R3trans.old finished (0012).

If I update R3trans with the latest value:

./R3trans -d

This is ./R3trans version 6.14 (release 700 - 03.06.11 - 17:57:00).

unicode enabled version

./R3trans finished (0000).

Can be that I was using a wrong R3trans release 720???How is that possible if I downloaded everything using Solman optimizer?

Regards, Marc

[Former Member · Accepted solution]

It seems that R3trans 720=702.

Anyways, I updated with the latest patch of R3trans but the issue still persists.

OLD:This is ./R3trans.old version 6.22 (release 720 - 02.05.11 - 15:56:00). Patch number 89

NEW:This is ./R3trans version 6.22 (release 720 - 03.06.11 - 17:57:00). Patch number 92

Couldnt find the reason in the recommended note either.

It seems that the R3trans is trying to insert into table SEOTYPEPLS without success because there are some duplicate keys.

Maybe if I can find which are the duplicate keys and delete one of those could solve my issue?? But I have no idea how to find this. Any suggestions??

Regards, Marc

[Former Member · Accepted solution]

Hi Marc,

Perhaps you to login to the shadow instance and check the table via tcode SE11.

Unlock the shadow instance is required using the command ./SAPEhPi unlockshd from the EhPI 'bin' directory.

Regards,

Srikishan

[sunny_pahuja2 · Accepted solution]

Hi,

Have you checked the note i suggested you earlier ?

Thanks

Sunny

[former_member239509 · Accepted solution]

Hello all,

Is there any solution available for this issue ? I am facing exactly the same problem.

Note 1074030 seems to be too much help, as the solution possibilites may not be approproate to be applied during EHP Upgrade:

- correct errors in Source system and redo transport is not possible as the data comes from SAP

- Up to date R3Trans : should be up to date as it comes together with EHP Upgrade and is therefore already

EHPI/abap/exenew/R3trans version 6.22 (release 720

- also in the note it is written: ...you should always transfer the problem to the BC-UPG component..

Actually I opened a call with SAP, but still waiting for an answer.

So, has anybody already solved this issue ?

Best Regards

Roland

[former_member239509 · Accepted solution]

Hello all,

issue is solved.

After there was no reaction from SAP Support and the deadline came close, I decided to do some tries. (first making a backup of the whole system of course)

So I chose "Repeat phase MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_INC to continue at the point it stopped. "

The error came again - but with a different Support Package (you see the support package in the file SHDALLIMP.ELG )

The first error was with SAPK-70103INPIBASIS.

The second one was with SAPKW70103, but at this time, the SAPK-70103INPIBASIS has been importet with Return code 0000

So I did again a continue, it also importet SAPKW70103 with Return code 0004, which is ok

The phase ended without further errors.

Reason for error situations was, that tp imports always 2 transports in parallell. (You see in the buffer file, that it has SYNCMARKs every two files, it is also specified in the profile tp uses).

There is a note about this feature, 1127194

Meanwhile SAP has answered the call, they said that I did the correct actions and referenced SAP Note 1596921

So our EHP Upgrade is finished, we are in SPAU phase.

Regards,

Roland