Error SPAM SAPKE60016

[Former Member]

Hi Guru,

Need ur help on this, I was applying SAP_HR from SAPKE60006 to SAPKE60021 and got this error at IMPORT_PROPER phase :

Error during executing the tp command 'tp R3I all PD1 ...'

tp return code: '0008' , tp message: 'A tool used by tp produced errors' , tp output:

This is tp version 372.03.35 (release 700)

ERROR: stopping on error 8 during MAIN IMPORT

stopping on error 8 during MAIN IMPORT

tp returncode summary:

TOOLS: Highest return code of single steps was: 8

WARNS: Highest tp internal warning was: 0118

standard output from tp and from tools called by tp:

This is R3trans.exe version 6.14 (release 700 - 29.05.07 - 13:40:00).

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

R3trans.exe finished (0008).

Details of the error situation can also be found in the import logs

Interrupt the import due to an error situation (12.01.2008, 18:23:49)

Display detailed informations concerning the error in phase 'IMPORT_PROPER'

Abort the import due to an error situation (12.01.2008, 18:24:13)

any ideas how to solve this?

TQ

[Former Member]

Solved!

Turns out the duplicate key error can be ignored.I just need to create a file : AE<version No.>.SAP and put details as below:

K 2EETW000 1 duplicate key error during insert into table T7DEPBSXXAWE0A occured

I 2EETW000 1 duplicate key error during insert into table T7DEPBSXXAWE0A occured

Save it, put it in dir_trans/cofile and run again.

Rgrds

[Former Member]

Hi hazrienne,

While trying to apply APPL SP 18, I receive the foll. error message,

" 3 Duplicate key errors during insert into table TABDIRDEVC"

Please let me known what is the solution to fix this issue. I would be happy if you could post a reply ASAP.

Awaiting your reply.

[ulrich_auer]

Hello Balakrishnan S,

concerning the "duplicate key" problem on TABDIRDEVC. This is the same symptom, but the root cause is probably dgfferent. It you do not find the solution in note 1004030, please open a OSS message and send it to BC-CTS-TLS.

Best regards, Uli Auer

[Former Member]

Just like Ulrich stated, using the latest R3trans will resolve the error. It worked for us.

[Former Member]

Same thing

[markus_doehr2]

Since the import was already started, you can´t reset the queue - we have to find out what is causing that problem.

You may see one of the causes described in

Note 1074030 - R3trans: "Duplicate key" composite SAP note (as of Rel 6.10)

Which version of R3trans are you using? (R3trans -v as adm)

Markus

[Former Member]

Hi,

The current R3trans version is 6.14 (patch number 137). Im looking at sapnote 626915 now. Seems like this is on DB level..any idea?

[Former Member]

Hi hazrienne,

Have you resolved the issue, even I am also facing the issue. If you have found out the solution pls let me know what to fix the issue. We encountered the issue while applying Application patch level 19.

[Former Member]

Hi,

Still the same error, think my brain gonna explode anytime now..the only thing that are similar to my error is based on the notes Markus gave me -1074030 :

o If table entries are transported via transport object R3TR VDAT, and if one of the tables contains key fields that are not contained in the view, duplicate entries may also occur because the fields that are not contained in the view are initialized. In this case, the import log displays the following warning:

3WETW688 insert a viewentry: keyfield ... of table ... not part of view ...

o Solution: Define the view in a way that all key fields of the tables concerned are visible, and repeat the import.

Need help from abaper for this, if you can solve this pls let me know too

[Former Member]

Hi.

Currently I have installed the SAPKE60016 Support Package. I hope help you.

You are trying to install between SAPKE60006 and SAPKE60016, so you MUST HAVE the following support packages installed.

SAP Application Platform ( SAPKNA7007 )

SAP NetWeaver BI 7.0 ( SAPKW70010 )

Try again

If not, I really recommend you install ONLY ONE support package AT TIME.

Please, reward points.

I send you the Requirements for every Support Package

SAPKE60006

SAP_HR,600

SAPKE60005

SAPKE60007

SAP_HR,600

SAPKE60006

SAPKE60008

SAP_HR,600

SAPKE60007

SAPKE60009

SAP_HR,600

SAPKE60008

SAPKNA7006

SAPKW70009

SAPKE60010

SAP_HR,600

SAPKE60009

SAPKE60011

SAP_HR,600

SAPKE60010

SAPKE60012

SAP_HR,600

SAPKE60011

SAPKE60013

SAP_HR,600

SAPKE60012

SAPKE60014

SAP_HR,600

SAPKE60013

SAPKE60015

SAP_HR,600

SAPKE60014

SAPKE60016

SAP_HR,600

SAPKE60015

SAPKNA7007

SAPKW70010

[ulrich_auer]

Hello everybody who applies SAPKE60016,

the root cause of this duplicate key problem was that the table column T7DEPBSXXAWE0A.EMPF_ART was converted into a key field (previously it has been a data field). R3trans was not able to handle that situation properly.

Now we provided a R3trans patch for this on the SAP Service marketplace. Use R3trans version 07.03.08 or later for import, and the error will no longer occur. This solution is also described in the new section 3.d) in OSS note 1074030.

The advantage of the R3trans based solution is that the two entries for table T7DEPBSXXAWE0A will be imported successfully, while the described workaround (creating an "allowfile") only fades out the R3trans error message.

Best regards, Uli Auer

development architect at SAP

change management tools

Edited by: Ulrich Auer on Apr 11, 2008 9:59 AM

[Former Member]

Still the same error : 1 duplicate key error during insert into table T7DEPBSXXAWE0A occured

.

[Former Member]

Hi,

3 things.

1. Is your SPAM upto date

2. Make sure that there are no dependencies left when applying an SAP_HR SP.

3. Open a call with SAP since the SP is a SAP Standard SP and should not result in any error.

Thanks

Adil

[Former Member]

Hi,

1. Is your SPAM upto date

- The current SPAM Level is 24 ( which is the latest I think)

2 . Make sure that there are no dependencies left when applying an SAP_HR SP.

- There's no dependencies on SAP_HR. I already check.

Is there anyway that I could reset this and apply the different things first?

[Former Member]

Hi

Go to SPAM > Utilities > Disassemble Support Packages

Thanks

Adil

[markus_doehr2]

Check your import log (as advised).

Use in SPAM the menu to step to

Goto - import logs - queue

Markus

[Former Member]

Hi Markus,

Here are the import logs, does it related to the tables? any sapnotes I can refer to :

R3TRVIEWV_T7DEPBSNV0C was not imported in this step

R3TRVIEWV_T7DEPBSNV0D was not imported in this step

R3TRVIEWV_T7DEPBSXXAWE01 was not imported in this step

R3TRVIEWV_T7DEPBSXXAWE0A was not imported in this step

R3TRVIEWV_T7RU9A_GRP was not imported in this step

R3TRVIEWV_T7RU9GP was not imported in this step

R3TRVIEWV_T7RU9GRP was not imported in this step

R3TRVIEWV_T7RU9PAR was not imported in this step

R3TRVIEWV_T7RU9PAR_VAL was not imported in this step

R3TRVIEWV_T7RU_99FF was not imported in this step

R3TRVIEWV_T7RU_99FFC was not imported in this step

R3TRVIEWV_T7RU_99FFC_R was not imported in this step

R3TRVIEWV_T7RU_99FF_R was not imported in this step

E071-LOCKFLAGs 005541 - 005541 updated ('1', 1 entries).

SAPKE60016 touched.

293 293

COMMIT (15827091).

15827091 bytes read.

Transport overhead 23.0 %.

Data compressed to 10.2 %.

Duration: 4 sec (3956772 bytes/sec).

1 0

Summary:

293 bytes modified in database.

[dev trc ,00000] Sat Jan 12 18:23:48 2008 4655831 4.655831

[dev trc ,00000] Disconnecting from ALL connections: 11 4.655842

[dev trc ,00000] Disconnected from connection 0 1315 4.657157

[dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=2)

25 4.657182

[dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

17 4.657199

Disconnected from database.

End of Transport (0008).

date&time: 12.01.2008 - 18:23:48

1 warning occured.

1 error occured.

Main import

End date and time : 20080112182348

Ended with return code: ===> 8 <===

TQ

[markus_doehr2]

The error must be further above... you don´t see a "red" entry?

Markus

[Former Member]

Hi,

This is the only first error on the import logs before that last one :

Start import R3TRVDATV_T7DEPBSXXAWE0A ...

... ignoring such differences.

0 entries from T7DEPBSXXAWE0A (00001DEAN ) deleted.

T7DEPBSXXAWE0A table class is 'C'. Entries are only imported to client '000'.

1 duplicate key error during insert into table T7DEPBSXXAWE0A occured

End import R3TRVDATV_T7DEPBSXXAWE0A (with warnings)

[markus_doehr2]

This is just a warning (returncode 4) - did you try to just repeat the installation?

Markus

[Former Member]

I've tried many times, I'm downloading a new R3Trans right now and wanna try again