topic Error in Application Development and Automation Discussions

Error

former_member240483 — Mon, 18 Aug 2008 08:30:57 GMT

Hi all,

I am getting following error while uploading file into SAP.is this is a basis problem or something need to be done in code.

An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause

Thanks

Former Member — Mon, 18 Aug 2008 08:36:58 GMT

The reason for the exception(CX_SY_OPEN_SQL_DB) is:

The SQL statement generated from the SAP Open SQL statement violates a

restriction imposed by the underlying database system of the ABAP

system.

Possible error causes:

o The maximum size of an SQL statement was exceeded.

o The statement contains too many input variables.

o The input data requires more space than is available.

Regards,

Sravanthi

b_deterd2 — Mon, 18 Aug 2008 08:42:12 GMT

Hi,

I would also change your abap code to catch the exception.

With TRY...ENDTRY statement you can catch the exception and make your own message. It's more user friendly.

Regards,

Bert

former_member240483 — Mon, 18 Aug 2008 08:49:12 GMT

Thanks Sravanthi....we solved this ...was a space problem....

Former Member — Mon, 18 Aug 2008 08:54:46 GMT

Hi There.

I would like to suggest my opinion,

This is DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Dump error.

[SDN - Reference - CX_SY_OPEN_SQL_DB Exception Occured|;

[SDN - Reference - Short dump - CX_SY_OPEN_SQL_DB - when regenerating export datasource |;

Hope this works out well.

Good Luck & Regards.

Harsh Dave