Crystal Timeout‏

May 27, 2011

I’ve got a Crystal XI report query that’s going to take a long time to run, so I was wondering how you can set/disable something like a CommandTimeout property in Crystal.

Searched through the first 100 Google results for “Crystal Reports Timeout,” and the closest I found to an answer was a person asking the same question

I’m using Crystal Reports XI. My report contains SQL statement that may take very long time to run. Should I worry about increasing the command timeout? If yes, how can I do it in Crystal Reports XI ? Is it something that is to be done in the Crystal Reports Server level (Central Management Console) or in the reports level?

… which no one had responded to!

Finally found this, in the Crystal HTML Help:

The time out interval determines (in minutes) when inactive report sources are disposed. By default, the timeout interval is 10 minutes. You can configure the Java Reporting Component to have no timeout by setting the value to 0.

The timeout interval only applies to inactive reports—reports that are being processed are not timed out as a result of exceeding this value. [I assume that a report is “inactive” if it’s waiting for the query result set from the server, and that “being processed” would happen after the result set is returned to the report from the server.] Each time a report source request is successfully completed, the timeout timer is reset. If a report source is not used within the timeout interval, it is disposed and its resources are made available to other processes.

For Crystal Reports XI R2, the CRConfig.xml file is installed by default in the \Program Files\Business Objects\common\3.5\java directory.


Views on Remotes

June 26, 2010

If you have a database view on your SalesLogix Remote clients, which you’re using for running Crystal reports off of, and which pulls data from the UserSecurity table, you may have encountered this:

“Crystal Report Runtime Error: This field name is not known.”

The way around that is to create the view using the T-SQL setuser function, in Management Studio, on each Remote database (you cannot run this SQL in WG Admin through the SLX Provider):

setuser N'sysdba'
GO

CREATE VIEW sysdba.USERREQV
AS
SELECT sysdba.USERINFO.USERID, sysdba.USERINFO.USERNAME,
sysdba.USERSECURITY.ENABLED, sysdba.USERSECURITY.TYPE
FROM sysdba.USERINFO INNER JOIN
sysdba.USERSECURITY
ON sysdba.USERINFO.USERID = sysdba.USERSECURITY.USERID

GO
setuser
GO

Without the setuser function, the code will execute, and the view will populate as if nothing was wrong; but you won’t be able to see the fields in your Crystal report, in design mode. (Same thing if you try running it in WG Admin, without that function.)