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

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
Paul30
Fluorite | Level 6
I am also facing same issue.
Anand_V
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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

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