SQL error 600 occurred while executing Native SQL. (tExcept 31104 in SIM_SIMSESSION)

[Former Member]

Hi Team,

I'm facing dump when executing transaction /SAPAPO/OM17.

Please let me know the reason for error and the solution.

ST22 error details:

Category Installation error
Runtime Errors DBIF_DSQL2_SQL_ERROR
Except. CX_SY_NATIVE_SQL_ERROR

Date and Time 10.05.2019 05:23:09

Short Text :SQL error 600 occurred while executing Native SQL.

What happened?:

Error 600 has occurred on the current database connection "LCA". Database error text: POS(1) Work rolled back: tExcept 31104 in SIM_SIMSESSION Triggering SQL statement: "EXECUTE PROCEDURE "SIM_SIMSESSION_CONTROL""

Error analysis:

An exception has occurred which is explained in more detail below. The exception is assigned to class 'CX_SY_NATIVE_SQL_ERROR' and was not caught in procedure "SIMSCTRL_EXEC_COM" "(FORM)", nor was it propagated by a RAISING clause. Since the caller of the procedure could not have anticipated this exception, the current program was terminated. The reason for the exception is: Database error text: "POS(1) Work rolled back: tExcept 31104 in SIM_SIMSESSION"

Error place:

451 EXEC "#EC CI_EXECSQL 452 SQL. >>>>> execute procedure "SIM_SIMSESSION_CONTROL" ( 454 in :is_gen_com_params, 455 out :ev_rc, 456 OUT :Et_rc, 457 OUT :Et_info_rc, 458 in :iv_simsession_method, 459 in :iv_temp_simid_in, 460 out :ev_temp_simid_out, 461 in :iv_mlevel_atp_protocol_id, 462 OUT :Et_order_changed, 463 OUT :Et_order_deleted_in_sim, 464 OUT :Et_reopen_ordkeys_deleted, 465 OUT :Et_reopen_ordmaps_deleted, 466 OUT :Et_reopen_ionodes_deleted, 467 OUT :Et_order_deleted_in_op_data, 468 OUT :Et_deleted_fix_pegging, 469 OUT :Et_order_pcm) 470 ENDEXEC. 471 ev_subrc = sy-subrc.

Thanks

Chandra

[rupesh_brahmankar]

Hello,

For which object are you getting thus dump in //OM17?

Please check OSS note 1523771 - /SAPAPO/OM17: DBIF_DSQL2_SQL_ERROR during conf. check

Best Regards,

R.Brahmankar