[Solved] 2007437 – Alert Internal statistics server problem in SAP HANA

Symptom

In a HANA system, the following alert is seen repeatedly:

Rating: Error
Error writing data to table HOST_SQL_PLAN_CACHE: 274 inserted value too large for column: Failed in “ACCESSED_OBJECTS” column with the value…..

Environment

SAP HANA 1.00

Cause

If there is a plan, that is accessing more objects than expected in the definition of the history statistics server table for HOST_SQL_PLAN_CACHE, these errors/alerts occur.

How To Check

grep for the error Failed in “ACCESSED_OBJECTS” in Statisticsserver trace.

Resolution

Please execute the following statement to change the table definition:

alter table _SYS_STATISTICS.HOST_SQL_PLAN_CACHE alter (accessed_objects varchar(5000));
Note: This workaround needs to be applied for every system which
was initially installed with a revision < 64, as the size of this
view was increased in revision 64.

Leave a Reply