Accessing Tsam War Throws "Servletexception: Sql Exception: Schema 'TUXEDO' does not exist" (Doc ID 878913.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.