000030706 - RSA VIA L&G / IMG / Aveksa - ORA-00936: missing expression error when trying to save a known good Workflow SQL Node

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030706
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.8.1
Product Description: Access Certification Manager
IssueAfter applying a patch greater than or equal to Patch 13 on 6.8.1 you are no longer able to edit SQL Nodes that have a valid query.
You receive the following dialog when attempting to save:
User-added image
CauseThis issue is caused by a regression that was introduced in Patch 13.
This regression checks to make sure that all variables are encased in double quotes.  Variables used to compare numerical values do not require quotes which is why the newly added code now throws an error.
ResolutionPatch 17 for 6.8.1 has the fix ACM-54996 for this issue.
WorkaroundTo temporarily work around this issue prior to patching you can encapsulate your numeric variables in quotes.