Background: This UIP was on multiple two machines (OA_Metadata & VA_MidTier)
Note: During UIP there was no error or warning message occurred on both servers.
We’ve followed these steps for upgrade PostgreSQL to 12 using this link on both servers: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/whatsdiff/p1quw1jx2w8eyxn1bt9l85mf296z.htm
Steps:
But we’re getting this error message below when try to run.bat script (run.bat –metaserver abc.local.com –metaport 8561 –metauser sasadm@saspw –metapass XXXXXX –upgrade) under this directory <SASHome>/SASWebInfrastructurePlatformDataServer/9.4/scripts/upgrade in OA_Metadata server
2022.04.28_16:46:05 ERROR: The system reached a timeout while waiting for the server to come up. Processing will not continue for this dataserver.
Caught: java.io.FileNotFoundException: D:\SAS\Config\Lev1\WebInfrastructurePlatformDataServer\data\pg_hba.conf (The system cannot find the path specified)
java.io.FileNotFoundException: D:\SAS\Config\Lev1\WebInfrastructurePlatformDataServer\data\pg_hba.conf (The system cannot find the path specified)
at pgupdate.UpdatePostgres.disableSecurity(UpdatePostgres.groovy:958)
at pgupdate.UpdatePostgres$disableSecurity$24.callCurrent(Unknown Source)
at pgupdate.UpdatePostgres.updateInstance(UpdatePostgres.groovy:1166)
at pgupdate.UpdatePostgres$updateInstance$3.call(Unknown Source)
at pgupdate.SearchForPGInstances.updateDBInstance(SearchForPGInstances.groovy:294)
at pgupdate.SearchForPGInstances$updateDBInstance$16.call(Unknown Source)
at pgupdate.SearchForPGInstances$_main_closure4.doCall(SearchForPGInstances.groovy:848)
at pgupdate.SearchForPGInstances.main(SearchForPGInstances.groovy:723)
D:\Program Files\SASHome\SASWebInfrastructurePlatformDataServer\9.4\scripts\upgrade>
Resolution steps are listed below:
We renamed these two directories:
And we run this script run.bat (run.bat –metaserver abc.local.com –metaport 8561 –metauser sasadm@saspw –metapass XXXXXX –upgrade) under this directory <SASHome>/SASWebInfrastructurePlatformDataServer/9.4/scripts/upgrade via command prompt (CMD) and now this time no error or warning was occurred.
On VA_MidTier server, the PostgreSQL is already upgraded to 12.9. So no need to run this script run.bat (<SASHome>/SASWebInfrastructurePlatformDataServer/9.4/scripts/upgrade)
Analytiks International Inc
4826 Chicago Ave S, Suite 102
Minneapolis, MN 55417
Toll-Free: 855-426-2598
Direct: 612-305-4310
Fax: 866-347-2021