Upgrade Guide › Upgrading from 6.0 › Review Queue

Review Queue

(Only required if upgrading a SQL Server CMS)

In r12.0, the database views used by the Review Queue on SQL Server CMSs were renamed to make them consistent with the corresponding views on Oracle CMSs. (In version 6.0, an inconsistent naming convention was introduced inadvertently.)

Consequently, if you upgrade your SQL Server CMS to the current version but retain your version 6.0 Review Queue search (that is, you do not install the current version Review Queue search), then your existing 6.0 search will no longer run. To fix this problem, you must:

• Either install the current version Review Queue search and reports.
• Or add backwards compatibility between the current version of CA DLP and your existing 6.0 Review Queue search. To do this, run the script:

  RQ_R11_Compat_Views_Wrapper.sql.
  

  Briefly, this script re-creates the database views used by your 6.0 search so that they point to the new (renamed) database views used by the current version Review Queue search. When you upgrade your CMS, this script is installed to the CA DLP installation folder, in the following subfolder:

  \CA\CA DLP\system\scripts\MSSQL\RQ
  

  To run this script from the \system folder, the command syntax is:

  wgninfra -exec wigan/schema/SchemaRunScript scripts\MSSQL\RQ\RQ_R11_Compat_Views_Wrapper.sql