Skip to Content

Error in JDBC Adapter.

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 14, 2016 at 05:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2016 at 08:15 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2016 at 07:39 PM

    Hello

    Your Query might be wrong..

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

    Add comment
    10|10000 characters needed characters exceeded