The Data Aging jobs and Data Retention Forecast reports are failing with this error:
CVSimpleDB::SQLINFO() - INFO: [Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.] [RecNum:1, Object:daPopulateExtendedRetainedJobs, State:42000, NativeErr:8632, Proc:DaPopulateExtendedRetainedJobs, RowNum:1, Severity:17, LineNum:160, Spid:-1]
The CommServe is running at FR11.26.31. There are 321 jobs in the jobs history.
Could DR backup + CommServe Recovery resolve this issue?
Best answer by SunilView original