cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in sender JDBC adapter

Former Member
0 Kudos

hello,

I am facing one typical problem in sender JDBC adapter.

Here is the issue,

JDBC API method getString threw an exception: java.sql.SQLException: Cursor state not valid.

Can anyone please help me out in solving this problem?

Actually after a retry of 3 times the message has been successfully sent. Till then i am getting these error

On 1st attempt ,

Error during conversion of query result to XML java.sql.SQLException: Cursor state not valid

On 2nd attempt,

Error during conversion of query result to XML java.sql.SQLException: Internal driver error

(class.java.lang.InterruptedException)

On 3rd attempt,

Processing finished successfully.

This is the scenario that i can see in the audit log.

Can you please help me out in solving this issue.

Thanks,

Soorya

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

this is kind of weird.

This may be due to you are doing JDBC on a high volume table. or you need a service path upgrade for SQL.

Check FAQ on the JDBC adapter, see SAP Note 831162.

Thanks

Gaurav

Former Member
0 Kudos

Hi gaurav,

It was a good response from your side.

I have gone through the FAQ but could not able to find anything.

Can you please help me out in this regard ?

Also i am using select query of this kind,

SELECT

SEFVHRC.VHRBRCD,SEFVHRC.VHRCUCD,SEFVHRC.VHRVIN,SEFVHRC.VHRMOCD,SEFVHRC.VHRCHAS,

SEFVHRC.VHRSLOR,SEFVHRC.VHRDIVI,SEFVHRC.VHRMGCD,SEFVHRC.VHRMOCH,SEFVHRC.VHRVHTY,

SEFVHRC.VHRBDTY,SEFVHRC.VHRMFYR,SEFVHRC.VHRMOYR,SEFVHRC.VHRMODS,

SEFVHRC.VHRMDTL,SEFVHRC.VHRCLBR,SEFVHRC.VHRRCID,SEFVHRC.VHRARDT,

SEFVHRC.VHRLUTM,SEFVHRC.VHRLUDT,SEFVHRC.VHRKEYN,SEFVHRC.VHRCTORN,

SEFVHRC.VHRCTIMP,SEFVHRC.VHRPRDT,SEFVHRC.VHRPRDT,SEFVHRC.VHRRCDT,

SEFVHFT.VHFCLCD,SEFVHFT.VHFCAT,SEFVHFT.VHFCADSC,SEFVHFT.VHFKEY,SEFVHFT.VHFTEXT1,

SEFVHFT.VHFTEXT2,SEFVHFT.VHFTEXT3,SEFVHFT.VHFTEXT4

FROM

SAPTESTLIB.SEFVHRC,SAPTESTLIB.SEFVHFT

WHERE

SEFVHRC.VHRVIN = SEFVHFT.VHFVIN AND SEFVHRC.VHRSTTS = ' '

and update query of this kind,

Update SEFVHRC SET VHRSTTS = 'R' WHERE VHRSTTS = ' '

I am using prity big select query. is there any option to optimize it?

Can you please help me out in solving this problem

urs,

Soorya