Symptom

The WorkUser and WorkManager portals allow users to enter information into work object forms to create work objects. You access the workspaces using the bars located on the Navigation area:

• When you select a Bar to access a Workspace, the following error displays:

ClassCache XML not loaded! Contact Administrator

This error occurred because a stored procedure used to call the Workspace did not execute properly, due to an incorrect version of Microsoft SQL Server in use for the PegaRULES database (Microsoft SQL Server 2005).

Solution

Workaround

You can continue to use Microsoft SQL Server 2005 and still access all the workspaces, as follows:

1. Set the MS SQL 2005 compatibility mode to 80, as follows:
   
   --SQL Server 2005 database compatible level to SQL Server 2000 EXEC
   sp_dbcmptlevel <database name>, 80; GO
2. Download and install the latest JDBC SQL Server 2005 drivers from http://msdn2.microsoft.com/en-us/data/aa937724.aspx
3. Edit the prconfig.xml file and delete selectMethod=cursor from the following entry :

   <env name="database/databases/PegaRULES/url"
   value="jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;

   SendStringParametersAsUnicode=false;ProgramName=PR ${SystemName}@${NodeName} ${DBName} #${ConnectionID}" />