BookmarkSubscribeRSS Feed
Bidya124
Calcite | Level 5

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

 

Bidya124_0-1694208965455.png

 

5 REPLIES 5
SASKiwi
Opal | Level 21

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.

Sajid01
Meteorite | Level 14

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
Calcite | Level 5
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
Rhodochrosite | Level 12

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 333 views
  • 1 like
  • 6 in conversation