General Script Error Store QVD

[sudeepkm]

Hi All,

I've a QVD generator qvw that loads data (from xls files kept on SAN) ,concatenates two tables and then stores the table data in a QVD.

I've a drop table syntax after the "store into qvd" sntax.

I've created a task for this QVW in the Publisher. Past couple of days I'm finding the task being failed.

Surprisingly the reload is successful while running it manualy in the QMC.

I believe this issue is something related to the store QVD command because the drop table syntax never appears in the log file.

Can somene please advice what can be done here?

log extract:

7/2/2013 7:00:23 PM: 0096 store [USG_MONTHLY] into ..\QVDs\UsageMonthly.qvd(qvd)
7/2/2013 7:00:23 PM: General Script Error
7/2/2013 7:00:23 PM: Execution Failed
7/2/2013 7:00:23 PM: Execution finished.

Thanks in advance.

Thanks and Regards,

Sudeep

[alexandros17]

When you store data manually, the user has surely access to the directory where qvd is created but is the same for the user used for the publisher?

Try to set authorization to every user in the directory and try again.

Let me know

[sudeepkm]

Thanks.

Actually the xls files are stored under \DataSource\Monthly folder. The data uploaders just have access to the DataSources folder where they copy the xls files.

The qvd is created under \QVDs folder

No one except the Publisher's service account ID has access to the folder where QVD is created. So it is secured and only accessible by the Service Account ID and our Production Support group members.

Given below is the structure we are using.

ProjectName

- Application [All qvws are here]

- Config [All config.txt files containing the variable declarations are here]

- QVDs [All QVDs generated as a result of QVD Gen qvws are here]

- DataSources [All xls,csv files from which data is fetched are here]

Regards,

Sudeep

[#4]

In case this helps anyone running into this problem - I have just encountered it with a qvd builder that has been working fine for months.  Changing the name of the output qvd allowed the qvw script to complete without error.  It turns out the system was locking the file (still thought it was in use") so was not allowing deletion or any other action.

Oli