WORKFLOW MONITOR ERRORING AFTER UPGRADE FROM 8.1.1.7 SEA TO 8.1.1.8 SIA
Issue
---------
customer upgraded from 8.1.1.7 SEA to 8.1.1.8 SIA. After the upgrade, workflow monitor agent is encountering error due to the improper syntax of sql generated against the existing rules.The issue is the conditions are getting
concatenated if there are two IN conditions in the policy. Below mentioned is the policy condition. The environment is Microsoft SQL Server 2005 64 bit
workflow policy Object: Service Request
Policy Condition
Service Request Organization = 0-R9NH
Service Request Status IN ('Open', 'Closed')
Service Request Type IN ('Auto', 'Member')
SQl Generated by workmon is
---------------------------------------
SELECT T0.ROW_ID
FROM
&Table_Owner.S_SRV_REQ T0