topic Re: SAS DI Table Loader Not working properly in SAS Data Management

SAS DI Table Loader Not working properly

Shakti_Sourav — Thu, 21 Oct 2021 05:37:48 GMT

Hy,

I am getting error when executing the job. I got Proper records in data validation transformation but when i am running table loader showing records 0,

Kindly check this Image and let me know what is the error ?

Thank You

with warm regards

Shakti

Re: SAS DI Table Loader Not working properly

LinusH — Wed, 08 Dec 2021 15:23:15 GMT

Kind of late reply, so I hope you got your problem solved 🙂

Nevertheless, it's very hard given this information to help out.

First of all, what erro do you got?

A log entry will definitley help.

Do you have any constraints on the target table?

What update technique do you use?

Re: SAS DI Table Loader Not working properly

Shakti_Sourav — Thu, 09 Dec 2021 04:57:36 GMT

Hy,

There is no Error in log. Log is Empty. but Table loader is successfully run.

Re: SAS DI Table Loader Not working properly

LinusH — Thu, 09 Dec 2021 07:24:50 GMT

No log at all?

Weird.

What happends if you run in batch mode, do you get a log then? And what return code for the job do you get then?

Re: SAS DI Table Loader Not working properly

Patrick — Thu, 09 Dec 2021 10:35:36 GMT

What I'd be doing in such a case is to copy/paste the DIS generated code into an EG program node and run it from there - eventually step-by-step.

Using EG will also allow you to easily access all intermediary work tables created.

I find it hard to believe that there is no SAS log at all. Is that also the case when running out of EG?