topic Re: database update fails in Application Development and Automation Discussions

database update fails

Former Member — Tue, 19 May 2009 04:45:59 GMT

Hi All

In custom report I am updating the custom table after that I am specifying commit work statement.

As per database level updated properly after sometime itu2019s retain the old values instead of new values. What could be the root cause of the problem?

I checked the statistical analysis reports, to many work process running simultaneously for this particular user.

Thanks

KRISH

Re: database update fails

Sandeep_Panghal — Tue, 19 May 2009 04:54:48 GMT

Check the numbe rof UPD work processes and also check whether implicit ROLLBACK is not happening at some point of time .

Re: database update fails

former_member222860 — Tue, 19 May 2009 05:15:57 GMT

Try like this

In tcode: SM13, Check whether Update is active, if not click on Administration tab and activate the status.

thanks\

Mahesh

Re: database update fails

Former Member — Tue, 19 May 2009 05:30:30 GMT

Hi,

Please do the below.

Check sy-subrc after UPDATE/INSERT/MODIFY on custom table.

If sy-subrc Eq 0.

commit work.

else.

rollback.

endif.

Tanx,

Nit.

Re: database update fails

Former Member — Tue, 19 May 2009 06:05:46 GMT

This message was moderated.

Re: database update fails

Former Member — Tue, 19 May 2009 06:06:37 GMT

Hi Sandeep

I checked the statistical analysis report(STAT) for that specific user its showing background RFC executed, inside the RFC I am getting the message as given below.

Function ARFC_RUN_NOWAIT

Program: SAPLARFC

I checked the sap notes 726148 in service market place. In sap notes mentioned (Problem with RFC resource assignment).

What could be the root cause?

Re: database update fails

Former Member — Tue, 19 May 2009 06:07:04 GMT

i checked the statistical analysis report(STAT) for that specific user its showing background RFC executed.

as i am getting the message as given below

Function ARFC_RUN_NOWAIT

Program: SAPLARFC

i checked the sap notes 726148 in service market place. in sap notes mentioned ( Problem with RFC resource assignment.

what could be the root cause.

Re: database update fails

Former Member — Tue, 19 May 2009 06:07:19 GMT

i checked the statistical analysis report(STAT) for that specific user its showing background RFC executed.

as i am getting the message as given below

Function ARFC_RUN_NOWAIT

Program: SAPLARFC

i checked the sap notes 726148 in service market place. in sap notes mentioned ( Problem with RFC resource assignment.

what could be the root cause.

Re: database update fails

Former Member — Tue, 19 May 2009 06:07:31 GMT

i checked the statistical analysis report(STAT) for that specific user its showing background RFC executed.

as i am getting the message as given below

Function ARFC_RUN_NOWAIT

Program: SAPLARFC

i checked the sap notes 726148 in service market place. in sap notes mentioned ( Problem with RFC resource assignment.

what could be the root cause.

Re: database update fails

Former Member — Tue, 19 May 2009 06:07:42 GMT

i checked the statistical analysis report(STAT) for that specific user its showing background RFC executed.

as i am getting the message as given below

Function ARFC_RUN_NOWAIT

Program: SAPLARFC

i checked the sap notes 726148 in service market place. in sap notes mentioned ( Problem with RFC resource assignment.

what could be the root cause.

Re: database update fails

Former Member — Tue, 19 May 2009 06:08:05 GMT

I checked the statistical analysis report(STAT) for that specific user its showing background RFC executed, inside the RFC I am getting the message as given below.

Function ARFC_RUN_NOWAIT

Program: SAPLARFC

I checked the sap notes 726148 in service market place. In sap notes mentioned (Problem with RFC resource assignment).

What could be the root cause?

Re: database update fails

Former Member — Mon, 25 May 2009 09:26:48 GMT

solved

Re: database update fails

Former Member — Thu, 19 Aug 2010 07:24:17 GMT

Hello,

Could you please share this information how you resolved this problem.

same type of problem i am also getting kindly provide us the requisites.

Thanks in advance

Deepak