topic Re: Short Dump CX_SY_OPEN_SQL_DB in Application Development and Automation Discussions

Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 08:14:44 GMT

Hi experts,

While inserting data into a SE11 table, i am getting the following short dump.

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Except. CX_SY_OPEN_SQL_DB

Before inserting data, i am sorting my internal table and deleting adjacent duplicates by primary keys and secondary indexes.

Is there any workaround to fix my issue.

Thanks.

Amine

Re: Short Dump CX_SY_OPEN_SQL_DB

nabheetscn — Wed, 16 Oct 2013 08:24:33 GMT

Basically a data exists in database with the same key. so better first check if you want to update it if yes then please use Modify statement.

Re: Short Dump CX_SY_OPEN_SQL_DB

former_member201275 — Wed, 16 Oct 2013 08:26:16 GMT

Is your table empty to start with? Maybe there is already an existing entry in the table and therefore you get this message?

Re: Short Dump CX_SY_OPEN_SQL_DB

sivaganesh_krishnan — Wed, 16 Oct 2013 08:27:58 GMT

HI Amine,

Check the SAP Notes : 196113 - SAPSQL_ARRAY_INSERT_DUPREC,table BALHDR

Regards,

Sivaganesh

Re: Short Dump CX_SY_OPEN_SQL_DB

snipersap — Wed, 16 Oct 2013 08:30:19 GMT

Dear Amine,

Please take the data that you are trying to insert in a excel sheet.

Find the column which are primary key in your table and mark them in the excel sheet.

Copy the data and put them in the respective fields of the table in SE16.

If you find any output, then these are the entries which already exist in your table while you are trying to insert them via your program.

Solution:

Either correct your program or remove the found entries from the table before inserting them again from your program.

Regards

Soumyojyoti Pal

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 08:31:30 GMT

Hi Nabheet,

To be more specific, here the syntax that i am using:

Sort internal table.

Delete adjacent duplicates from internal table comparing primary keys and secondary indexes

insert SE11table from table my internale table.

Do you see any thing wrong?

Amine

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 08:32:27 GMT

Hi Glenn,

My table is empty of course. I delete the data from it in my program before inserting it again.

Amine

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 08:33:30 GMT

Hi Pal,

The treatment has to be dynamic

Amine

Re: Short Dump CX_SY_OPEN_SQL_DB

nabheetscn — Wed, 16 Oct 2013 08:34:45 GMT

You are deleting the data from the Database table in your program i believe if that is the case after deleting did you do a Commit?

Re: Short Dump CX_SY_OPEN_SQL_DB

anupam_anand — Wed, 16 Oct 2013 08:36:05 GMT

Hi Amine,

Try using MODIFY instead of INSERT. In case the entries are found, Modify will overwrite them.

Incase all the entries, already exist, you can also use Update.

Thanks,

Anupam

Re: Short Dump CX_SY_OPEN_SQL_DB

former_member201275 — Wed, 16 Oct 2013 08:37:16 GMT

Please can you post your code, and provide a screenshot of your table.

Re: Short Dump CX_SY_OPEN_SQL_DB

former_member201275 — Wed, 16 Oct 2013 08:38:49 GMT

I agree with a lot of the other responses in terms of using MODIFY command. This should do the trick. Have you tried this?

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 10:31:10 GMT

Yes Nabheet.

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 10:39:05 GMT

I tried modify. It worked, i have no more short dump.

But the number of data in my se11 table is now false, i have only one record instead of 7728 ones.

May be i should decrease the number of keys?!

Amine

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 10:53:25 GMT

Here the code Glen:

SORT wt_report2 BY comp_code costcenter chrt_accts gl_account costelmnt /bic/y_tprtnr co_area profit_center y_labbu y_labdiv y_program part_prctr y_labprbu y_ptnrdiv doc_currcy loc_currcy funcarea fiscper version.

DELETE ADJACENT DUPLICATES FROM wt_report2 COMPARING comp_code costcenter chrt_accts gl_account costelmnt /bic/y_tprtnr co_area profit_center y_labbu y_labdiv y_program part_prctr y_labprbu y_ptnrdiv doc_currcy loc_currcy funcarea fiscper version.
*DELETE ADJACENT DUPLICATES FROM wt_report2 COMPARING all fields.
IF NOT wt_report2 IS INITIAL.
INSERT ycnv_report FROM TABLE wt_report2.
ENDIF.

The underlined fields are my secondary indexes. The other ones are my primary keys.

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 10:55:08 GMT

Here an extract of my internal table in debug. Actually i have many empty records because i'm on a dev system, that might be the reason:

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 10:57:00 GMT

Here the definition of my secondary indexes, tell me please if you see smthg wrong.

Thx

Re: Short Dump CX_SY_OPEN_SQL_DB

RaymondGiuseppi — Wed, 16 Oct 2013 11:08:24 GMT

You delete records having identical set of primary keys AND secondary keys (indexes), Do not, you must insure uniqueness for every unique index. Here you can keep two records with same primary keys if one secondary key differs.

So sort and delete comparing ONLY primary keys, then do the same for every index with unique key, but only with keys of one index for each deletion of duplicates.

Regards,

Raymond

Re: Short Dump CX_SY_OPEN_SQL_DB

RaymondGiuseppi — Wed, 16 Oct 2013 11:11:24 GMT

So you can only have a single record for one funcarea/fisper/version set ?

Re: Short Dump CX_SY_OPEN_SQL_DB

Former Member — Wed, 16 Oct 2013 11:15:52 GMT

Hi Raymond,

You mean i have to do this:

sort internal table by primary keys.

delete adjacent duplicates comparing primary keys.

sort internal table by secondary indexes.

delete adjacent duplcates comparing secondary indexes.

right?

thanks.

Amine