on 05-11-2009 10:17 AM
Hello,
we are using SAP XI 3.0 and I have to set up an asynchronous IDOC to JDBC scenario.
Informations coming via IDOC have to be inserted into an MS SQL database. The ID for each dataset will be set automatically when inserting, so there is no update. I have used the following structure:
When sending an IDOC, the data will be inserted into the database, but in the Runtime Workbench the following Exception occurs:
' SQLServerException. A result set was generated for update. '
It seems to me, that the result information of the database can't be handled in the JDBC adapter.
Anybody an idea if this is a issue on the XI or maybe of the database itself?
Thanks in advance.
Jürgen
Edited by: Juergen Grallert on May 11, 2009 11:17 AM
hi,
try setting logSQLStatement as described in OSS note 801367
to see what get executed in the statement and you will know
what to change in XI then - this is the proper way to debug jdbc issues
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It was a problem at the SQLServer...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is very broad category of error. Could you see any entry in Audit Log? You will find much detailed error there.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.