Runtime Errors DBIF_RSQL_SQL_ERROR & Exception CX_SY_OPEN_SQL_DB

[Former Member]

hi guys

we are using a custom program to run read and display some changed documents from CDHDR and CDPOS table. The program is working fine in development box but it is throwing a dump in the quality box and it gives the <b>Runtime Errors DBIF_RSQL_SQL_ERROR & Exception CX_SY_OPEN_SQL_DB</b>. Any idea what is the problem and what needs to be done?

Suresh

[Former Member]

This error is possible if the tables are too big. You can avoid this by using PACKAGE SIZE addition to your select query.

Sri

[Former Member]

Can't really tell without looking at the code. Would you post it please?

Also the Oracle (or whatever database) error number.

Rob

Message was edited by:

Rob Burbank

[Former Member]

This error is possible if the tables are too big. You can avoid this by using PACKAGE SIZE addition to your select query.

Sri