sas complaince mid tier error 7.1 after apply hotfix

[medhatmamdouh12]

hi,

my os is windows, DB is oracle.

my sas version 9.4 "4 tier as sas meta, sas middle, sas compute, oracle DB each on single server"

hotfix 

http://ftp.sas.com/techsup/download/hotfix/HF2/A5T.html

i have issue with sascompliancesolutionsmid when user login it redirect him to this url and nothing open like 404 http error

http://sanction71app/SASComplianceSolutionsMid/j_spring_cas_security_check?ticket=ST-3555-veDqOWgsda...

and sas complaince solutions mid log say:

WARN  2017-03-27 09:11:19,949 [localhost-startStop-2] - Forced destruction of the session context by the Session Service. Session Context=1bb4ced89a0f8ea9:3535c2f9:15b10742602:-7ae3

WARN  2017-03-27 09:45:40,308 [com.sas.svcs.cluster.balance.RandomPolicy Timer 0] - Failed to grow the connection pool

com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection

all other web like ecm open normally and no issues.

[ShelleySessoms]

This type of question is best answered by SAS Technical Support: https://support.sas.com/techsup/contact/

Best of luck to you, and thank you for using the SAS online communities.

Shelley Sessoms
Online Community Manager

[Paul30]

I am also facing same issue.

[AnandVyas]

H @medhatmamdouh12 

The error below clearly states that there is some issue when the app server is trying to connect to database.

Could you check and confirm if the database is up and running? Are you able to connect to database from any of the remote host or SAS server?

com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection