topic Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing in Administration and Deployment

SAS Upgrade from 9.4 M7 to 9.4 M8 failing

Bidya124 — Fri, 08 Sep 2023 21:39:21 GMT

Hi Team,

I am first time trying to perform a upgrade in SAS and could able to complete in SAS App server, Metadata server but when tried to perform same exe in web server it is giving error at SAS Web Infrastructure platform configuration level.

Here you can find the attached log file. Please let me know your suggestion for resolution.

Note:- all password have been entered and system accepted without any error

Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing

SASKiwi — Fri, 08 Sep 2023 22:06:02 GMT

This type of problem is best handled by Tech Support, so I suggest to open a track with them if you haven't already done so.

Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing

Kurt_Bremser — Sun, 10 Sep 2023 09:53:00 GMT

Can you log on to the web infrastructure server with the user SharedServices?

Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing

Sajid01 — Mon, 11 Sep 2023 18:23:51 GMT

Your log shows the following message

D:\Program Files\SASHome\SASWebInfrastructurePlatform\9.4\Config\webinfpltfm_config.xml:860: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "SharedServices"
"

Make sure you are using the correct passwords

Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing

Acf2 — Mon, 18 Sep 2023 15:43:15 GMT

Not sure which server platform you are using but the Unix version is similar to this test on Windows server:

cd /d "D:\Program Files\SASHome\SASWebInfrastructurePlatformDataServer\9.4\bin"

set PGPASSWORD=xxxxxxx

psql -h localhost -p 9432 -U SharedServices -c "select * from public.sas_theme;"

:: Quick test that postgres is listening

netstat -an | find "0.0.0.0:9432"

Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing

jklaverstijn — Wed, 27 Sep 2023 11:50:22 GMT

Note:- all password have been entered and system accepted without any error

Be aware that the deployment wizard does not verify outbound credentials. Only those that can be verified by the metadata server (like sasadm, sassrv, ... passwords) will be. Others, typically the ones you have to type in twice, are only verified upon actual use. So it is very possible you entered the wrong password for SharedServices (twice) and the wizard being happy initially with that while eventually failing when accessing the database using that password.

Hope this helps,

- Jan.