Solved

Data Aging jobs and Data Retention Forecast reports are failing

  • 8 August 2022
  • 2 replies
  • 177 views

Userlevel 1
Badge +6

Hello,

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?

 

Thank you,

Lubos

icon

Best answer by Sunil 8 August 2022, 15:05

View original

2 replies

Userlevel 1
Badge +6

Hi @Sunil,

Thank you for your help!

Regards,

Lubos

Userlevel 5
Badge +12

Hi @Lubos Dvorak 

I think you need to install latest CU pack of SQL Server 2019 released by Microsoft. There are other tickets with the same symptom resolved by installing latest CU pack.

 

Thanks,

Sunil- 

Reply