Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

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

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
Luminary Alumni
Luminary Alumni

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.