topic DBIF_RSQL_SQL_ERROR runtime error in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR runtime error

Former Member — Fri, 20 Mar 2009 11:41:31 GMT

Hi All,

I am getting a runtime error on a custom program as DBIF_RSQL_SQL_ERROR.The log from SM 21 says some deadlock has happend.

Error is coming with the following code

005060 IF NOT lt_update_yppplrout_d[] IS INITIAL.

> UPDATE yppplrout_d FROM TABLE lt_update_yppplrout_d.

005080 CLEAR lt_update_yppplrout_d.

005090 REFRESH lt_update_yppplrout_d.

005100 ENDIF.

005110

Did anything wrong in the code?

Re: DBIF_RSQL_SQL_ERROR runtime error

Former Member — Fri, 20 Mar 2009 11:43:56 GMT

There is no problem with the syntax.Deadlock is a situation wherein more than one user is trying to update the database at same time.So system will not allow it.Try to run this program again.

Re: DBIF_RSQL_SQL_ERROR runtime error

Former Member — Fri, 20 Mar 2009 11:45:16 GMT

Before updating yppplrout_d create a enquee dequee for the table and call the respective F.M

Hope it helps

Re: DBIF_RSQL_SQL_ERROR runtime error

dev_parbutteea — Fri, 20 Mar 2009 11:47:30 GMT

Hi,

- You should create a lock object for this table, if one does not exist already..

- Lock table before updating

- update table

- unlock table

Re: DBIF_RSQL_SQL_ERROR runtime error

Former Member — Fri, 20 Mar 2009 11:48:11 GMT

UPDATE yppplrout_d FROM TABLE lt_update_yppplrout_d.

the syntax you are using is correct.

Deadlock is a situation where if your porgram gets stuck it will give you dumb.

May be if simultaneously more than One user had acssed the same resoures,

Table,

Database,

Workprocess.

Check the lock objects also.

Just try to run you program again..

Regards,

Gurpreet

Re: DBIF_RSQL_SQL_ERROR runtime error

Former Member — Fri, 20 Mar 2009 12:17:24 GMT

Hi ,

Use ENQUEUE and DEQUEUE function modules before and after updating the table respectively and try.

Check in SM12 if there are any locks.

Regards,

Deepthi