topic Re: Field not found ....While loading data from QVD in QlikView

Field not found ....While loading data from QVD

Tue, 21 Jan 2014 12:29:45 GMT

Hi All,

I am getting Script execution error

Error: Field not found - < Some Field name>

General Script Error

while loading data from QVD.

It is working fine in local (in development).but getting error in production.

In production also it worked fine until yesterday. But today we are getting error.

Can any one tell why this is coming....................

Thanks

Charan

Re: Field not found ....While loading data from QVD

tresB — Tue, 21 Jan 2014 12:33:20 GMT

Check if the qvd really exists in the said path(production). Or, if your user ID has proper access right to the folder.

Re: Field not found ....While loading data from QVD

Clever_Anjos — Tue, 21 Jan 2014 12:38:53 GMT

Check

1) your load comand has (qvd) at the end of From?

from yourqvd.qvd(QVD);

2) You app has correct security rights into the folder?

Re: Field not found ....While loading data from QVD

jvishnuram — Tue, 21 Jan 2014 12:40:47 GMT

Hi Charan,

Check all the fields in the table are exist or not, why in the sense some fields may deleted on today's version.

Re: Field not found ....While loading data from QVD

richard — Tue, 21 Jan 2014 12:50:25 GMT

Just load the QVD file manually with a "preceding load" and check what fields you get. If the field doesnt exist of is renamed then you need to make changes in your script conformed to the new field.

Re: Field not found ....While loading data from QVD

Tue, 21 Jan 2014 12:58:36 GMT

Thanks for ur reply.

I have total 8 Qvd in same path. while loading data from last qvd I am getting this error. If user ID has no proper access right then I cannot fetch data from any of Qvd so I think it not problem with access rights and Qvd are present in Specified path

Thanks,

Charan

Re: Field not found ....While loading data from QVD

Tue, 21 Jan 2014 13:01:25 GMT

yes ,load command has .QVD Extension.

Until yesterday it works fine, today only I am getting error so I feel it is not problem with security

Thanks

Charan

Re: Field not found ....While loading data from QVD

Clever_Anjos — Tue, 21 Jan 2014 13:52:39 GMT

it´s not .qvd but a (qvd) after the extension

Something like this

Re: Field not found ....While loading data from QVD

Wed, 22 Jan 2014 06:33:03 GMT

I specified (qvd) after extension

Re: Field not found ....While loading data from QVD

jagan — Wed, 22 Jan 2014 06:45:23 GMT

Hi,

Can you attach the script you are using and some sample records in the QVD, I think the field is missing in the QVD. Without checking Script and Sample data it is not possible to predict the reason for the error.

Regards,

Jagan.