cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade to ERP 6.0 EHP7 Issue

0 Kudos
1,114

Hello, experts!

I need your help!

We have:

Current Status

TS1

EHP6 FOR SAP ERP 6.0

15 (06/2015)

SAP ERP 6.0

27 (06/2015)

SAP EHP3 FOR SAP NETWEAVER 7.0

16 (04/2015)

What we try:

Planned Changes

Process Type: EhP Installation with Technical Usage

Update Tool: SOFTWARE UPDATE MANAGER 1.0 Support Package Level-017

Overview of Changes:

Target Status

TS1

EHP7 FOR SAP ERP 6.0

12 (07/2016)

SAP ERP 6.0

28 (06/2016)

SAP NETWEAVER 7.4

15 (06/2016)

During the upgrade i was facing the following issue:

In MAIN_NEWBAS/TABIM_UPG Phase errors occured:

Checks after phase MAIN_NEWBAS/TABIM_UPG were negative!

Last error code set: Detected 3 errors summarized in 'TABIMUPG.ELG'

Calling '/usr/sap/TS1/DVEBMGS10/exe/tp' failed with return code 8, check /usr/sap/TS1/SUM/abap/log/SAPup.ECO for details

ERROR:

Detected the following errors:

# /usr/sap/TS1/SUM/abap/log/SAPIH61712.TS1:

4 ETW000 0 d / 0 i / 0 u / 3 = 100% ucf EDOPROCSPINTDET

4 ETW000 3 entries for EDOPROCSPINTDET merged (___SVNCINV 0001REQ_SEND SVN_CINV SD_INVOICE); as part of view EDOPROCSPINTDETV.

4 ETW000 client 000: 1

4 ETW000 client 001: 1

4 ETW000 client 700: 1

2EETW000 1 duplicate key error during insert into table EDOPROCSPINTDET occured

4 ETW000 0 d / 0 i / 0 u / 0 = 0% ucf EDOPROCSPINTDET

4 ETW000 0 entries for EDOPROCSPINTDET merged (___SVNCINV 0001SENDEDOC SVN_CINV FI_INVOICE); as part of view EDOPROCSPINTDETV.

2EETW000 1 duplicate key error during insert into table EDOPROCSPINTDET occured

4 ETW000 0 d / 0 i / 0 u / 3 = 100% ucf EDOPROCSPINTDET

4 ETW000 3 entries for EDOPROCSPINTDET merged (___SVNCISUM 0001REQ_SEND SVN_CISUM); as part of view EDOPROCSPINTDETV.

4 ETW000 client 000: 1

4 ETW000 client 001: 1

...skipped 2 more lines.

Please see TABIMUPG.html for more information

I found several notes about versions of tp and R3trans, but i have the latest versions of them.

Then i went to SE11->EDOPROCSPINTDETV and found that this view based on 3 tables:

EDOPROCSPINTDET

EDOINTERFACE

EDOINTERFACET

And only EDOPROCSPINTDET table has unique index EDOPROCSPINTDET~00.

I deleted all rows in table SAPSR3.EDOPROCSPINTDET and repeated the phase to find out whether identical rows are inserted to existing or whether it is an error of the packet, and the errors occured again. I selected rows from SAPSR3.EDOPROCSPINTDET

and found that there are 21 rows, after that i understood that SAPIH61712 insert duplicated rows. OK, i restarted the whole procedure of upgrade(restore db and did system copy),

and during MAIN_NEWBAS/TABIM_UPG phase after the same errors i:

1) unlocked system

2) went to SE11-> EDOPROCSPINTDET->Indexes->select index and unset UNIQUE flag, saved and activated changes

3) repeat phase

And the Phase was done!

I checked indexes on table EDOPROCSPINTDET and found:

index "EDOPROCSPINTDET~0" based on "MANDT", "PROCESS", "VERSION", "PROCSTEP", "EDOC_TYPE", "SOURCE_TYPE" columns

index "EDOPROCSPINTDET~00" based "MANDT", "INTERFACE_ID", "PROCESS", "VERSION", "EDOC_TYPE", "SOURCE_TYPE" columns

I selected duplicated rows from table based on index "EDOPROCSPINTDET~00" and found there are 9 duplicated rows:

select MANDT,INTERFACE_ID,PROCESS,VERSION,EDOC_TYPE,SOURCE_TYPE,count(*) from sapsr3.EDOPROCSPINTDET group by MANDT,INTERFACE_ID,PROCESS,VERSION,EDOC_TYPE,SOURCE_TYPE having count(*)>1;

Then i went to SE16->EDOPROCSPINTDET set the following:

interface_id

/EDOSVNCINV1

process

SVNCISUM               

version

0001  

edoc_type

SVN_CISUM

          

and saw that there are really 2 rows with identical interface_id=/EDOSVNCINV1, process=SVNCISUM,version=0001, edoc_type=SVN_CISUM

   

BUT: PROC_STEP is different, for one is REQ_SEND value and for another SENDEDOC value.

Then i found the note 2354379. In this note say: index "EDOPROCSPINTDET~00" was deleted in he Support Package SAPKH61711, at this point is unknown why it is being created in the database.

And i guess that my  previous steps seem to be correct even if  this note for Ms SQL server.

My questions to you, experts:

1) My steps was correct?

2) Who have EHP7 with SAP-APPL SP12 could you see in your systems, table EDOPROCSPINTDET has any unique indexes based on "MANDT", "PROCESS", "VERSION", "PROCSTEP", "EDOC_TYPE", "SOURCE_TYPE" columns?

3) Who have EHP7 with SAP-APPL SP12 could you show output from this select:

select MANDT,INTERFACE_ID,PROCESS,VERSION,EDOC_TYPE,SOURCE_TYPE,count(*) from sapsr3.EDOPROCSPINTDET group by MANDT,INTERFACE_ID,PROCESS,VERSION,EDOC_TYPE,SOURCE_TYPE having count(*)>1;

Thank you for your answers!

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello, everyone!

I would like to inform you that SAP released note about this problem: https://launchpad.support.sap.com/#/notes/2354221/E

I hope this information helps for further upgrades!

0 Kudos

Hello!

In my case, this isn't working.

I tried the following two options:

SQL> DROP INDEX SAPSR3."EDOPROCSINTDET~00";

SQL> DROP INDEX SAPSR3."EDOPROCSINTDET~001";

And got the following error message for both:

ERROR at line 1:

ORA-01418: specified index does not exist

Then I queried the indexes for the table, but couldn't find anyone.

SQL> select

  2  b.uniqueness, a.index_name, a.table_name, a.column_name

  3  from all_ind_columns a, all_indexes b

  4  where a.index_name=b.index_name

  5  and a.table_name = 'EDOPROCSINTDET';

no rows selected

SQL> select INDEX_NAME, TABLE_OWNER, TABLE_NAME, UNIQUENESS from USER_INDEXES

  2  WHERE table_name = 'EDOPROCSINTDET';

no rows selected

If you see my error, please let me know.  This upgrade is starting to conflict with a new Implementation project (SAP ATTP), and we're urge to finish.

Thank you for taking the time!

0 Kudos

I was missing a P...


I was typing EDOPROCSINTDET instead of EDOPROCSPINTDET.


SAP Note #2354221 has a Typo.


Resolved. Thank you!!

Answers (0)