cancel
Showing results for 
Search instead for 
Did you mean: 

IDOC to JDBC receiver adapter: SQLServerException after INSERT

former_member191531
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

former_member191531
Participant
0 Kudos

It was a problem at the SQLServer...

prateek
Active Contributor
0 Kudos

This is very broad category of error. Could you see any entry in Audit Log? You will find much detailed error there.

Regards,

Prateek