‎2008 Aug 18 9:30 AM
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
‎2008 Aug 18 9:54 AM
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
‎2008 Aug 18 9:36 AM
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
‎2008 Aug 18 9:49 AM
‎2008 Aug 18 9:42 AM
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
‎2008 Aug 18 9:54 AM
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