topic Re: Update/Modify Statement Failing in Application Development and Automation Discussions

Update/Modify Statement Failing

Former Member — Thu, 14 Jul 2011 03:42:12 GMT

Hi All,

Recently we have come across a strange situation where-in the UPDATE/Modify Statement is failing quite often.

Ex:

MODIFY zpp080e FROM gs_zpp080e.

UPDATE ZDUBFRREQUESTH

SET STATUS = V_NEW_STATUS

APPROVED_DATE = V_APPROVED_DATE

APPROVED_TIME = V_APPROVED_TIME

WHERE REQUESTNR EQ REQUESTNR.

Please note that these programs have been running perfectly for last 4years and offlate this is happening (last 3months) and this occurance is not regular but happens on random days with only few records in whole lot.

I was wondering what could have been wrong wtih the same program to behave suddenly like this? Note worthy point here is, our system has undergone KERNAL UPGRADE and to we observed this pattern IS OBSERVED AFTER THAT ...

Any kind of help in giving various possible reasons will be highly appreciated.

Thanks a lot,

Rgds,

Lakshmi

Re: Update/Modify Statement Failing

Former Member — Thu, 14 Jul 2011 10:55:28 GMT

Hi,

is this problem only valid for z tables or do you have update terminations in standart transactions.

if only z tables,

go to se11 tr.display z table.

utilities -> database object -> check

if there is an inconsistency u will see by this way.

go to tr se14,

activate and adjust database for these z tables.

for preventing data loss, select "Save Data" radiobutton .

and the last option,

write "commit work" statement under your modify and update commands.

Best regards,

Burak

Re: Update/Modify Statement Failing

Former Member — Thu, 14 Jul 2011 11:59:35 GMT

You have pointed to two different problems. Why does the modify fail? What does the short dump (?? guess you got one) tell you?

The second probably arises from attempting to insert a duplicate (of key values) into the database table.

Post details from your short dump.

Re: Update/Modify Statement Failing

Former Member — Thu, 14 Jul 2011 14:59:22 GMT

Moderator message - Duplicate post locked Rob