Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Issue: "ClassCache XML not loaded" with WorkUser portal (SQL Server 2005)

Updated on May 7, 2019


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).



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 WWW
  3. Edit the prconfig.xml file and delete selectMethod=cursor from the following entry :

    <env name="database/databases/PegaRULES/url"

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

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us