topic Re: Table not found error when storing table as QVD in QlikView

Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 14:18:38 GMT

Dear Qlikview user

I have some table and store code which is throwing up and error:

Error:

Table not found error

Table 'Mapping' not found

Store Mapping into \\rhmqlikdev\C$\QLIKVIEW\DEVELOPMENT\InfoQlik\QVD\Map.qvd (qvd)

The script is written as follows:

Mapping:

Load

Field1,

Field2 as Description;

SQL

select ID as Field1, upper(Field2) as Field2

from Table1

where date_from > ADD_MONTHS(TRUNC(ADD_MONTHS(SYSDATE,-27), 'YYYY'),3) or date_to is null;

Store Mapping into \\rhmqlikdev\C$\QLIKVIEW\DEVELOPMENT\InfoQlik\QVD\Map.qvd (qvd);

DISCONNECT;

If I take the store out, then the script loads just fine. In addition this store is used elsewhere in the script and stored QVD's just fine

I cannot understand what is wrong with the store statement

Any help would be greatly appreciated

Thanks

Helen

Re: Table not found error when storing table as QVD

krishnacbe — Tue, 09 May 2017 14:22:29 GMT

Try storing in any local drive and then try with Server location

Re: Table not found error when storing table as QVD

m_woolf — Tue, 09 May 2017 14:24:08 GMT

When you take out the STORE and the script runs correctly, do you see a Mapping table in your data model?

Re: Table not found error when storing table as QVD

Anil_Babu_Samineni — Tue, 09 May 2017 14:24:26 GMT

When you say Reload will running with Load Statement, Then you may use this

Store Mapping into ..\..\rhmqlikdev\C$\QLIKVIEW\DEVELOPMENT\InfoQlik\QVD\Map.qvd (qvd);

Re: Table not found error when storing table as QVD

sunny_talwar — Tue, 09 May 2017 14:27:46 GMT

May be call the table anything other than Mapping as Mapping is a sort of keyword... May be like call it Mapping_Temp

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 14:30:35 GMT

Hi Sunny

In fact I changed the name of the table from it's real name to Mapping for the purpose of posting the code online

The real table name is CCG_Mapping, so can I assume that this may not be the issue

Kind Regards

Helen

Re: Table not found error when storing table as QVD

avinashelite — Tue, 09 May 2017 14:34:51 GMT

check whether your getting data for the condition

where date_from > ADD_MONTHS(TRUNC(ADD_MONTHS(SYSDATE,-27), 'YYYY'),3) or date_to is null;

condition ?

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 14:40:10 GMT

Hello

When I take the store out the table is stored but as a different table name with a -1 attached to it

I.e. instead of being called CCG_Mapping it is called the same name as another table

Any ideas what could this mean?

Kind Regards

Helen

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 15:03:08 GMT

Dear All

I hope you can all see my reply, but it appears that the Table had lost its ODBC connection, even thoough it was already in the script, yet all I did was slightly amend the pathway name

Therefore nothing wrong as such with the table

Thanks for your help

Helen

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 15:03:15 GMT

Dear All

I hope you can all see my reply, but it appears that the Table had lost its ODBC connection, even thoough it was already in the script, yet all I did was slightly amend the pathway name

Therefore nothing wrong as such with the table

Thanks for your help

Helen

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 15:03:26 GMT

Dear All

I hope you can all see my reply, but it appears that the Table had lost its ODBC connection, even thoough it was already in the script, yet all I did was slightly amend the pathway name

Therefore nothing wrong as such with the table

Thanks for your help

Helen

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 15:03:50 GMT

Dear All

I hope you can all see my reply, but it appears that the Table had lost its ODBC connection, even thoough it was already in the script, yet all I did was slightly amend the pathway name

Therefore nothing wrong as such with the table

Thanks for your help

Helen

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 15:04:01 GMT

Dear All

I hope you can all see my reply, but it appears that the Table had lost its ODBC connection, even thoough it was already in the script, yet all I did was slightly amend the pathway name

Therefore nothing wrong as such with the table

Thanks for your help

Helen

Re: Table not found error when storing table as QVD

helen_pip — Tue, 09 May 2017 15:04:11 GMT

Dear All

I hope you can all see my reply, but it appears that the Table had lost its ODBC connection, even thoough it was already in the script, yet all I did was slightly amend the pathway name

Therefore nothing wrong as such with the table

Thanks for your help

Helen

Re: Table not found error when storing table as QVD

vishsaggi — Tue, 09 May 2017 15:08:01 GMT

Can you share all the scripts you are using while running this dashboard. Like just copy all the scripts that you are running into a notepad or Word and share here?

Re: Table not found error when storing table as QVD

Digvijay_Singh — Tue, 09 May 2017 15:17:06 GMT

Check if the table expected is concatenated with any already loaded table due to having same field names. Similar error appears in such situation and we require noconcatenate keyword before the load.