Hi,

Recently we have installed Visualcron in two environments, Development and Production. In Development we have several jobs running very well, but in Production we have a problem. We have exported the jobs in Development and imported them into Production, and adapted variables where necessary. It concerns command-scripts to run Cognos Transformer. Running the command-lines from the command-prompt does the job, but in Visualcron the job is opened and closed (successfully) within a couple of seconds, without doing anything. Could you help us solve this problem?

Kindest regards, Hans Pruijs

What kind of error do you get? Do you get any output in the output column?

---

Henrik,

The funny thing is, that the job does run successfully (in Development) but returns "no output" in the screen. The job involves opening Cognos Transformer models, refreshing cubes and copying the refreshed cubes to another directory. In the Production environment the screen looks identical, only the Last Run times shows nothing has happened. I have enclosed two screenprints to show you.

Kindest regards, Hans

Are you using the right credentials to run the tasks?

---

I suppose so, because running the command line from the command prompt (with the same credentials) does not give any problems.

Please verify that the Credential is OK by starting Notepad (enter full path) with this Credential in hidden mode (in VisualCron of course).

If you see it in the Task manager running as your user then the Credential is OK) and you can suspect that something else is different in your environment.

I suppose so, because running the command line from the command prompt (with the same credentials) does not give any problems.

---

We do have Visualcron up and running, but now a job returns an exit code 77777 (VisualCron specific error). What does that mean?

Kindest regards, Hans

What kind of task is failing in the job?

---

Exit code tells us if the Task has succeded or not. 0 is success. Since only Execute Task gives us a real exit code we have our own exit code, 77777, for all other Tasks. When you get this error it is interesting to look at STDOUT or STDERR column for reason.

---

What kind of task is failing in the job?

Erik, the task failing is refreshing a BI-cube with Cognos Transformer 8.3. The program opens, but running the cube does not work. Parameters used after opening Transformer are -c -n -m"\\Mi_data\rapporten\OTAP\4 Productie\Retail\0027 Kanaalnavigatie\Model\0027 Kanaalnavigatie.mdl", similar, apart from a few variables, to the parameters used in a job running properly.

Exit code tells us if the Task has succeded or not. 0 is success. Since only Execute Task gives us a real exit code we have our own exit code, 77777, for all other Tasks. When you get this error it is interesting to look at STDOUT or STDERR column for reason.

Having installed VisualCron in Dutch I very much would like to know which column is STDOUT and STDERR and where it can be found.

I am not sure about the Dutch translation but there is a Output column in English. The Error column is hidden by default and can be found in the List tab->Set columns.

---