JDBC Exception

[Former Member]

Hi,

i'm receiving the following error on my idoc->XI->JDBC scenario.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.StagingPromotionHeaderImport' (structure 'InsertStagingPromotionHeaderImport'): com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(57) [XI2JDBC[:POSOB_PromoBonus_ReceiverSys:CC_POSOB_PromoBonus_JDBCOutput]_62, IO:95159, Dbc:953f9]. PktNum:0. TotalReceived:0. PktSize:4,096.

the first idoc sent was successful but the second try caused this error.

any ideas?

Thanks

[bhavesh_kantilal · Accepted solution]

Connection has been reset by the Target Database.

1. In the receivr JDBC adapter, in advanced mode, select Disnconnection From Datrabase after Each Message Processing.

2. Or,. just make some dummy changes and reactivate the JDBC adapter.

regards

Bhavesh

[bhavesh_kantilal · Accepted solution]

One reason can be that the Database allows only one connection at a time and also disconnects the connection automatically.

I agree that this is not a long term solution when the load is high as connecting and disconnecting evry polling interval will have slight issues, the better option would be to sit with your DB team and try to look into the DB logs and find out why the DB is disconnecting the JDBC after a single message.

Regards

Bhavesh

[Former Member]

Thanks, disconnecting after each process solved the issue.

Points awarded.

I am curious yet however, is this the correct approach as the process will handle thousands of db calls later?

[prabhu_s2]

chek ur JDBC recv XML strucutre.....

http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm