The macro.cfg file we have loaded on the server is not the macro file that our Dataflux job uses. When I run a Dataflux job on our test server it pulls in a macro that is in a file labeled as macro_backup.cfg which is not correct. When I run the same job on the production server it pulls in the correct macro. I've been looking through install files and doing a comparison between prod and test and unable to locate the file that actually points DF or the server to a macro file.
I would like to understand where to look to identify which macro file the server is connected to. Not sure if this makes sense or needs a better description but hoping someone has information that can lend a hand.
Thanks
Carrie
I found the issue. Doing research I learned that the default location of the macro file is in the etc subfolder of the installation folder. It can be changed in the app.cfg file but for our install we left it as the default. The cfg files are read in alphabetical order so when I have one labeled macro_backup that is showing as the first file in the order. I moved this back up file to a new location and re-ran the job and it correctly pulled in the active macro cfg file.
I found the issue. Doing research I learned that the default location of the macro file is in the etc subfolder of the installation folder. It can be changed in the app.cfg file but for our install we left it as the default. The cfg files are read in alphabetical order so when I have one labeled macro_backup that is showing as the first file in the order. I moved this back up file to a new location and re-ran the job and it correctly pulled in the active macro cfg file.
Thank you Rachel, this is very helpful.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Early bird rate extended! Save $200 when you sign up by March 31.
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.