Accessing Tsam War Throws "Servletexception: Sql Exception: Schema 'TUXEDO' does not exist"

(Doc ID 878913.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Tuxedo System and Applications Monitor (TSAM) - Version: 1.1 to 1.1
Information in this document applies to any platform.

Goal

When tried to deploy and run the tsam application (tsam.war) on apache tomcat server, getting
following exception:
<2009-08-19 12:39:30,328> <ERROR> <com.bea.tsam.server.DataServer>
<TSAM-0105: DataServer failed to initialize: {0}>
com.bea.tsam.dao.DAOSqlException: SQL Exception
at com.bea.tsam.dao.BaseDAO.getAll(BaseDAO.java:159)
at com.bea.tsam.engine.TuxObjectManager.refresh(TuxObjectManager.java:365)
at com.bea.tsam.server.DataServer.init(DataServer.java:130)
….
….

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: java.sql.SQLException: Schema 'TUXEDO' does not exist
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Statement.executeQuery(Unknown Source)
at com.bea.tsam.dao.BaseDAO.getAll(BaseDAO.java:142)
... 28 more
Caused by: org.apache.derby.client.am.SqlException: Schema 'TUXEDO' does not exist
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms