SAPSQL_ARRAY_INSERT_DUPREC error in ST22

[Former Member]

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

[former_member524429]

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

[Former Member]

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 ...

[Former Member]

Hi,

We are having the same dump and our production system is similar to your system, but HP-UX.

Have you got any help or solution to this dump?

Many thanks!!

[fjhernanz]

Hi,

Do you get this dump as a result of running any batch job?

Br,

Javier

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Prateek,

Thank you very much for your information, but kernel patch is not planified in this moment.

As the dump seems not to be critical, we'll wait.

Br,

Martina