topic Re: CX_SY_OPEN_SQL_DB after locking user in SELECT-Clause in Application Development and Automation Discussions

CX_SY_OPEN_SQL_DB after locking user in SELECT-Clause

former_member310342 — Wed, 08 Feb 2017 12:49:17 GMT

Hey,

I'm using a select to proof some data. Within the select clause I check for some conditions. If they are not fulfilled the user gets locked.

The user lock is successful but when the debugger gets back to the top of the select it I'm getting a CX_SY_OPEN_SQL_DB exception. When I comment out the function module that locks the user the exception doesn't appear.

EDIT: I'm using the BAPI_USER_LOCK as a RFC Call.

Debugging didn't get me any further. After the first select the debugger jumps back at the top again and then he is already getting the message.

I'm thankful for any hints where this problem comes from.

Regards

Re: CX_SY_OPEN_SQL_DB after locking user in SELECT-Clause

RaymondGiuseppi — Wed, 08 Feb 2017 14:09:33 GMT

I suppose the runtime error behind the exception is DBIF_RSQL_INVALID_CURSOR. The RFC call or the COMMIT WORK closed the cursor open by the SELECT statement (Implicit Database Commits). Select into an internal table and then LOOP at this table.

Regards,
Raymond

Re: CX_SY_OPEN_SQL_DB after locking user in SELECT-Clause

former_member310342 — Wed, 08 Feb 2017 15:02:34 GMT

Hey,

Thanks Raymond that was pretty easy and works perfectly!

Exception doesn't appear anymore.

Regards