on 05-05-2010 5:27 AM
Dear all,
We have CI and 2 Dialog instanence in Prod Environment .
Oracle 10g , AIX and Ecc6.0 .
past 2 days i am getting the below error on Application 1 error .
Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Exception CX_SY_OPEN_SQL_DB
Date and Time 05.05.2010 00:30:57
Short text
The ABAP/4 Open SQL array insert results in duplicate database records.
What happened?
Error in the ABAP Application Program
The current ABAP program "SAPLSLIM_CNT" had to be terminated because it has
come across a statement that unfortunately cannot be executed.
What can you do?
Note down which actions and inputs caused the error.
To process the problem further, contact you SAP system
administrator.
Using Transaction ST22 for ABAP Dump Analysis, you can look
at and manage termination messages, and you can also
keep them for a long time.
Kindly suggest me
Regards
Hi,
Its a normal dump & the possible cuase is already mentioned in that posted dump info.
The ABAP/4 Open SQL array insert results in duplicate database records.
Share your SAP_BASIS, SAP Kernel & DB release level info.
You will have to analyze the action(s) in you SAP system, which are rasing such dump. Then according to the actions try to find relevant sap notes, as there are lot of sap notes u will find for such dump.
Usage of Installed SAP system ?
Regards,
Bhavik G. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhavik G. Shroff,
SAP ECC 6.0 ,Oracle 10G , AIX
SAP Support patch release :
SAP_ABA 700 0017 SAPKA70017 Cross-Application Component
SAP_BASIS 700 0018 SAPKB70018 SAP Basis Component
PI_BASIS 2005_1_700 0017 SAPKIPYJ7H PI_BASIS 2005_1_700
ST-PI 2005_1_700 0002 SAPKITLQI2 SAP Solution Tools Plug-In
SAP_BW 700 0019 SAPKW70019 SAP NetWeaver BI 7.0
SAP_AP 700 0014 SAPKNA7014 SAP Application Platform
SAP Kernal Patch :
Kernel Patch number : 246
DBSL Patch No. : 241
Kindly suggest ...
Hi,
The dump doesn`t point to any job and the client where it's generated is 000:
User and Transaction
Client.............. 000
User................ "SAPSYS"
Language key........ "S"
Transaction......... " "
Transactions ID..... "4BF64BEB79450E9BE1000000C0A84866"
Program............. "SAPLSLIM_CNT"
Screen.............. "SAPMSSY0 1000"
Screen line......... 6
Information on where terminated
Termination occurred in the ABAP program "SAPLSLIM_CNT" - in
"SLIM_CNT_CONSOLIDATE_COUNTERS".
The main program was "RSUVM018 ".
In the source code you have the termination point in line 106
of the (Include) program "LSLIM_CNTU02".
The program "SAPLSLIM_CNT" was started as a background job.
Job Name....... " "
Job Initiator.. " "
Job Number..... " "
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "SLIM_CNT_CONSOLIDATE_COUNTERS" "(FUNCTION)", but it was neither
handled locally nor declared
in the RAISING clause of its signature.
The procedure is in program "SAPLSLIM_CNT "; its source code begins in line
1 of the (Include program "LSLIM_CNTU02 ".
I've observed the dump in alternate days, not all days and without any periodicity.
I've been looking for SAP notes in sapnet and in forums, but I didn't find anything similar.
Thank you very much!!!
BR,
Martina
Dear all ,
pls check the below information . I got error in 000 Client and User SAPSYS .
User and Transaction
Client.............. 000
User................ "SAPSYS"
Language key........ "E"
Transaction......... " "
Transactions ID..... "4BDE3D39ADB40061E10080000A36912
Program............. "SAPLSLIM_CNT"
Screen.............. "SAPMSSY0 1000"
Screen line......... 6
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satheesh,
Do you have some feedback in this issue? I'm having the same problem and curiously same time around 00:30h.:
Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Exception CX_SY_OPEN_SQL_DB
Date and Time 05.05.2010 00:31:17
I've the dump in other dates too.
Have you put a sap message about it?
Thanks in advance.
Br,
Martina
Hi Martina/Satheesh,
I checked your dumps and there is not much info on what/when they are comming (i.e. while running any t-code or any batch job for anything in BDC) except one thing the report name "SAPLSLIM_CNT". Apart of this you have one thing common that your erorr msg is coming on SAPMSSY0 screen and 1000 screen number.
I checked on internet and come to this conclusion that you need to upgrade your Kernel/Patch your SP for Basis to the latest one.. as there are few programs which are being called by Kernel and at some regular time... for example.
Your main Program is RSUVM018 System Measurement: Consolidate Counters TUCNTRAW -> TUCNT (AutoABAP)
Package=SLIM
Application=Basis.
This report is started by AutoABAP every 15 minutes. It really & does something on the first run per day only (controlled by an & entry in the TUCON table) & It consolidates the object counters from table TUCNTRAW into TUCNT.
Other programs being called by Kernel for same thing what they call them as AutoABAP.
SAPLSWW_CCMS:
SAPLSWEP:
SAPLSUSR: Used to fill the data in SAP like default lang. username type of user...
Hope it will be usefull for you...all the best Replace your Kernel/Patch your Basis and everything will be ok... "we can only hope and there is nothing bad in trying"
Edited by: prateek_y on May 26, 2010 2:42 PM
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.