000035702 - The SQL Maintenance Plan for Statistics update job fails after upgrading to RSA Archer 6.3

Document created by RSA Customer Support Employee on Dec 2, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035702
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Platform
RSA Version/Condition: 6.3
IssueAfter upgrading from RSA Archer 6.2 P2 to 6.3 the statistics update job starts to fail with the error message below.

Execute as user: Domainname\UserName. Table 'InstancesTable' does not exist.
[SQLSTATE 42502] (Error 2706). The step failed.

 
CauseThis issue occurs due to the schema changes in the Instance database.
 
ResolutionThis issue has been permanently resolved in RSA Archer 6.3.0.1.
WorkaroundA workaround exists for this issue in RSA Archer 6.3.0.0 that can be performed by RSA Customer Support.
To request that the workaround be performed, please contact RSA Customer Support and reference this article.

Attachments

    Outcomes