topic Re: Upgrading to Postgresql 12 Error in Fraud, AML and Security Intelligence

Upgrading to Postgresql 12 Error

sharafadeen — Wed, 25 Nov 2020 19:14:46 GMT

Hello All,

We just concluded the software update from SAS 9.4M5 to SAS 9.4M7.

While carrying out the upgrade to Postgresql 12, this error was encountered:

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: E:\SAS\Config\Lev1\WebInfrastructurePlatf

ormDataServer\data\pg_hba.conf (The system cannot find the path specified)

java.io.FileNotFoundException: E:\SAS\Config\Lev1\WebInfrastructurePlatformDataS

erver\data\pg_hba.conf (The system cannot find the path specified)

Kindly Advice

Thanks

Re: Upgrading to Postgresql 12 Error

eesnider47 — Thu, 03 Dec 2020 15:11:05 GMT

Hello,

This seems like an issue that will require expertise from the SAS Technical Support teams. Have you opened a track for this issue? You can open a track by sending an email to support@sas.com.

Cheers,

Erin

Re: Upgrading to Postgresql 12 Error

sharafadeen — Thu, 03 Dec 2020 15:40:32 GMT

Many thanks
We have discussed with sas technical support and we have resolved the issue.
Check this link
https://go.documentation.sas.com/api/collections/pgmsascdc/9.4_3.5/docsets/whatsdiff/content/whatsdiff.pdf?locale=en#nameddest=p1quw1jx2w8eyxn1bt9l85mf296z

Re: Upgrading to Postgresql 12 Error

SASKiwi — Thu, 03 Dec 2020 19:11:54 GMT

@sharafadeen - Please mark your post as answered then.