SAPSQL_ARRAY_INSERT_DUPREC in VL01n

[Former Member]

Hi all,

I had a problem with Vl01n Transaction While Creating delivery we are getting termination message

00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC . we changed the Number ranges . But it did not work. Is there any thing else that we need to do.

In st22 we are getting dump at

INSERT GLPCA FROM TABLE T_GLPCA .

Thanks & regards

sreehari p

[former_member182371]

Hi,

have a look at this OSS Note:

Note 209141 - SAPSQL_ARRAY_INSERT_DUPREC for NEW_INSERT_GLPCA

https://service.sap.com/sap/support/notes/209141

Best regards.

[former_member386202]

Hi,

Check code implemented in include exit MV45AFZZ.

Regards,

Prashant

[Former Member]

Hi Sree,

Can you paste the dump here

[Former Member]

FORM INS_GLPCA	"#EC CALLED
	TABLES P_T_TABLE
	USING  P_RECORD TYPE ANY
	P_RENUMBER_OBJ TYPE BOOLE_D.	"#EC NEEDED

  DATA: T_GLPCA LIKE GLPCA OCCURS 0 WITH HEADER LINE.

  CLEAR T_GLPCA . REFRESH T_GLPCA .

  T_GLPCA[] = P_T_TABLE[].

  IF P_T_TABLE[] IS INITIAL.

APPEND P_RECORD TO T_GLPCA .

  ENDIF.

  IF NOT P_RENUMBER_OBJ IS INITIAL.

	SORT T_GLPCA .
	CALL FUNCTION 'G_ADJUST_RECORD'
	EXPORTING
	TABELLENNAME = 'GLPCA '
	RENUMBER_OBJ = 'X'
	TABLES
	TABELLE = T_GLPCA .

  ENDIF.

  GET TIME.

  T_GLPCA-CPUDT = SY-DATUM.

  T_GLPCA-CPUTM = SY-UZEIT.

  MODIFY T_GLPCA TRANSPORTING CPUDT CPUTM

WHERE RCLNT = SY-MANDT OR RCLNT NE SY-MANDT.

  INSERT GLPCA FROM TABLE T_GLPCA .

  IF SY-SUBRC NE 0.

MESSAGE X201 WITH 'GLPCA '.

[Former Member]

Hi Sree,

Thanks. But we need ST22 dump copy to analysis the issue, like where it gets and all.

Hope you understand

[Former Member]

The above is copied from ST22 only.

1158 FORM INS_GLPCA	"#EC CALLED
1159	TABLES P_T_TABLE
1160	USING  P_RECORD TYPE ANY
1161	P_RENUMBER_OBJ TYPE BOOLE_D.	"#EC

1162   DATA: T_GLPCA LIKE GLPCA OCCURS 0 WITH HEADER LINE.

1163

1164   CLEAR T_GLPCA . REFRESH T_GLPCA .

1165   T_GLPCA[] = P_T_TABLE[].

1166   IF P_T_TABLE[] IS INITIAL.

1167	APPEND P_RECORD TO T_GLPCA .

1168   ENDIF.

1169

1170   IF NOT P_RENUMBER_OBJ IS INITIAL.

1171	SORT T_GLPCA .
1172	CALL FUNCTION 'G_ADJUST_RECORD'
1173	EXPORTING
1174	TABELLENNAME = 'GLPCA '
1175	RENUMBER_OBJ = 'X'
1176	TABLES
1177	TABELLE = T_GLPCA .

1178   ENDIF.

1179

1180   GET TIME.

1181   T_GLPCA-CPUDT = SY-DATUM.

1182   T_GLPCA-CPUTM = SY-UZEIT.

1183   MODIFY T_GLPCA TRANSPORTING CPUDT CPUTM

1184	WHERE RCLNT = SY-MANDT OR RCLNT NE SY-MANDT

>>>>>   INSERT GLPCA FROM TABLE T_GLPCA .

1186   IF SY-SUBRC NE 0.

[Former Member]

Hi Sree,

While analysis the issue from your data, there is a problem with the data that going to insert the data to the table T_GLPCA.

The matter is whenever you schedule a program in background job or run the transaction code some times the update error happens in your system. in that mean time the system inserts some of the records into the table. you can get this info from the transaction code sm12 if any update errors occured or not. and also if the resources are filled in your system the error may occur you can able to check this one in sm21.

try to run the program again and check the table if any entry is there are not. Try to debug the program and found the error.

Hope this helps.

[Clemenss]

Hi,

in the dump you will (probably) not see any Z programs in the 'list of active programs'. But (probably) your MV50 module pool will have some MV50AFZ* exit routines that insert the erroneous records. Update is done in Update task, check situation in USEREXIT_BEFORE_SAVE (or similar name).

Regards,

Clemens