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 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 951 views
  • 0 likes
  • 3 in conversation