SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

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

Product

SAP Solution Manager 7.2

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.