Executing SELECT * FROM policy.v_EvaluationErrorHistory in EPM-framework can result in following error when EvaluatedObject doesn't contain a backslash:
Invalid length parameter passed to the RIGHT function
Checking if a backslash is present solves the issue:
case when CHARINDEX('\', REVERSE(EvaluatedObject)) >0 then RIGHT(EvaluatedObject,CHARINDEX('\', REVERSE(EvaluatedObject)) - 1) else EvaluatedObject end
Executing
SELECT * FROM policy.v_EvaluationErrorHistoryin EPM-framework can result in following error whenEvaluatedObjectdoesn't contain a backslash:Checking if a backslash is present solves the issue:
case when CHARINDEX('\', REVERSE(EvaluatedObject)) >0 then RIGHT(EvaluatedObject,CHARINDEX('\', REVERSE(EvaluatedObject)) - 1) else EvaluatedObject end