Error

[Former Member]

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

PT

[Former Member]

Hi

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

[Former Member]

Hi

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

[Former Member]

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

[b_deterd2]

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 Member]

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