There is a known issue with MS SQL Server 2005 SP3 running ReACT v3.4+.

If staff officers have multiple regions assigned to their staff officer profiles you may encounter the following error on log in:

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

PROBLEM:

This error is with the complexity of the SQL statements used on login for populating the ReACT Today view for that user.

SOLUTION:

Download and apply the cumulative update 4 for MS Server 2005 SP3 from the microsoft website.

http://support.microsoft.com/kb/970279

Once implemented you will need to enable a trace on the server - this is a global setting.

From Query Analyzer type in:

dbcc traceon (4201, -1)

Parse and execute.

Then type in:

dbcc tracestatus (4201)

Parse and execute, the results should return a flag of '1' indicating the status is running.

Finally, this service must always be running.

To do this you will need to run 'SQL Server Configuration Manager', available from Start > Programs > Microsoft SQL Server 2005 > Configuration Tools.
From the 'SQL Server 2005 Services', right-click on 'SQL Server (INSTANCE NAME) and properties, go to the 'Advanced' tab.
On the 'Startup Parameters' line, click in the right-hand cell and select the dropdown arrow.
At the end of the last line add ';-T(4201,-1)' without the quotes.
Select 'OK' to save your setting changes.

All users should then be able to access ReACT as normal.

For technical support please call the support desk on 0121 384 2513 or email reactsupport@e-b-s.co.uk.

---

Steve Macartney
ReACT

Telephone: 0121 384 2513
Email: stevenm@react-asb.co.uk
Web: www.react-asb.co.uk