ETL running fine in manual reload but same ETL not excute in QMC

[#1]

Hi Team,

I have a ETL which running fine in manual reload but when I schedule it into a QMC it's not excute successfully. Not ale to understand the error, in log file Error: Script line error:

                                     General script error.

Please help me.

Regards

Anup

[jonathandienst]

Does the service account have access to all the data sources?

Does the script write a file (STORE...):

     - and does the location exist?

     - does the service account have write access to that location?

[Siva_Sankar]

When you are scheduling in QMC, the path pointing QVD files by the dashboard is same or different?

[#4]

Thanks for your reply. The QVD store into a different folder but ETL & QVD are in same root folder.

[#5]

Hi Jonathan,

Thanks for your reply.

In my ETL I am fetching the data from same server different file location not need to connect any data source.

Yes the script contain the key word STORE

Yes location is exist

Yes QV_ADMIN have the write access.

Jonathan in my ETL there are two scenario in Extraction layer

1) Initial

2) Incremental

If Extracted.qvd is exist then go for Incremental load else Initial

For this checking I am using the code

Let vQVD_Exists = IsNull(QvdCreateTime('$(vQVDExtractedDir)\$(vSource)_Extracted.qvd'));

If $(vQVD_Exists) = -1 THEN  

       //For Initial Load

ELSE 

//For Incremental Load

END If

In my log file I am geting error in else part.

But it's working fine in Manual load. If I comment out any part (True part or Else part in IF statement) then it's running well.

Please help.

[#6]

Hi Team,

Please help me.

I am using " For each " statement is there any limitation. Till now I am stuck on a same problem.

Thanks

Br,

Anup

[jonathandienst]

From one of your posts it sounds like the problem is in the Peek or If statement, but in your second post you are asking about a For Each statement. Which one is the last line on the log file before the error?

Have you tried single stepping through the code in the debugger to see confirm that your variables expand the way you expect?