DBACOCKPIT HTTP 500 Internal Server Error - SAP ASE

 


Symptom

When running DBACOCKPIT t-code, below errors appear

HTTP 500 - Internal Server Error

Access using a 'ZERO' object reference is not possible OR

Zugriff über 'NULL' Objektreferenz nicht möglich


ICF logs below error message

<ErrorInfo URL="http://hostname:port/sap/bc/webdynpro/sap/dba_cockpit">

<ErrorMessage>Access using a &apos;ZERO&apos; object reference is not possible.</ErrorMessage>


Runtime st22 dump is generated with information

Runtime errors: OBJECTS_OBJREF_NOT_ASSIGNED

ABAP Program: CL_SYB_SYSCHK_DCF=============CP

Application Component: BC-DB-SYB

Short Text: Access using a 'ZERO' object reference is not possible OR

Short Text: Zugriff über 'NULL' Objektreferenz nicht möglich


System log sm21 shows ASE Error SQL659

[ASE Error SQL659][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Table id xxx contains suspect indexes.

This table is only available for read-only purposes until the DBCC REINDEX command has been run on the indicated table to rebuild its suspect indexes.


Environment

SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite

SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Cause

Database index suspected with the reported object ID.


Solution