topic Runtime Errors DBIF_RSQL_SQL_ERROR & Exception CX_SY_OPEN_SQL_DB in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/runtime-errors-dbif-rsql-sql-error-exception-cx-sy-open-sql-db/m-p/2905803#M683560 <HTML><HEAD></HEAD><BODY><P>hi guys </P><P>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 &lt;b&gt;Runtime Errors DBIF_RSQL_SQL_ERROR &amp; Exception CX_SY_OPEN_SQL_DB&lt;/b&gt;. Any idea what is the problem and what needs to be done?</P><P>Suresh</P></BODY></HTML> Mon, 08 Oct 2007 18:06:10 GMT Former Member 2007-10-08T18:06:10Z Runtime Errors DBIF_RSQL_SQL_ERROR & Exception CX_SY_OPEN_SQL_DB https://community.sap.com/t5/application-development-and-automation-discussions/runtime-errors-dbif-rsql-sql-error-exception-cx-sy-open-sql-db/m-p/2905803#M683560 <HTML><HEAD></HEAD><BODY><P>hi guys </P><P>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 &lt;b&gt;Runtime Errors DBIF_RSQL_SQL_ERROR &amp; Exception CX_SY_OPEN_SQL_DB&lt;/b&gt;. Any idea what is the problem and what needs to be done?</P><P>Suresh</P></BODY></HTML> Mon, 08 Oct 2007 18:06:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/runtime-errors-dbif-rsql-sql-error-exception-cx-sy-open-sql-db/m-p/2905803#M683560 Former Member 2007-10-08T18:06:10Z Re: Runtime Errors DBIF_RSQL_SQL_ERROR & Exception CX_SY_OPEN_SQL_DB https://community.sap.com/t5/application-development-and-automation-discussions/runtime-errors-dbif-rsql-sql-error-exception-cx-sy-open-sql-db/m-p/2905804#M683561 <HTML><HEAD></HEAD><BODY><P>Can't really tell without looking at the code. Would you post it please?</P><P></P><P>Also the Oracle (or whatever database) error number.</P><P></P><P>Rob</P><P></P><P>Message was edited by: </P><P> Rob Burbank</P></BODY></HTML> Mon, 08 Oct 2007 19:42:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/runtime-errors-dbif-rsql-sql-error-exception-cx-sy-open-sql-db/m-p/2905804#M683561 Former Member 2007-10-08T19:42:15Z Re: Runtime Errors DBIF_RSQL_SQL_ERROR & Exception CX_SY_OPEN_SQL_DB https://community.sap.com/t5/application-development-and-automation-discussions/runtime-errors-dbif-rsql-sql-error-exception-cx-sy-open-sql-db/m-p/2905805#M683562 <HTML><HEAD></HEAD><BODY><P>This error is possible if the tables are too big. You can avoid this by using PACKAGE SIZE addition to your select query.</P><P></P><P>Sri</P></BODY></HTML> Mon, 08 Oct 2007 19:46:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/runtime-errors-dbif-rsql-sql-error-exception-cx-sy-open-sql-db/m-p/2905805#M683562 Former Member 2007-10-08T19:46:50Z