TS Reporting: Cannot connect

TS 6.5

I'm setting up TS Reports with our Enterprise Crystal Server (on another machine). At the moment we are unable to connect the Crystal Server we are getting the following API error.

========================
A problem was encountered trying to connect to the Crystal Enterprise server. Please contact your TeamSite administrator. The following was returned by the Crystal Enterprise API: All the servers with CMS 10.233.54.228, cluster and kind cms are down or disabled
===========================

Has anyone seen this?

In addition, when TS Reports detects a new event in the event subsystem it is reporting the following error:

========================================
07 Apr 2005 12:16:49,172 ERROR - Caught CSException in getEvents: com.interwoven.cssdk.common.CSObjectNotFoundException: (Object being looked up was not found)
07 Apr 2005 12:16:49,607 WARN - Message property type has no matching table column
07 Apr 2005 12:16:49,607 WARN - Message property type has no matching table column
============================================

Has anyone see this?

Currently our Event subsytem is working. We are using it on search right now.

Thanks,

Brian

Find more posts tagged with

Comments

kajjubee

Hi bturns,
did you get reporting to work? I see the same messages in tsreport.log. Please let me know if you have reporting functional and what you did to fix it.

Thanks
K

smenon

Can you examine the Reporting Database (not the event susbsystem database) to see if the appropriate tables were created on that database. And do you know if you have permission to connect to the reporting database from the TeamSite server. The reporting module uses JDBC to connect to the reporting database and assumes that the appropriate schema is available. Looking at the exception, it seems to indicate that the tables didn't get setup correctly. You might want to log a support case if you haven't already..

--Sunil Menon
Product Manager
Interwoven, Inc.

kajjubee

Thanks Sunil, I do have a case with IW for more than 2 weeks now, but without much progress. The tables didn't get created in the reporting database. Seems like there is no uninstall script for Reporting module either. Donno why. Another issue I have is that there is a firewall between TS server & the crystal server ( no firewall for database server, so both of them can talk to the databse server) , and I have opened up ports 6400, 6401 & 4279, but no luck connecting to the crystal server. Do you know if anyone out here has installed reporting successfully and it works?

Regards
K

bturns

Right now the issue we are facing is the connection between the TeamSite GUI and the Crystal reports server. However, the reporting is working to the database. We are able to run reports directly from the Crystal reports server.

We are using the eventsub system to write to an external database. We set up reporting as a subscription to the eventsub system.