3234016 - BI_COMP job fails with SQL255 error - SAP Solution Manager on SAP ASE

BI compression jobs are failing from solman with error :

2.08.2022 03:04:21 An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RA
2.08.2022 03:04:21 Database returned the SQL code 225. Error text: [ASE Error SQL225]Cannot run query  referenced object (name
2.08.2022 03:04:21 optimization.
2.08.2022 03:04:21 An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RA
2.08.2022 03:04:21 Collapse terminated: Data target 0CCMRSDD1, from  to 822599
2.08.2022 03:04:21 Report RSCOMP1 ended with errors
2.08.2022 03:04:21 Job cancelled after system exception ERROR_MESSAGE

Source: portal
Type: Productive System
System ID/Name: WAS / WASGYR
Product version: SAP Solution Manager 7.2
System managed by: HEC
Install base item: WASGYR
Sold product: HANA ENTERPRISE CLOUD

Adaptive Server Enterprise/16.0 SP03 PL08 HF1 ONE-OFF/EBF 29568 SMP/P/x86_64/SLES 11.1/ase160sp03pl08x/3778/64-bit/FBO/Tue Jul  7 07:59:23 2020

KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem