I have 2 separate command line processes for Stonefield Query SDK. When I run them outside of VisualCron, they both run successfully. I put them both in VC and now I get an error of -12 on just one of them. -12 is a Stonefield Query meaning An error occurred running the report. Very Informative.

Again I only get this error when I run it from VC, outside VC it runs successfully without any error making it difficult to debug.

I've also tried putting the command line in a windows script and running the script from VC, same error. But if I run the script outside VC its successful.
Leads me to believe that VC is the culprit, not Stonefield Query.

Any suggestions?

Normally this is related to permissions. Make sure that you use the same Credential selected as the user you are trying to run it as.

Also, the Task may have interesting error output or standard output in the output columns.

---

Hi Henrik!
I've checked all the permissions. I don't think that is the problem especially since the other job which is similar runs without error.
The stderr Output is: Exception in Task: Non zero exit code
The Output: "No Output"
the Result: "Error description was not found (-12)"

This is extremely frustrating...I have several other jobs that are similar to this one that run without error.

But do you use a Credential?

---

Yes I use Credentials. If I don't I get "access denied" error

Henrik,
Stonefield suggested I try to run the process with Windows Task Scheduler, so I did and it ran without error.

That suggests that it must be something with VisualCron. Just wanted to let you know.
If you need anything from me to help with debug please let me know

Henrik,
Stonefield Support is telling me "The user account the scheduled task is running under either doesn't have a default printer or the default printer no longer exists. Correct that or use a difference user account and it should work."

I'm using my credentials and I do have a default printer defined, could it be a user other than myself? I changed the credentials to someone else but I then get an access denied error.

Is the error (-12) confirmed to be related to the printer error or?

VisualCron run things in the background differently from the normal Task scheduler.

Also confirm that you have "Local login" and "Load profile" checked in the Credential that you use (your user).

---

There is a diagnostic log created from Stonefield process and within it is the following error text:

SFReport.CreateOutput: could not create dataonly output: Error loading printer driver.

So I believe it is related to the print driver.

I do have "Local login" and "Load profile" checked

Could be that the vendor only supports 32 bit printer driver and when you execute it it is executed as 64 bit? Or maybe the working directory is wrong. Error loading printer driver must be something specific for them - what does it mean, that it cannot find a file or?

---

Henrik,
Thank you for your assistance in this matter. I decided to start fresh and take a different approach. I got everything to work in VisualCron and am happy now.