topic Re: sas complaince mid tier error 7.1 after apply hotfix in Administration and Deployment

sas complaince mid tier error 7.1 after apply hotfix

medhatmamdouh12 — Thu, 30 Mar 2017 14:57:16 GMT

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-veDqOWgsdaEiJ9TdkbXw-cas

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.

Re: sas complaince mid tier error 7.1 after apply hotfix

ShelleySessoms — Fri, 31 Mar 2017 20:16:07 GMT

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

Re: sas complaince mid tier error 7.1 after apply hotfix

Paul30 — Wed, 12 Feb 2020 10:52:23 GMT

I am also facing same issue.

Re: sas complaince mid tier error 7.1 after apply hotfix

AnandVyas — Mon, 17 Feb 2020 13:30:04 GMT

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