topic Re: Table not found error in QlikView while fetching data from DB in QlikView

Table not found error in QlikView while fetching data from DB

gulshan_rohilla — Sun, 24 Feb 2019 17:31:07 GMT

Can anyone please help me actually i am getting file not found error in QV while fetching data from DB. Few days back the script was working fine but now it is creating issue. below is the error logs of QVW.

Let vTablename='dummy_table'
ODBC Connect to ***
dummy_table:
Select AGSSEQ , MGSCODE, PWDNAME from dummy_table
DISCONNECT
CALL StoreAndDrop ('G:\qvdmakers\stage1\Qvd\','dummy_table')
Store [dummy_table] INTO G:\qvdmakers\stage1\Qvd\dummy_table.qvd(qvd)
Error: Table 'dummy_table' not found
Execution Failed
Execution finished.

Also there is one more thing the time difference between select statement and disconnect statement is 6 mins. thats means it is trying to fetch the data or it already fetch the data but the same data did not come in qv memory. the situation is strange. please help here. Also this is the case with many tables. also the is increasing day by day with more QVW's.

Re: Table not found error in QlikView while fetching data from DB

Somasundaram — Sun, 24 Feb 2019 19:56:18 GMT

Let vTablename='dummy_table'
ODBC Connect to ***
dummy_table:
Select AGSSEQ , MGSCODE, PWDNAME from dummy_table
DISCONNECT
//CALL StoreAndDrop ('G:\qvdmakers\stage1\Qvd\','dummy_table')
Store [dummy_table] INTO G:\qvdmakers\stage1\Qvd\dummy_table.qvd(qvd)
Error: Table 'dummy_table' not found
Execution Failed
Execution finished.

Run above code.

Re: Table not found error in QlikView while fetching data from DB

gulshan_rohilla — Sun, 24 Feb 2019 21:24:26 GMT

Hi Som,

Thanks for the reply but i've pasted the error logs. Call store and drop is the subroutine which i've defined earlier.store statement after the call store and drop is the expansion of the subroutine store and drop,so the store statement is just a expansion as below statements are from the logs.

Re: Table not found error in QlikView while fetching data from DB

jonathandienst — Mon, 25 Feb 2019 05:24:35 GMT

The log implies that no data was retrieved from the SQL call. This may mean that the table was not created and so does not exist when the the store statement was executed. To check for success, use a condition like

If Alt(NoOfRows('dummy_table'), 0) = 0 Then

   Trace *** Error: dummy_table not created;
    Exit Script;

Else

... do stuff with dummy table

End  If

The second possibility is that dummy_table is being auto-concatenated onto another, previously loaded table. This will happen if the field names are identical with dummy_table.

Re: Table not found error in QlikView while fetching data from DB

gulshan_rohilla — Mon, 25 Feb 2019 05:43:00 GMT

Hi Jon,

Thanks for the reply.

Actually i already applied the same if else condition on the script, but no luck. the issue is actually it didn't counts the no of rows and fall in second condition. but the data is there in the db at that time. dont know why this happening.one more thing is there actually between select statement and disconnect statement the time difference is there.

Re: Table not found error in QlikView while fetching data from DB

gulshan_rohilla — Mon, 25 Feb 2019 10:20:56 GMT

please reply