topic Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement in Application Development and Automation Discussions

Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

Former Member — Fri, 19 Aug 2011 09:04:07 GMT

Hello Friends,

I am getting a short dump with exception CX_SY_OPEN_SQL_DB on MODIFY statement on database.

On further analysis I noticed that the (Z )transparent table on which MODIFY statement is executed is having 2 primary keys.

1. Delivery Number

2. Position Number.

The MODIFY statement gets executed successfully for FIRST RUN and updates record in Z-table.

During second run where Delivery number is SAME and position number is DIFFERENT(primary key is different than first run), system throws a short dump with exception CX_SY_OPEN_SQL_DB

My question is how can I avoid this short dump which is coming on second execution of MODIFY statement with different primary key?

Thanks a lot for your help.

Regards,

Navin

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

Former Member — Fri, 19 Aug 2011 09:59:30 GMT

USe commit work after modify statement if you are updating it from work area each time.

You can update whole internal table in one shot too with modify which will be faster, if it suits your need.

If couldn't solve, Better paste your code to get more helpful answer.

BR,

Diwakar

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

yuri_ziryukin — Fri, 19 Aug 2011 10:10:44 GMT

Normally the dump consists of 2 parts. One is the exception and another one is the name of runtime error.

Please mention BOTH of them please.

Example:

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

Former Member — Fri, 19 Aug 2011 10:14:16 GMT

Hello Diwakar,

Thanks a lot for your reply. I'am already using commit work after this modify statement(after insertion of first record). However this doesnt resolve the problem.

Any other suggestion is highly appreciated.

Best Regards,

Navin

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

Former Member — Fri, 19 Aug 2011 10:17:34 GMT

Hello,

Thanks a lot for your reply on this thread.

The exception is:

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Best Regards,

Navin

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

Sandra_Rossi — Fri, 19 Aug 2011 20:55:01 GMT

Hi,

there must be a text in the dump that gives more details, like the error code, etc. Could you also paste your MODIFY statement.

Thanks

Sandra

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

Former Member — Thu, 25 Aug 2011 08:12:05 GMT

Yes, paste your program code, Others can see the problem and supply the solution

more clearly.

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

RaymondGiuseppi — Thu, 25 Aug 2011 08:24:43 GMT

Check in the Dump ST22 and system log SM21 for more information on the error, seems the error is returned by the database manager to SAP (eg. ORA-xxxxx for an oracle database)

Regards,

Raymond

PS: And, please, close the thread when solved.

Re: Short dump - CX_SY_OPEN_SQL_DB during MODIFY statement

Former Member — Thu, 25 Aug 2011 09:42:13 GMT

Hello folks,

Yes, the problem is solved now. I found that one of the field was exceeding the limits defined in the data element.

I modified the calculation of that Z-field and problem is solved now.

I really thank a lot to my fellow colleagues who spent their valuable time to answer my questions.

Best Regards,

Navin