SOI UAT Error Message "Internal Server Error"

book

Article ID: 6780

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

When clicking on SOI console, you are getting an error "Internal Server Error".

Also the alerts are not getting published on the SOI console.

If you can find the following error message in ....\CA\SOI\SamUI\logs\soiuis-debug.log which is located on SOI UI server, then this KB article is applicable to you.

ERROR [DashboardSLAManager] slamanager.DashboardSLAManager.readHibernateforActive(423) - Hibernate error on SLO: 
org.hibernate.exception.JDBCConnectionException: Cannot open connection 
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) 

.
.

Caused by: java.sql.SQLException: Unknown server host name 'hostname of database server'.

Cause

Please open a command prompt on SA manager/UI server, run the command

"ping <hostname of Database server>".

If the result shows the Database server doesn't respond to ping from SA manager/UI server,

it indicates that there are some communication issues between SA manager/UI server and database server which might be caused by Firewall setting or network issues.

Environment

SOI 4.2

Resolution

Please fix the communication issue between database server and SA manager/UI server.

SA manager/UI server must be able to connect to the database server on port 1433 through JDBC connection.

Attachments