SAS Upgrade from 9.4 M7 to 9.4 M8 failing

[Bidya124]

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

[SASKiwi]

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.

[Kurt_Bremser]

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

[Sajid01]

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

[Acf2]

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"

[jklaverstijn]

---

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.