Empty Payload Templates
search cancel

Empty Payload Templates

book

Article ID: 390206

calendar_today

Updated On:

Products

VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Payload templates are missing when navigating to Operations -> Configurations -> Payload Templates in the UI
Attempting to access payload templates via the API /api/notifications/templates it returns:

{
  "message": "Internal Server error, cause unknown.",
  "httpStatusCode": 500,
  "apiErrorCode": 500
}

Environment

VMware Aria Operations 8.18.x

Cause

Notification template's grid remains blank if a problematic template is present.

Resolution

NOTE: Prior to proceeding with the steps outlined below, please ensure that you have taken offline snapshots of all nodes.

Follow the below steps to resolve the issue.

  • query the list of notification templates  using the below command.
    su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433 -c \"select * from kv_notificationplugin\"" > /tmp/notification_dump.txt

    Open the file in a text editor (word wrapping set to off). Use the keyword "NotificationTemplateData." (this is the template key to be used to delete the bad template).  Analyze the templates, must probably the bad one is a custom template. Locate it and then remove from DB by its ID:

  • Delete that template(s) it from DB using SQL command.
     
    su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433 -c \"delete from kv_notificationplugin where key = 'NotificationTemplateData.PUT_THE_ID_OF BAD_TEMPLATE_HERE'\""

  • Log in to the Aria Operations UI to confirm that all default templates are now available.

Additional Information

Powered by Wolken Software