Problem with java.sql.SQLException: [SQL0913] Row or object

[Former Member]

Hello,

I am getting problem like,

java.sql.SQLException: [SQL0913] Row or object NSARQHP in NSALDTA type *FILE in use

when i am trying to poll the data at sender side.

CAn anyone help me out?

Thanks,

SOorya

[Former Member · Accepted solution]

Hi surya

check your SQL statement with a database tool like TOAD or something else.

User the values as you can see them in the payload.

Regards Mario

[aashish_sinha]

Hi,

This error is due to Unsuccessful execution caused by deadlock or timeout. So please check out the the record, it may be locked.

Also

- a record lock (did you try an update operation?)

- a file lock

- a bug in the database

regards

Aashish Sinha

PS : reward points if helpful

[Former Member]

Hi,

How do we check this deadlock or timeout thing?

Either it is in JDBC Adapter side or Database Side?

Can u give one solution to solve this issue