BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have create a few months ago an ETL process. Because of a problem in that process I have change it, and after that operation everytime I run the process for the first time I receive the error:

Error: File (...) does not exist

By watching the Source Code of the Job I discover that the error was caused by two transformations in the wrong order of the code. Because of that the WORK tables created by those transformations aren't created at the right time.
I think that the code was generated like that because they are parallel transformations and I didn't’t have the parallel processing capability ON in the job properties.

Can anyone help me please? I try to generate again the code but I can put those transformations in the right place.
4 REPLIES 4
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Recommend sharing code and also SASLOG output in your post to help gain insight on your problem. You will want to turn on SOURCE SOURCE2 and also MACROGEN (to start, then consider SYMBOLGEN if needed).
Cynthia_sas
SAS Super FREQ
Hi:
Rather than posting code here, I'd recommend contacting SAS Tech Support. If you are using SAS ETL Studio or the new SAS DI Studio, then a lot of your code is generated automatically from the process flows that you build.

If there is any kind of issue with the code that DI Studio (or ETL Studio) is generating, then the right place to go is Tech Support.

cynthia
LinusH
Tourmaline | Level 20
In cases like this, it would be great to have screen shot on your job together with some descriptions, but we can't.
But I'm not sure if this has to do with parallel capabilities. It is a common problem/mistake not to have transformations/outputs properly connected to each other in the expected execution order. This is most common if you create tables "behind the scene", that is, they are not visible as objects in the process flow. If you have such objects, you might need to connect your transformations with a "Dummy" transformation that does nothing, just makes sure that your code is executing in the proper order.

Regards,

Linus
Data never sleeps
deleted_user
Not applicable
Thank you for your answers. I decided to send my problem do technical support. It seems that it was a SAS Data Integration Studio Bug that was solved using the HOTFIX 34DATABLDR09.

It really take care of my problem, all the processes that I change or create since the HOTFIX work without that problem.

Regards
André Silva

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 691 views
  • 0 likes
  • 4 in conversation