000035702 - The SQL maintenance plan for the Statistics Update Job fails after upgrading to RSA Archer 6.3

Document created by RSA Customer Support Employee on Dec 2, 2017Last modified by RSA Customer Support Employee on Jul 3, 2019
Version 2Show 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
WorkaroundA workaround exists for this issue in RSA Archer that can be performed by RSA Customer Support.
To request that the workaround be performed, please contact RSA Customer Support and reference this article.