Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Error

former_member240483
Contributor
0 Likes
545

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
502

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

4 REPLIES 4
Read only

Former Member
0 Likes
502

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

Read only

0 Likes
502

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

Read only

b_deterd2
Active Contributor
0 Likes
502

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

Read only

Former Member
0 Likes
503

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