topic Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions

Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Thu, 26 Sep 2013 08:31:38 GMT

Hi Experts,

When I tried to park FI document using the SAPSQL_ARRAY_INSERT_DUPREC with the help of user exit. I am getting error message as "Express document "Update was terminated" received from author. Also In ST22 getting error message as "SAPSQL_ARRAY_INSERT_DUPREC" in program "SAPLF042"

Information on where terminated

Termination occurred in the ABAP program "SAPLF042" - in "VBKPF_SCHREIBEN".

The main program was "RSM13000 ".

In the source code you have the termination point in line 163

of the (Include) program "LF042U11".

The program "SAPLF042" was started in the update system.

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

procedure "VBKPF_SCHREIBEN" "(FORM)", but it was neither handled locally nor

declared

in the RAISING clause of its signature.

Kindly advice on the solution.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Sep 2013 08:51:14 GMT

That means the following code lines are failing:

if insert_flag eq space.

modify vbkpf from table xvbkpf1.

else.

insert vbkpf from table xvbkpf1.

endif.

so you can have 2 problems:

Or you can try to insert a document already stored

Or you have duplicated records in internal table XVBKPF1

How do you park the document?

Max

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

PeterJonker — Thu, 26 Sep 2013 08:52:37 GMT

you say:

"When I tried to park FI document using the SAPSQL_ARRAY_INSERT_DUPREC with the help of user exit."

What do you mean with that ?

Can you give us the code of the user exit ?

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Thu, 26 Sep 2013 08:56:10 GMT

Hi Peter,

Please find my code in the user exit: EXIT_SAPLACC4_001

READ TABLE extension INDEX 1.

IF sy-subrc EQ 0 AND extension-field1 = 'BAPI-PARK'.

MOVE 2 TO t_acchd-status_new.

ENDIF.

Code in my program for extension:

ls_extention-field1 = 'BAPI-PARK'.

ls_extention-field2 = '1'.

APPEND ls_extention TO lt_extention.

CALL FUNCTION 'BAPI_ACC_GL_POSTING_POST'

EXPORTING

documentheader = ls_header

* IMPORTING

* OBJ_TYPE =

* OBJ_KEY =

* OBJ_SYS =

TABLES

accountgl = lt_accountgl

currencyamount = lt_currency

return = lt_return

extension1 = lt_extention.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Thu, 26 Sep 2013 08:58:45 GMT

Hi Max,

Exactly im getting error message in the insertion.

if insert_flag eq space.

modify vbkpf from table xvbkpf1.

else.

insert vbkpf from table xvbkpf1.

endif.

I am parking the document using BAPI "BAPI_ACC_GL_POSTING_POST" and exit

EXIT_SAPLACC4_001

READ TABLE extension INDEX 1.

IF sy-subrc EQ 0 AND extension-field1 = 'BAPI-PARK'.

MOVE 2 TO t_acchd-status_new.

ENDIF.

Code in my program for extension:

ls_extention-field1 = 'BAPI-PARK'.

ls_extention-field2 = '1'.

APPEND ls_extention TO lt_extention.

CALL FUNCTION 'BAPI_ACC_GL_POSTING_POST'

EXPORTING

documentheader = ls_header

* IMPORTING

* OBJ_TYPE =

* OBJ_KEY =

* OBJ_SYS =

TABLES

accountgl = lt_accountgl

currencyamount = lt_currency

return = lt_return

extension1 = lt_extention.

Please provide me solution.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Sep 2013 09:14:41 GMT

The problem is on the values of key fields of VBKPF:

AUSBK

BUKRS

BELNR

GJAHR

So I suppose the document you're trying to store has document number already used, or XVBKPF1 has 2 equal records (I means records with same key....but I don't think it because the BAPI can transfer only one header, so only one document)

Are you transfering the document number too?

Max

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Thu, 26 Sep 2013 09:44:35 GMT

Hi Max,

I am not transferring document number in the header. I am just passing BUKRS, GJAHR, BLART, BUDAT, BLDAT.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Sep 2013 09:48:10 GMT

So try to check the number range

Max

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Thu, 26 Sep 2013 10:53:20 GMT

Max,

Thanks.. Will check and let u know.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Fri, 27 Sep 2013 05:32:30 GMT

Hi Max,

The problem arises in the number range and standard program considering only the document number without fiscal year. Hence if there is any document number avail in the previous fiscal year, its showing same error. Kindly advice on this.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Sep 2013 09:12:46 GMT

Can you post a hardcopy of your number range?

Max

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Fri, 27 Sep 2013 09:32:25 GMT

Hi Max,

The above is the number range used for year 2012 and 2013 respectively.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Sep 2013 09:49:37 GMT

it seems to be ok, the last number used for 2013 is 912000428, so there's this document in your system?

After the dump the range is updated with the next number?

Max

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Fri, 27 Sep 2013 10:08:32 GMT

Yes, After dump the number range set to next one.

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Sep 2013 10:12:56 GMT

So now you should check the data in internal table xvbkpf1

You can check it by debug setting UPDATE DEBUGGING option, in this way the system should stop your program as soon as the function modules in update task are called in particular PRELIMINARY_POSTING_DOC_WRITE

Max

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

former_member196123 — Fri, 27 Sep 2013 11:41:11 GMT

Hi Max

As per your reply, I put an update debug over there and System also stop at the PRELIMINARY_POSTING_DOC_WRITE. How to over come the error..

Re: Park FI document - getting error as SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Sep 2013 13:55:23 GMT

You shoud go to the code line just before the INSERT (where the dump occurs)....and when you're here check what the table xvbkpf1 has.

if insert_flag eq space. <------Stop here and check the internal table xvbkpf1

modify vbkpf from table xvbkpf1.

else.

insert vbkpf from table xvbkpf1.

endif.

Max