Hello,
We’ve recently updated our CMDB install from 3.4 to 3.4.2 in our dev environment. After the upgrade, we are receiving a “Generic Error” toast popup when navigating to the Administration Home page. Clicking the popup for more information expands:
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT "type" AS _type, "count" AS _count FROM _cm3_dashboard_model_stats() _cmdashboardmodelstats]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: jsonb @? unknown
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Where: PL/pgSQL function _cm3_dashboard_model_stats() line 2 at RETURN QUERY, caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: jsonb @? unknown
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Where: PL/pgSQL function _cm3_dashboard_model_stats() line 2 at RETURN QUERY
I believe this is related to the Models Statistics graph, which isn’t showing any data. Has anyone encountered this or have a fix? Is this a known issue with 3.4.2?
Thank you!