topic Re: Rollback settings. in Application Development and Automation Discussions

Rollback settings.

kowong — Mon, 16 Jul 2007 12:04:37 GMT

Dear Expert,

There are some differences of setting with my development & production system.

I was using BAPI , and without commit works statement ,

for some records, the BAPI update not successful, which is expected,

and then after, I do ,

UPDATE tableXX SET XXX = v_text WHERE XXXX = v_eXXX.

and it UPDATE tableXX successfully ... no roll back was done even the BAPI wasnt execute succesfully.

Using the same codes, in my other system, same scenario, BAPI not executed sucessfully , but the update tableXXX does not update successfully , due to the rollback happened.

I do a SQL trace and found out, there is rollback happened in one of the system, but no rollback on the other system. Both using the same program codes.

My question is , where can I see the setting, of rollback in the system, what is the TCODE? If there is such a setting.

Thank you .

From KokWei.

Message was edited by:

Kokwei Wong

Message was edited by:

Kokwei Wong

Re: Rollback settings.

Former Member — Mon, 16 Jul 2007 12:09:18 GMT

Hi kokwei,

1. I don't think there is any special setting for rollback.

2. It all depends upon the session, in which all the sql statements (or bapi updates)

happen. (in the same session)

3. If there is any ERROR statement issued, then roll back will happen immediately.

But after the rollback, if

there is any further sql update statement,

then it has its own session (for the purpose of commit and rollback),

and is totally independent of the first rollback.

regards,

amit m.

Re: Rollback settings.

Former Member — Mon, 16 Jul 2007 12:13:46 GMT

Hi,

Please check if you have "Permission Check Active" in the permissions tab of the entity service. If yes uncheck it and deploy and build.

Otherwise give the full exception chain you are getting (click on the exception message).

Take a look at this image

http://www.rwj.dk/transaction.jpg

Reward points

Regards

Re: Rollback settings.

Former Member — Mon, 16 Jul 2007 13:31:19 GMT

Hi,

Is there any parameter like extensionin in that bapi.

If so use that parameter for updation.

Thanks,

Hari.

Re: Rollback settings.

kowong — Mon, 16 Jul 2007 13:34:06 GMT

No, this is a customized table updates...

Message was edited by:

Kokwei Wong