on 01-23-2012 9:54 AM
Hi,
I have a Background Job SM:SELFDIAGNOSIS triggered on daily basis and getting cancelled due to dump.
Below is the dump and the program that is involved in the job. I analysed the dump which asks
DUMP***********************************************
Short text
A row with the same key already exists.
What happened?
Error in the ABAP Application Program
The current ABAP program "CL_DSWP_SD_DIAGNOSE_CONSISTENTCP" had to be
terminated because it has
come across a statement that unfortunately cannot be executed.
Error analysis
An entry was to be entered into the table
"\CLASS=CL_DSWP_SD_DIAGNOSE_CONSISTENT\METHOD=CHECK_USERS_BP\DATA=LT_USCP"
(which should have
had a unique table key (UNIQUE KEY)).
However, there already existed a line with an identical key.
The insert-operation could have ocurred as a result of an INSERT- or
MOVE command, or in conjunction with a SELECT ... INTO.
The statement "INSERT INITIAL LINE ..." cannot be used to insert several
initial lines into a table with a unique key.
Information on where terminated
Termination occurred in the ABAP program "CL_DSWP_SD_DIAGNOSE_CONSISTENTCP" -
in "CHECK_USERS_BP".
The main program was "RDSWP_SELF_DIAGNOSIS ".
In the source code you have the termination point in line 63
of the (Include) program "CL_DSWP_SD_DIAGNOSE_CONSISTENTCM00M".
The program "CL_DSWP_SD_DIAGNOSE_CONSISTENTCP" was started as a background job.
Job Name....... "SM:SELFDIAGNOSIS"
Job Initiator.. "ADMINUSER"
Job Number..... 01171100
System environment
SAP-Release 701
Application server... "SOLMAN"
Network address...... "192.168.100.17"
Operating system..... "Windows NT"
Release.............. "6.1"
Hardware type........ "24x AMD64 Level"
Character length.... 16 Bits
Pointer length....... 64 Bits
Work process number.. 12
Shortdump setting.... "full"
Database server... "SOLMAN"
Database type..... "DB6"
Database name..... "SSM"
Database user ID.. "SAPSSM"
Terminal.......... " "
Char.set.... "C"
SAP kernel....... 701
created (date)... "Apr 4 2011 00:05:43"
create on........ "NT 5.2 3790 Service Pack 2 x86 MS VC++ 14.00"
Database version. "DB6_81 "
***********************************************BACKGROUND JOB LOG**************************************
Job log overview for job: SM:SELFDIAGNOSIS / 01171100
Date Time Message text
23.01.2012 01:36:52 Job started
23.01.2012 01:36:52 Step 001 started (program RDSWP_SELF_DIAGNOSIS, variant &0000000000073, user ID ADMINUSER)
23.01.2012 01:37:34 Internal session terminated with a runtime error (see ST22)
23.01.2012 01:37:34 Job cancelled
*************************************************************************************************************************
Please let me know the where the issue might be..
Thanks & Regards
PRAVEEN
Hi,
chk this note applicable for you
[Note 1110211 - SM:SELFDIAGNOSIS terminates with SAPSQL_ARRAY_INSERT_DUPREC|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1110211]
Thanks,
Jansi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
We find the solution with implement below note in sequence
1546550 00079: Check user business partner creation - performance
1565431 00079: Check user business partner creation - performance
Please be informed that it may take about 1-2 days to activate these
changes of the notes.
Thanks and Best Regards,
Yudi
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.