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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 643 views
  • 0 likes
  • 3 in conversation