BookmarkSubscribeRSS Feed
Shakti_Sourav
Quartz | Level 8

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 ?error_Records.PNG

 

Thank You

with warm regards

Shakti

4 REPLIES 4
LinusH
Tourmaline | Level 20

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?

Data never sleeps
Shakti_Sourav
Quartz | Level 8

Hy,

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

LinusH
Tourmaline | Level 20

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?

Data never sleeps
Patrick
Opal | Level 21

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?

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1008 views
  • 0 likes
  • 3 in conversation