on 04-13-2016 4:51 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Your Query might be wrong..
Run the query used in Stored procedure in the DB and check if its working fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.