Unable to connect when setting up Tomcat as a service
Was able to set this up and get it working using the OOTB configuration.
Problem is we can't leave the web server logged in and running all day so we setup Tomcat to run as a service. The service starts up fine but when we try to login we get a generic unable to login error.
Logs show the following:
Caused by:
com.ibm.team.repository.common.InternalRepositoryException: Error executing statement select t1.ITEM_ID from REPOSITORY.CONTRIBUTOR as t1 where (t1.USER_ID = ?)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:57)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:770)
... 57 more
Caused by:
java.sql.SQLException: Schema 'REPOSITORY' does not exist
Any suggestions would be welcome.
Thanks
Problem is we can't leave the web server logged in and running all day so we setup Tomcat to run as a service. The service starts up fine but when we try to login we get a generic unable to login error.
Logs show the following:
Caused by:
com.ibm.team.repository.common.InternalRepositoryException: Error executing statement select t1.ITEM_ID from REPOSITORY.CONTRIBUTOR as t1 where (t1.USER_ID = ?)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:57)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:770)
... 57 more
Caused by:
java.sql.SQLException: Schema 'REPOSITORY' does not exist
Any suggestions would be welcome.
Thanks
3 answers
Usually when you see a message like "Schema 'REPOSITORY' does not exist" it means there's something seriously wrong with the database that backs the Jazz Repository (like it's empty or the Jazz server can't locate it).
I've notified some Repository component team members of this thread to see if they have more concrete guidance.
Question: Would you please clarify what you mean by running Tomcat "as a service"? Like a Windows service or ... ?
I've notified some Repository component team members of this thread to see if they have more concrete guidance.
Question: Would you please clarify what you mean by running Tomcat "as a service"? Like a Windows service or ... ?
hi,
I'm trying to run tomcat as a windows service on a vm instance of windows 2003 server. The appache service gets created and you can start and stop the service without error. When I try to connect to the server from my desktop I get the error that the repository schema does not exist in the log file and at http 500 internal server error.
When I log into the server and run server.startup.bat I'm able to connect to the server from my desktop and there are no errors in the log.
john
I'm trying to run tomcat as a windows service on a vm instance of windows 2003 server. The appache service gets created and you can start and stop the service without error. When I try to connect to the server from my desktop I get the error that the repository schema does not exist in the log file and at http 500 internal server error.
When I log into the server and run server.startup.bat I'm able to connect to the server from my desktop and there are no errors in the log.
john