Table not found error when storing table as QVD

[helen_pip]

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

[helen_pip]

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

[helen_pip]

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

[helen_pip]

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

[helen_pip]

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

[vishsaggi]

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?

[Digvijay_Singh]

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.