I have a report consisting of the base report and one subreport. The report runs fine using MS SQL Server on a single CPU machine. On a multi-CPU machine the "Failed to open a rowset" error is returned, followed by "Intra-query parallelism caused your server command (process ID ###) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1)".
The maxdop option tells the server to use only one processor, ok, but is there any way from Crystal - other than perhaps using stored procedures for the base and subreport - to "pass" the hint to the server? Configuring the server with a maxdop of 1 is not an option.
The bigger question is why would parallel processing fail to begin with. Or, are there right/wrong ways to link a subreport? (The report is "canned" and so a dynamic link isn't an option.)
Thanks for any insight.
The maxdop option tells the server to use only one processor, ok, but is there any way from Crystal - other than perhaps using stored procedures for the base and subreport - to "pass" the hint to the server? Configuring the server with a maxdop of 1 is not an option.
The bigger question is why would parallel processing fail to begin with. Or, are there right/wrong ways to link a subreport? (The report is "canned" and so a dynamic link isn't an option.)
Thanks for any insight.