topic Snote 1705378 implementation in Application Development and Automation Discussions

Snote 1705378 implementation

raya_hemanth — Fri, 25 Oct 2013 11:46:28 GMT

Hi,

I am trying to apply the snote 1705378. When I try to download from tcode snote, I get message this is note is not available. Also, recently I am seeing new format of snote. Has SAP changed snote implementation methods. Appreciate help in this regards.

Thanks,

~Hemanth

Re: Snote 1705378 implementation

PeterJonker — Fri, 25 Oct 2013 12:03:48 GMT

I can get the note. Here is the most important part:

Symptom

The following dump occurs when saving the results of an inspection lot:

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC
Exception CX_SY_OPEN_SQL_DB

...
The current ABAP program "SAPLQEBU" had to be terminated because one
of the statements could not be executed.
...
The termination occurred in
the ABAP program "SAPLQEBU" in "QEBU_QAMR_POSTING". The main program was
"RSM13000 ".
...

Environment

SAP Release independent

Reproducing the Issue

Call the customer specific report which uses the BAPI BAPI_INSPOPER_RECORDRESULTS
Record results for more than one characteristics
Save the results
Dump SAPSQL_ARRAY_INSERT_DUPREC occurs

Cause

The dump occurs because the system tries to insert an entry in the internal
table of the results, however this entry already exists in the
table.

Resolution

After calling the BAPI BAPI_INSPOPER_RECORDRESULTS the
BAPI BAPI_TRANSACTION_COMMIT
with parameter WAIT = 'X' has to be called. It is necessary because
'BAPI_INSPOPER_RECORDRESULTS' makes a subscription to a refresh module which is
otherwise not called.

Re: Snote 1705378 implementation

Former Member — Fri, 25 Oct 2013 12:10:12 GMT

Hi Raya,

There are no correction instructions in the note. Hence you are not able to see it via SNOTE.

Resolution (as given in Snote) is to call BAPI BAPI_TRANSACTION_COMMIT with parameter WAIT = 'X' after calling the BAPI BAPI_INSPOPER_RECORDRESULTS. It is necessary because 'BAPI_INSPOPER_RECORDRESULTS' makes a subscription to a refresh module which is otherwise not called.

Re: Snote 1705378 implementation

raya_hemanth — Sat, 26 Oct 2013 03:46:45 GMT

Thanks Leena,

We are getting this error in standard transaction QE11. Since this note is just correction instruction, I guess I have to post to SAP.

Regards,

~Hemanth Raya

Re: Snote 1705378 implementation

Former Member — Sat, 26 Oct 2013 11:24:52 GMT

Hi,

You should be able to download SAP note irrespective of correction instruction available in SAP note or note. Please check with your basis team if note is released otherwise check with SAP

Thanks

Sushil