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

[krishnacbe]

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

[m_woolf]

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

[Anil_Babu_Samineni]

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);

[sunny_talwar]

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

[helen_pip]

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

[avinashelite]

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 ?

[helen_pip]

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

[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