Error in JDBC Adapter.

[vijay_b4]

Hi,

I have a File to JDBC Scenario which is asynchronous. I have two segments in the Target structure, one segment with action: insert and other with execute.

Target Structure:

MT_Target

  Segment1

      Table name

         action   Insert

         table

         access

            field1

            field2

Segment2

       SP

         abc_update_pm_invoice       mapped to constant[]

         action EXECUTE

         code

           input

           type

Now I receive an error in message monitor:

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'abc_update_pm_invoice' (structure 'SP'): com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed.

Any help?

Thanks.

[bhavesh_kantilal · Accepted solution]

Are you making a synchronous call to the Database and expecting a response?

The error states - the Database failed to respond which implies, PI has pushed the request to the DB but the DB is not responding with the required data.

To find out which of the 2  ( Insert vs SP ) is causing this issue, I would disable one of the segments in the mapping and test the same. This would tell you where the issue resides, Insert statement vs Stored Procedure and this would then help the DB admin also understand why the response is not returned.

Regards,

Bhavesh

[vijay_b4 · Accepted solution]

Thanks Bhavesh.

I am really wondering by seeing the error, as it is an Aysnchronous scenario.

The error is not with the Insert statement, the error clearly says the issue is with the 'abc_update_pm_invoice' (structure 'SP'):

Error when executing statement for table/stored proc. 'abc_update_pm_invoice' (structure 'SP'): com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response. The connection has been closed.

Thank you,

Vijay.

[former_member186851 · Accepted solution]

Hello Vijay,

It might happen due to incorrect query as well.

[vijay_b4 · Accepted solution]

Hi Raghuraman,

DBMS team is looking into the query, but it was working fine from almost 3years.

I will update soon...

Thank you,

Vijay.

[former_member186851 · Accepted solution]

Ok vijay,

any recent changes happened in DB level or in PI channel?

[vijay_b4 · Accepted solution]

No Changes..I compared the successful data with the failure data, but even there I have not found any difference.Thank you Raghuraman.

[former_member186851 · Accepted solution]

Hello vijay,

Any luck after the query execution in the DB level?

[iaki_vila]

Hi Vijay,

Talk with the DB guys if the communication with the DB should be done under SSL, there are a lot of threads in java forums linking that exception with SSL. You should a little test before, as Bhavhes said, for example only with the insert or doing an easier select, only to assure if the problem is in the connection, i think it could be here; or the problem coming in other side.

Regards.

[former_member186851]

Hello

Your Query might be wrong..

Run the query used in Stored procedure in the  DB and check if its working fine.