Skip to main content
Solved

Data Aging jobs and Data Retention Forecast reports are failing

  • August 8, 2022
  • 2 replies
  • 239 views

Forum|alt.badge.img+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

Best answer by Sunil

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- 

2 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • Vaulter
  • Answer
  • August 8, 2022

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- 


Forum|alt.badge.img+6

Hi @Sunil,

Thank you for your help!

Regards,

Lubos