Report won't run against a particular server

[Edie0802]

Hello: Our company is running BOExi. I have a crystal report that runs successful against one of our two servers and fails every single time against the other server. The error I am getting is "Table not found". I have contacted our DBA and they assure me all is fine as far as permissions go, seeing how I can run it fine on the client and the one server I have is getting through.

The report runs fine on the desktop of the server of which it fails in Enterprise. I have checked both crystal report job servers for inconsistencies in the CMC. I have checked the crystal report job servers in the CCM, as well as the page and cache servers for inconsistencies between the two boxes. The ODBC connections are identical. The clustering is identical.

In the short term, I have created two server groups, one for all the servers/services for one box, and another for all the servers/services for the remaining box. I simply then tell this troublesome report to run against the one I know it works on.

This is driving me nuts. Help. Thank you.

 

[eyeswideclosed]

When you say against 2 servers do you mean 2 different databases or 2 enterprise systems?

 

[synapsevampire]

I would guess that the account for the services on the offending CE system doesn't have access to the database, perhaps it's an Access database ot some such.

Make sure that the same account the services run under on the one CE server are identical to the same account as the second CE server. This is a common problem for CE, clustered or not.

If you're posting about database issues, include your database type and connectivity.

-k