BookmarkSubscribeRSS Feed
VasilijNevlev
Quartz | Level 8

Dear community, 

 

A client of mine is having problems with the promotion process of DataFlux objects.  Here is the process: 

  1.  A set of objects (jobs, tasks, rules) are exported out of Development environment. 
  2. Imported into SIT (System Integration Test) environment where these objects perform as expected 
  3. Imported into UAT (User Acceptance Test) environment where jobs report an error "requested item is not found". 

Facts: 

  • Jobs run monitoring tasks on data 
  • Import order is the same between environments 
  • All packages are fresh.
  • All environments are almost empty (initial load stage). 

Clues: 

The issue is somehow related to a task within monitoring transformation. Selecting another task, then reselecting original tasks solves the problem. Sounds like some sort of referential issue with tasks, but why the same issue wouldn't appear in other environments? 

 

Opening up the job within XML editor, I can't see a reference to a task within monitoring transformation. Where does that reference get stored in a package?

 

Checking repository tasks, job and rules id shows that they are different between environments, so this can't be a problem since Dev2Int works fine. 

 

Any ideas or suggestions are welcome. 

 

Regards,

Vasilij

 

=======================================
For more information about {An}alytium, visit https://www.analytium.co.uk
1 REPLY 1
RonAgresta
SAS Employee

It would be interesting to know, when you look at the repository database tables across each environment, if the "jobcode" associated with the task in the originating system remains the same after export then import to subsequent systems, or if it changes when imported to the business rules repository for the UAT system. I believe that's how the job node knows what business rule to reference.

 

Ron

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!

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
  • 1 reply
  • 737 views
  • 0 likes
  • 2 in conversation