Snote 1705378 implementation

[raya_hemanth]

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

[PeterJonker]

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

1. Call the customer specific report which uses the BAPI BAPI_INSPOPER_RECORDRESULTS
2. Record results for more than one characteristics
3. Save the results
4. 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.

See Also

function module QEBU_QAMR_POSTING
...
243 *- Verbuchung der
Ergebnistabellen
>>>>> INSERT QAMR FROM TABLE QAMR_INSERT_TAB.
245 IF
SY-SUBRC <> NULL.
246 RAISE ERROR.
...

[Former Member]

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.

[raya_hemanth]

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

[Former Member]

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