SAP Knowledge Base Article - Preview

1909707 - How to handle HANA Alert 16: ‘Lock Wait Timeout Configuration'

Symptom

When checking the Alerts tab in HANA Studio or Solution Manager there is an alert called “Param lock_wait_timeout in indexserver.ini section transaction is set to value: 1”

  • For HANA Studio, you would find the alert by going to Administration Console -> Alerts -> Show: all alerts -> Filter input ‘lock’.

Capture1.PNG

  • For Solution Manager you would find the alert using transaction DBACOCKPIT -> choose HANA system -> expand Current Status -> Alerts.

Remember for this “Check lock waittimeout” alert in Solution Manager, it is auto-refreshed every 15 minutes, so the time stamp on the alert may not be the exact time when the alert occurs.

To check the exact time please go to Administration Console -> Alerts -> double click on the alerts -> more occurrence for this alert.

2.jpg

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental


Read more...

Environment

SAP HANA Database

Product

SAP HANA, platform edition all versions

Keywords

Operations Recommendation, #OpsRec-HANA; default value; , KBA , HAN-DB-MON , SAP HANA Monitoring , 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.