topic Re: SAS job db connection in Administration and Deployment

SAS job db connection

karume — Sat, 25 Feb 2023 03:10:19 GMT

Which paths should i change when shifting/changing application db, so ETL jobs can continue running?

Re: SAS job db connection

SASKiwi — Sat, 25 Feb 2023 03:32:28 GMT

The answer is I have no idea unless you provide us with details of your current DB connection. Have you defined it in a LIBNAME statement for example? If so please post it.

Re: SAS job db connection

karume — Sat, 25 Feb 2023 04:03:58 GMT

I have changed the connection on tns file from amlprdtz to amldrtz , but below error comes whenever i run ETL

Re: SAS job db connection

SASKiwi — Sat, 25 Feb 2023 04:35:31 GMT

Can you reach the server amldrtz from your SAS server? Try the Oracle TNSPING command from your SAS server to confirm if the Oracle server is accessible (tnsping amldrtz).

Re: SAS job db connection

Patrick — Sat, 25 Feb 2023 09:05:29 GMT

@karume wrote:

I have changed the connection on tns file from amlprdtz to amldrtz , but below error comes whenever i run ETL

Then wouldn't you also have to change the value for the path parameter in the libname statement?

From the looks of it this libname is defined directly within AML solution macro %fcf_run_autoexec();

Re: SAS job db connection

karume — Sat, 25 Feb 2023 09:32:10 GMT

@Patrick

Which path can i find that?

Re: SAS job db connection

Sajid01 — Sat, 25 Feb 2023 14:43:30 GMT

Looks like you are using ORACLE as the back end databases. if yes then change the details in tnsnames.ora.
In a typical case no other would be necessary

Re: SAS job db connection

Patrick — Sun, 26 Feb 2023 00:30:58 GMT

Which path can i find that?

I don't know where that's stored. My hands-on experience with AML is from years ago and with an older version.

You could run your code with option MAUTOLOCDISPLAY. This will write to the SAS log where a macro gets picked-up from.

If in a Unix/Linux environment you could also just search for the physical file which should have the same name than the macro definition and be all in lowercase.

find / -type f -name "fcf_run_autoexec.sas" 2>/dev/null

I assume that also in a current AML version a lot of the solution macros are pre-compiled with no access to the source code so changing the code might not even be possible.

I also don't know if there are other places where this value is hardcoded and would need change.

I guess the name is either installation default or then gets set in the code artefacts as part of installation scripts.

If you can't find the location(s) for changing the value then contact SAS Tech Support.

Re: SAS job db connection

Sajid01 — Sun, 26 Feb 2023 19:53:20 GMT

This is something which the admins (SAS Admin / database admin) can do.
The best course of action is to approach them