TeamSite Report Center connection issue

Bill Klish

Windows 2003 EE SP1
TeamSite 6.7.1
MS SQL server 2000 sp4 - installed locally on the same server as TS
TeamSite Report Center
Crystal Reports 10

I am getting the following issue in the tsreport.log file:

09 May 2007 06:24:22,453 ERROR - Error during Grc initialization
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.interwoven.tsreport.server.DbConnectionPool.createConnection(DbConnectionPool.java:74)
at com.interwoven.tsreport.server.DbConnectionPool.InitializePool(DbConnectionPool.java:60)
at com.interwoven.tsreport.server.DbConnectionPool.(DbConnectionPool.java:46)
at com.interwoven.tsreport.server.Grc.loadDatabaseConfiguration(Grc.java:256)
at com.interwoven.tsreport.server.Grc.loadConfigurationFile(Grc.java:145)
at com.interwoven.tsreport.server.Grc.init(Grc.java:318)
at com.interwoven.tsreport.server.Grc.start(Grc.java:335)
at com.interwoven.tsreport.server.ReportServer.run(ReportServer.java:191)
at java.lang.Thread.run(Thread.java:595)
09 May 2007 06:24:22,562 ERROR - Error starting: com.interwoven.tsreport.server.GrcException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
09 May 2007 06:24:22,562 ERROR - Error starting: com.interwoven.tsreport.server.GrcException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
09 May 2007 06:24:22,562 INFO - Interwoven Report Server started.
09 May 2007 06:24:22,562 INFO - Interwoven Report Server started.


I checked the jdbc url in the tsreport.xml file and it is setup correctly. I checked the username and password in the .passwd file and they both look ok.

After running through the install, the report center tables were created inside the database.

Should I ignore these errors, or do they mean something?

nbwoven

1.
Teamsite ReportCenter & Crystal Enterprise Server preferably should be on a separate Box.

The errors look harmless on a first loook.Try increasing(to unlimited) the 'timeout value' between TS &SQL Server .

2.
Does the error go away with these settings ,you can revert back after testing ?
* Change the eventsubsystem\conf\jmsconfignew.xml to restrict the connection to 1 i.e. maxActive="1" maxIdle="1"
do iwreset -ui Then restart eventsubsystem, TS reports services .