Update Termination for OIJ_NOM_MAINTAIN_MULTIPLE

[Former Member]

Hi,

Getting Update Termination Message while updating the Scheduled Date of a Nomination in OIJ_NOM_MAINTAIN_MULTIPLE in Quality System, but not in Development System.

What could be the reason for this Update Termination?

Is it related to Work_Process?

Details:

Update was terminated 	

Created 	SAPEVENT:CROADR SAPEVENT:CROADRSowmya 
on 08/03/2011 10:11:08 

Update was terminated

System ID.... SQ8
Client....... 008
User..... XYZ
Transaction.. XYZ
Update key... 4E382F5FF295036BE1000000921B4E5A
Generated.... 08/03/2011, 10:11:08
Completed.... 08/03/2011, 10:11:08
Error Info... ARRAY op error: DB table=OIJBRDNOM, op=L, rc=4, lines=0

Kindly help.

Thanks & Regards,

Sowmya

[Former Member]

Hi,

Getting Update Termination Message while updating the Scheduled Date of a Nomination in OIJ_NOM_MAINTAIN_MULTIPLE in Quality System, but not in Development System.

What could be the reason for this Update Termination?

Is it related to Work_Process?

Details:

Update was terminated 	

Created 	SAPEVENT:CROADR SAPEVENT:CROADRSowmya 
on 08/03/2011 10:11:08 

Update was terminated

System ID.... SQ8
Client....... 008
User..... XYZ
Transaction.. XYZ
Update key... 4E382F5FF295036BE1000000921B4E5A
Generated.... 08/03/2011, 10:11:08
Completed.... 08/03/2011, 10:11:08
Error Info... ARRAY op error: DB table=OIJBRDNOM, op=L, rc=4, lines=0

Kindly help.

Thanks & Regards,

Sowmya

[former_member219399]

Hi,

Check if same data set up there in dev and Q systems.

The operation is failing when updating the table OIJBRDNOM, which is SPW specific functionality of TSW.

With regards,

Vamsi

[Former Member]

Thanks for your reply Vamsi. Yes, it is SPW related.

I didnt understand - how to check the data set up?

The Scheduled Date is actually getting modified in the Database Table, but in the ALV, "Update Termination" Message is appearing.

Please do suggest...

Thanks,

Sowmya

[former_member219399]

Hi,

How are you updating te nomination? using the BAPI or directly by calling any other function module?

ALso can you put the code where exactly you are getting this error. You can use trx SM13 for this analysis,

With regards,

Vams

[Former Member]

Since it is Quality System, no authorization for SM13.

Using FM's OIJ_NOM_MAINTAIN_MULTIPLE / BAPI_TRANSACTION_COMMIT to update.

sy-subrc is 0.

Code is working fine. If it is coding mistake, then it shouldn't have worked in Development System. It is perfectly working in Dev System.

As soon as it is coming out of this FM - OIJ_NOM_MAINTAIN_MULTIPLE, it is throwing this Error. Updating the Table OIJNOMI, but throwing this Error.

Please do suggest..

Thanks,

Sowmya

[Former Member]

Can someone pls help me on this issue?

Thanks,

Sowmya

[former_member219399]

Hi,

Can you please check in ST22, what is the short dump, in which indlude/FM it is giving?

Based on that may be we can do some analysis.

With regards,

Vamsi

[Former Member]

Hi Vamsi,

In ST22, there are no Dumps.

It is available only in SM13 and I dont have authorization

-Sowmya

[Former Member]

Hi Vamsi,

Please find the SM13 details.

Function Module: OIJU_BRD_UPDATE_OBJ_ENTRIES
Status: Update was terminated
Report: LOIJUU40
Row: 287
Error Details: Class: OD, Number: 001
Array op error: DB Table = OIJBRDNOM, op = L, rc=4, lines =0.

One more Update was there for different FM:

Function Module: OIJW_UPDATE_WL_NOMDBTABLES
Status: Update was terminated
Report: LOIJWF0J
Row: 68
Error Details: Class: OD, Number: 001
Array op error: DB Table = OIJWL, op=V, rc=4, lines =2.

Why is it appearing for different FM's?

Please do provide your suggestions.

Thanks & Regards,

Sowmya

[former_member219399]

Hi,

Try passing the parameter IV_UPDATE_WORKLIST = ' '. default value is 'X' here.This could be a reason.

Or try using the RFC, RFC_TSW_NOM_CHANGEFROMDATA.

With regards,

Vamsi

[Former Member]

Hi Vamsi,

Thanks for your reply.

I tried passing IV_UPDATE_WORKLIST = ' '. But still, the update termination is occurring.

DB values are updating correctly, but in ALV screen , it is throwing this 'Update Termination' message.

In Development System, it is not happening, but in Quality System, it is occurring.

What could be the reason?

Thanks & Regards,

Sowmya

[former_member219399]

Hi,

The FM OIJW_UPDATE_WL_NOM_DBTABLES is geting called in 5 places. LOIJWF03,LOIJ_NOM_COREF0V,LOIJ_REQF02

MM06EFOI_TSW_SAVE_WORKLIST_NOM,MV45AFOI_TSW_SAVE_WORKLIST_NOM. Put breakpoints in these 5 plAces. and check what is the error. You can strt update debuggin and debug the FM OIJW_UPDATE_WL_NOM_DBTABLES.

Hope this helps.

With regards,

Vamsi

[Former Member]

Hi Soumya,

For FM OIJ_NOM_MAINTAIN_MULTIPLE SAP

In general, you should :

Specify only fields that should be changed

Select fields by entering an X in the checkboxes

In the UPDATEFLAG field, enter a U for modification

Specify key fields when changing the data, including in the checkboxes

Possible UPDATEFLAGS include:

U = change

D = delete

I = add

NOTE

Minimum Entry

You must enter at least the nomination number (Field NOMINATIONNUMBER_SAP) in the structure HEADERDATA_IN for Change Nomination.

You must always enter key fields for changes.

You must always specify the update indicator in the HEADERDATA_INX

For Create Nomination (if available), required fields are like those described in RFC_TSW_

NOM_CREATEFROMDATA

Commit control

The function does not run a database commit, which means that the application must trigger the commit so that the changes are read to the database. To do this, you could use for example the function BAPI_TRANSACTION_COMMIT.

Also Check relevant objects are transported to Quality.

BR

Dep

[Former Member]

Update Termination was happening due to a READ statement with BINARY SEARCH in the Function module.

SAP has not written SORT statement before using BINARY SEARCH.

The issue was resolved after writing SORT statement before calling the Function Module OIJ_NOM_MAINTAIN_MULTIPLE.

Thanks & Regards,

Sowmya

Edited by: Sowmya Sree on Sep 23, 2011 12:15 PM