CX_SY_OPEN_SQL_DB Error!

[Former Member]

Dear All,

I am facing an issue in one of the interfaces.

The error is below:-

"Error during prorxy processing An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause The system tried to insert a data record, even though a data record with the same primary key already exists"

When the interface is rerun the interface executes successfully. Its only the first time it gets stuck.

Does assigning a separate queue help to resolve this issue or this is something related to DB error.

If you want I can paste the proxy code of the same here.

SJ

[Former Member]

Hi Saras,

Goto SPROXY TCode-> select the corresponding msg interface->check the function module which is not handled properly in code and rectify the same..

There is no need for separate queue...

Regds,

Pinangshuk.

[Former Member]

I would suggest checking the ABAP dump on st22 to see the cause of the error

[Former Member]

Debug your proxy program and check all the insert statements.Once you get the point where this exception is thrown modify the code to handle it.

This thread can be helpful :

Regards

Soumen...