topic Re: How to resolve DBIF_RSQL_SQL_ERROR error? in Application Development and Automation Discussions

How to resolve DBIF_RSQL_SQL_ERROR error?

Former Member — Fri, 08 Feb 2008 11:45:13 GMT

Dear Friends,

I got following dump in production system.I have to resolve it urgent basis.Plrase suggest me possible way.

Runtime Error DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Occurred on 07.02.2008 at 20:00:23

Error analysis

An exception occurred. This exception is dealt with in more detail

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB'

neither

caught nor passed along using a RAISING clause, in the procedure "C

Since the caller of the procedure could not have expected this exce

to occur, the running program was terminated.

The reason for the exception is:

The problem has arisen because, within the database interface,

one of the data buffers made available for the INSERT (UPDATE)

is longer than the maximum defined in the database.

On the other hand, it may be that the length in the NAMETAB

does not match the maximum length defined in the database.

(In this case, the length in the NAMETAB is longer.)

Regards

Ricky

Re: How to resolve DBIF_RSQL_SQL_ERROR error?

Former Member — Fri, 08 Feb 2008 11:48:37 GMT

Hi ricky,

Can you post the code where you are using INSERT / UPDATE statemetns

Are the database table and internal table structures same when you are using the above stataments, they should be the same, check out

Re: How to resolve DBIF_RSQL_SQL_ERROR error?

Former Member — Fri, 08 Feb 2008 11:50:33 GMT

Hi,

Structure are same and it was running successfully till 06.02.2008 but got dump on yesterday itself.

010920 LOOP AT WA.

010930 DELETE FROM YMATPRICNG WHERE WERKS = WA

010940 * AND MATNR = WA-MA

010950 * AND MAKTX = WA-MA

010960 * AND V_BPMNG = WA-

010970 * AND V_BAMNG = WA-

010980 * AND V_INCREASE =

010990 * AND V_DECREASE =

011000 * AND INCREASE1 = W

011010 * AND DECREASE1 = W

011020 * AND NET = WA-NET.

011030 ENDLOOP.

> MODIFY YMATPRICNG FROM TABLE WA.

011050 *******************************************

011060 ***END OF TABLE UPDATING LOGIC BY HITESH*

011070 ENDFORM. "CSM

011080

011090

Re: How to resolve DBIF_RSQL_SQL_ERROR error?

Former Member — Fri, 08 Feb 2008 11:55:02 GMT

Hi,

I hope error is in the DELETE statement

DELETE FROM YMATPRICNG WHERE WERKS = WA

here WA has so many fields and you are equating WERKS to WA

try something like this

DELETE YMATPRICNG FROM WA

OR uncomment all the lines which were commented

Re: How to resolve DBIF_RSQL_SQL_ERROR error?

Former Member — Fri, 08 Feb 2008 12:03:22 GMT

Hi,

I think this is because of change of sequence of fields in update

or missing filed in table or in code

please verify

Regards

Shiva

Re: How to resolve DBIF_RSQL_SQL_ERROR error?

Former Member — Fri, 08 Feb 2008 18:38:12 GMT

It could be that you are trying to delete too much data between database COMMITs. Try doing it in smaller bits.

Rob