cancel
Showing results for 
Search instead for 
Did you mean: 

duplicate key errors during insert into table T5HVXS occured

former_member206167
Active Participant
0 Kudos

Hi dear SAP Gurus,

    I'm facing this issue while installing addon HC-CEE110

\\Valquiria\sapmnt\trans\log\SAPI-11005INHRCEE.DCD

Start import R3TRTABUT5HVXS ...

different nametabs for table T5HVXS (field ENDDA).

    Existing Field  Imported Field

      keypart: 'X'  'X'

      len    : 008  008 (chars)

      offset : 001  000 (chars)

      format : 'D'  'D'

different nametabs for table T5HVXS (field BLOKK_ORDER).

    Existing Field  Imported Field

      keypart: 'X'  'X'

      len    : 002  002 (chars)

      offset : 009  008 (chars)

      format : 'N'  'N'

      table T5HVXS: entry in DB is 2 bytes bigger than in file.

      ... ignoring such differences.

16 duplicate key errors during insert into table T5HVXS occured

End import R3TRTABUT5HVXS (with warnings)

OS:Windows2008 R2

DB: DB2 9.7 FP4

ERP: 6.0 EHP 6

kind  regards, thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

shashisingh
Participant
0 Kudos

Hi,

Just check with some other r3trans version. I have faced many times and solved it by updatting r3trans.

Othere also have solved by this solution only

see this link

http://scn.sap.com/thread/3203562

Thanks,

Shashi

former_member206167
Active Participant
0 Kudos

Hi,

    Problem solved in this way.

SAP Note 1045021 - Known problems with Supp.Packages in


HR-CEE Rel.110_600

    My error was in SAPI-11005INHRCEE.DCD    but above note has two allow files, one for SP 02 and other for SP03 so I copied to A-11005INHRCEE and then copied errors in this way:

I 2EETW000 18 duplicate key errors during insert into table T5HVXS occured

I 2EETW000 18 duplicate key errors during insert into table T5HVXS~ occured

K 2EETW000 18 duplicate key errors during insert into table T5HVXS occured

K 2EETW000 18 duplicate key errors during insert into table T5HVXS~ occured

    So the Support PAckage ignored errors and went smooth.

Thanks for your kind help

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jose,

Are you installing HR-CEE110 ?

If yes, please have a look into

Note 1045021 - Known problems with
Supp.Packages in HR-CEE Rel.110_600

Regards,

Vishal

former_member206167
Active Participant
0 Kudos

Hi dear Vishal,

    Thanks for the reply, yes I implemented solution in Note 1045021 - Known problems with
Supp.Packages in HR-CEE Rel.110_600


  • SAPK-11003INHRCEE

           Symptom:

If You import SAPK-11003INHRCEE

"1 duplicate

key error during insert into table T5HVXS occured"

           Solution:
Use ALLOW file A-11003INHRCEE. SAP
(attachment)


  • SAPK-11002INHRCEE

           Symptom:
If You import SAPK-11002INHRCEE
"1 duplicate
key error during insert into table T7TRS03 occured"
"1 duplicate key error
during insert into table T7CO25 occured"

But actually error occurs in SAPK-11005INHRCEE, I can't find an allow file for this Support Package, any idea?

thanks in advance

Former Member
0 Kudos

Hello Jose,

Please make sure you are using correct ADDON for your ECC system.

As you said your's is ECC 6.0 EHP6, I am afraid  you are not using a correct addon.

Please find the PAM for your addon:-

I think you should install SAP HR-CEE 110_604 instead of SAP HR-CEE 110_600 for your ECC version.



Regards,

Vishal

former_member206167
Active Participant
0 Kudos

Dear Vishal,

    Thanks for your smooth response but after install ERP, it comes with components:

SAP_APPL 606 0000      - Logistics and Accounting

SAP_HR 600 0064 SAPKE60064 Human Resources

    At this point I can't change the procedure because it's in phase IMPORT_PROPER,

any workaround?

kind regards

shashisingh
Participant
0 Kudos

UPdate R3trans.

Thanks,

Shashi

former_member206167
Active Participant
0 Kudos

Shashi, thanks for your answer, I updated tp and R3trans to the latest available in Market Place and the error is the same

thanks in advance