Qlik Community

Deployment Framework

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

Script fails when run by sa_scheduler

Hello I'm using QDF in my script

my script starts as follows:
SET vG.BasePath=; //Clear cache
SET vG.SharedBasePath=; //Clear cache
SET vG.RootContainer='QDF_ROOT';
SET vG.HomeContainer='6.PSA';
$(Must_Include=lib://$(vG.RootContainer)/$(vG.HomeContainer)/InitLink.qvs);

 

I created a new task to run the script under the QVF but it fails at must_include line:
5-15 06:53:54 Error: $(MUST_INCLUDE failed: lib://QDF_ROOT/6.PSA/InitLink.qvs
2019-05-15 06:53:54 $(MUST_INCLUDE failed: lib://QDF_ROOT/6.PSA/InitLink.qvs
2019-05-15 06:53:54 Execution Failed
2019-05-15 06:53:54 Execution finished.

but script runs successfully when I reload the script manually
kindly advise
@Magnus_Berg 

I can walk on water when it freezes
1 Solution

Accepted Solutions
Magnus_Berg
Employee
Employee

Hi, as already mentioned:

  • first the service account running scheduler service in Windows need to have access to the disk you are reading from
  • Second the scheduler account need access to the data file connections (libs) used in your script as the scheduling is running under this account.

Hope this helps, regards

Magnus

View solution in original post

4 Replies
bjendrick
Contributor III
Contributor III

My best guess is that the connection you're using isn't globally available for your "sa_scheduler" user. That's why it would work if you're running it manually, but not when scheduled. I'd start there with your connection permissions.
ali_hijazi
Partner
Partner
Author

Which connection you mean?

The script is failing at the point where I'm referencing the InitLink.qvs

I can walk on water when it freezes
bjendrick
Contributor III
Contributor III

It's most likely an issue with the QDF_ROOT library connection. It can't find the "InitLink.qvs" file when run by the scheduler, which points to the library connection isn't available to all users.
Magnus_Berg
Employee
Employee

Hi, as already mentioned:

  • first the service account running scheduler service in Windows need to have access to the disk you are reading from
  • Second the scheduler account need access to the data file connections (libs) used in your script as the scheduling is running under this account.

Hope this helps, regards

Magnus

View solution in original post