This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
OO "database health" graphics is not refershed with new data
Question
Could not retrieve data from the database: StatementCallback; bad SQL grammar [SELECT * FROM (SELECT Q1."TYPE", SUM(Q1."SIZE") AS "SIZE" FROM (SELECT CASE UPPER(tablename) WHEN 'OO_EXECUTION_SUMMARY' THEN 'E' WHEN 'OO_STEP_LOG_STARTED' THEN 'E' WHEN 'OO_STEP_LOG_ENDED' THEN 'E' WHEN 'OO_STEP_LOG_BINDINGS' THEN 'E' WHEN 'OO_EXECUTION_BOUND_OUTPUTS' THEN 'E' WHEN 'OO_EXECUTION_BOUND_INPUTS' THEN 'E' WHEN 'OO_DEBUGGER_EVENTS' THEN 'D' WHEN 'OO_AUDIT' THEN 'A' WHEN 'OO_STEP_EXEC_DATA' THEN 'R' END AS "TYPE", floor(sum(pg_total_relation_size(tablename::regclass::oid))/1048576) AS "SIZE" FROM pg_tables WHERE LOWER(schemaname) NOT IN ('pg_catalog', 'information_schema') AND UPPER(tablename) IN ('OO_EXECUTION_SUMMARY','OO_STEP_LOG_STARTED','OO_STEP_LOG_ENDED','OO_STEP_LOG_BINDINGS','OO_EXECUTION_BOUND_OUTPUTS','OO_EXECUTION_BOUND_INPUTS','OO_DEBUGGER_EVENTS','OO_AUDIT','OO_STEP_EXEC_DATA') GROUP BY tablename) AS Q1 GROUP BY "TYPE") AS Q2 UNION ALL SELECT 'O' AS "TYPE", ceil(sum(pg_total_relation_size(tablename::regclass::oid))/1048576) AS "SIZE" FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY "TYPE" ASC];
nested exception is org.postgresql.util.PSQLException: ERROR: relation "sl_strtd_stps" does not exist
nested exception is org.postgresql.util.PSQLException: ERROR: relation "sl_strtd_stps" does not exist
Answer
The following tables are temporary tables has been left by other actions :---------------"pg_temp_3" "sl_strtd_stps" "postgres" false false false false"pg_temp_3" "st_hash_ids" "postgres" false false false false"pg_temp_3" "st_ended_ids" "postgres" false false false false"pg_temp_3" "arbitrary_ids" "postgres" false false false false"pg_temp_3" "arbitrary_ids_compact" "postgres" false false false false--------------Removing these tables helped to fix the problem