Problem with SQL Exception SQL0913

[Former Member]

Hello,

I am facing problem in my XI2JDBC scenario like,

SQLException during query 'Select * SRSYS from NSARECP

where srrecn = (select min (srrecn) from nsarecp where pdate =

'0001-01-01')':

java.sql.SQLException: [SQL0913] Row or object NSARECP in

NSALDTA type *FILE in use.

Can you please help me out.

Thanks,

soorya,

[justin_santhanam · Accepted solution]

Surya,

If you google the error code SQL0913 it says some other appln is locking the object. Hence XI couldn't able to retrieve the data!

raj.

[Former Member]

Hi,

It would be an error due to time out options so try to increase the polling time and also check whether are manually able to execute the query as it can even been locked because of polling the table with wrong user name and password.

Regards,

Nithiyanandam

[justin_santhanam]

Surya,

Can u execute the same query on DB and check whether it's executing without any errors.

raj.

[Former Member]

Hello,

Its not the issue with the queries.