BookmarkSubscribeRSS Feed
medhatmamdouh12
Calcite | Level 5

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.

3 REPLIES 3
ShelleySessoms
Community Manager

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
Fluorite | Level 6
I am also facing same issue.
AnandVyas
Ammonite | Level 13

@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

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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1324 views
  • 0 likes
  • 4 in conversation