topic Schedule error while successful tests in DIS in SAS Data Management

Schedule error while successful tests in DIS

mchiappe83 — Fri, 15 Jun 2018 19:20:03 GMT

Hi,

I have a data job that runs ok in DIS, when executed over and over again.

Now I'm trying to schedule it but some errors come up, that are completely new. Please see attached the log that I obtain from the server.

The very first error that appears in the log is the following:

ERROR 180-322: Statement is not valid or it is used out of proper order.

How come an error show up with the schedule if the executions in DIS show no problem?

Please let me know your thoughts,

Martin

Re: Schedule error while successful tests in DIS

TomKari — Fri, 15 Jun 2018 20:31:29 GMT

The problem appears to be that a macro isn't being found. I suspect there's some difference in the environment where you're trying to run now and the one where it used to work that a macro library isn't available, or the SAS options have changed.

Tom

Re: Schedule error while successful tests in DIS

Patrick — Sun, 17 Jun 2018 04:23:28 GMT

@mchiappe83

If you chose for your job "Collect Runtime Statistics" then the macro definition for %etls_setPerfInit; gets directly generated into the code for the DIS job.

If "Collect Runtime Statistics" hasn't been chosen then this macro gets neither defined nor used in the generated code.

If you've got code which uses the macro without it being defined in the same job code then I'd assume that "someone" modified the code after deploying the job.

To fix this:

1. Redeploy your DIS job.

2. Make sure that the scheduler uses the deployment object which you've used to redeploy your job

3. Rerun code via scheduler.

Let us know if this resolved your problem.