Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

SQL##f - SqlState: ErrorCode:

Hi all,

I am getting this eerror while loading the data.

Please help me. Thanks in advance.


Error:

SQL##f - SqlState: , ErrorCode: , ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0913 - Row or object EMPTABLE in SALES_SCHEMA type *FILE in use.

SQL SELECT * FROM SALES.EMP

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

This is not a Qlikview error. Try asking your local friendly DB2 database administrator. The message UDB]SQL0913 - Row or object EMPTABLE in SALES_SCHEMA type *FILE in use. suggests that the table is locked by another process and can't be read while that lock is in place.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

This is not a Qlikview error. Try asking your local friendly DB2 database administrator. The message UDB]SQL0913 - Row or object EMPTABLE in SALES_SCHEMA type *FILE in use. suggests that the table is locked by another process and can't be read while that lock is in place.


talk is cheap, supply exceeds demand
qlikviewwizard
Master II
Master II
Author

Hi Gysbert,

You are right.I didn't have information on weekly backup scheduling.... I was executed the QV app at that time.

jagan
Partner - Champion III
Partner - Champion III

Hi Arjun,

If any error starts with SQL##f - SqlState: or it has SQL then we can easily say that it is an SQL error.

Regards,

Jagan.