Text Widget Content not visible in aria operations after saving configuration

Products

• VMware Aria Suite

Issue/Introduction

• When attempting to create a Text Widget Content in Aria Operations, the process involves creating a folder and writing the necessary HTML code. However, after saving the configuration, the widget disappears from the Aria Operations UI.
• Upon inspecting the element details using Developer Tools, the request fails with an 'Internal Server Error.' This issue prevents the widget from being rendered correctly in the UI.
  
  
  
• The /storage/vcops/log/web.log file indicates errors related to /ui/metricConfigXML.action and a java.lang.NullPointerException
  
  Url: /ui/metricConfigXML.action
Params: mainAction=getList
)
java.lang.NullPointerException: null
    at com.vmware.vcops.ui.action.MetricConfigXMLAction.execute(MetricConfigXMLAction.java:84) ~[classes/:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
    at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
    at ognl.OgnlRuntime.invokeMethodInsideSandbox(OgnlRuntime.java:1245) ~[ognl-3.3.4.jar:?]
    at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:1230) ~[ognl-3.3.4.jar:?]
    at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1958) ~[ognl-3.3.4.jar:?]
    at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68) ~[ognl-3.3.4.jar:?]
    at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:98) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:90) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:2034) ~[ognl-3.3.4.jar:?]
    at ognl.ASTMethod.getValueBody(ASTMethod.java:97) ~[ognl-3.3.4.jar:?]
    at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ~[ognl-3.3.4.jar:?]
    at ognl.SimpleNode.getValue(SimpleNode.java:258) ~[ognl-3.3.4.jar:?]
    at ognl.Ognl.getValue(Ognl.java:586) ~[ognl-3.3.4.jar:?]
    at ognl.Ognl.getValue(Ognl.java:550) ~[ognl-3.3.4.jar:?]
    at com.opensymphony.xwork2.ognl.OgnlUtil.lambda$callMethod$4(OgnlUtil.java:599) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:642) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:599) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:434) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:307) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:259) ~[struts2-core-6.3.0.2.jar:6.3.0.2]
    at com.vmware.vcops.ui.util.PreResultInterceptor.intercept(PreResultInterceptor.java:51) ~[classes/:?]
  

Environment

Aria Operations 8.18.X

Cause

The root cause is the presence of residual files from deprecated and deleted management packs (EMC & VMware vRealize Business for Cloud) within the Aria Operations database. Specifically, null value records in the kv_solutioncontentnamespace table are causing an exception, preventing the Text Widget Content from being rendered correctly.

Resolution

To resolve the issue, follow these steps:

Note: Take a snapshot of all Aria operations nodes as mentioned in the knowledge base, then follow the steps below.

1. SSH into the primary Aria Operations node and log in as root:

•  Run the following command to access the Postgres database:

            su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433"

2. Identify null value records in the kv_solutioncontentnamespace table:

•  Run the following SQL query:

             select key from kv_solutioncontentnamespace where col__kv_strvalue is null;

Note: If the query above returns any rows, delete them according to step 3. If not, we need to look for the cause elsewhere.

3. Delete the null value records from the table:

•  Run the following SQL command to delete the problematic records:

            delete from kv_solutioncontentnamespace where col__kv_strvalue is null;

4.Verify the resolution:

•  After removing the invalid records, the Text Widget Content should be visible in the Aria Operations UI without any errors.