Error while extracting data from datasource 0GLACCEXT_T011_HIER in RSA3

[Former Member]

Hi Experts,

While trying to extract the data for the datasource 0GLACCEXT_T011_HIER in RSA3, am getting the below Dump.

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Except. CX_SY_OPEN_SQL_DB

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 "SAPLFAGL_FSV" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "FSV_TEXTS_CONVERT" "(FORM)", nor was it propagated by a RAISING

clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

Kindly help me out in resolving this error.

[Former Member · Accepted solution]

Hi,

Implement the correction given in the note 481846.

Reason and Prerequisites

In the list of hierarchies provided for the extraction, you find entries where the Valid-to-date is smaller than the Valid-from- date

Regards,

Anil Kumar Sharma .P

[Former Member]

Hi Experts,

Thanks for all your inputs.

The issue is resolved. There was some SQL error in the standard program.

We have implemented the SAP Note: 1158109

It worked!!!

Regards,

A.Rohini

[Former Member]

Hi All,

Thank you very much for your reply. Am taking input from each of your response. Will let you know once my issue is resolved.

[Former Member]

Hi,

Check following SAP Notes,

Note 760460 - VL10: Runtime error SAPSQL_ARRAY_INSERT_DUPREC in SAPLV05I

Note 767009 - BORGR Short dump w/ error SAPSQL_ARRAY_INSERT_DUPREC

Regards,

Durgesh.

[Former Member]

Hi,

This dump occurs if the storage of original files is not happening in a Content Server, which is recommended by SAP. You can check this easily if you go to transaction DC10 and check if the flag 'Use KPRO' is set for the used document type.

SAP do not recommend storing such larger files in SAP DB. If you try to store any original in the SAP DB, the file will be stored in the table DRAO. That means you are consuming table space memory. For one original we can have maximum of 9999 rows in the table. To store larger originals in SAP DB more than 9999 rows in the table are needed and this is not possible. That's the reason behind this dump. Storing such huge files inthe SAP DB will also affect the performance of the system while accessing the original

Refer the thread

"http://wiki.sdn.sap.com/wiki/display/PLM/SAPSQL_ARRAY_INSERT_DUPRECwhilesaving+original"

Thanks,