0 Replies Latest reply: Sep 13, 2010 8:24 AM by 807567 RSS

    Report generation fails with below error

    807567
      Hi Friends,

      This is an extarct from "ccat /var/opt/SUNWsymon/PRM/log/prm.log"

      Report generation fails for individual host but succeeds for all hosts.


      prmlog September 13, 2010 12:52:14 PM Thread-287: Begin loading files
      prmlog September 13, 2010 12:53:51 PM HandlerThread-0: Got trap: 2
      prmlog September 13, 2010 12:53:51 PM HandlerThread-2: Got trap: 2
      prmlog September 13, 2010 12:54:51 PM HandlerThread-1: Got trap: 2
      prmlog September 13, 2010 12:54:51 PM HandlerThread-2: Got trap: 2
      prmlog September 13, 2010 12:56:01 PM HandlerThread-0: Got trap: 2
      prmlog September 13, 2010 12:58:51 PM HandlerThread-0: Got trap: 2
      prmlog September 13, 2010 12:58:51 PM HandlerThread-2: Got trap: 2
      prmlog September 13, 2010 12:59:51 PM HandlerThread-1: Got trap: 2
      prmlog September 13, 2010 12:59:51 PM HandlerThread-2: Got trap: 2
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Call CrScheduledRequestBroker.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Call CrScheduledRequestBroker.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Call CrScheduledRequestBroker.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Call CrScheduledRequestBroker.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Call CrScheduledRequestBroker.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Database Error occurs!
      prmlog September 13, 2010 1:00:00 PM Parallel:0: ERROR: relation "detail_temp_host" does not exist
      prmlog September 13, 2010 1:00:00 PM Parallel:0: SchedOP: Exception: scp-2: Report request generation failed.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Call CrScheduledRequestBroker.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Database Error occurs!
      prmlog September 13, 2010 1:00:00 PM Parallel:0: ERROR: relation "detail_temp_host" does not exist
      prmlog September 13, 2010 1:00:00 PM Parallel:0: SchedOP: Exception: creature-t1000-08: Report request generation failed.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Database Error occurs!
      prmlog September 13, 2010 1:00:00 PM Parallel:0: ERROR: relation "detail_temp_host" does not exist
      prmlog September 13, 2010 1:00:00 PM Parallel:0: SchedOP: Exception: sdp-1-region2: Report request generation failed.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Database Error occurs!
      prmlog September 13, 2010 1:00:00 PM Parallel:0: ERROR: relation "detail_temp_host" does not exist
      prmlog September 13, 2010 1:00:00 PM Parallel:0: SchedOP: Exception: psp-1-region2: Report request generation failed.
      prmlog September 13, 2010 1:00:00 PM Parallel:0: Database Error occurs!
      prmlog September 13, 2010 1:00:00 PM Parallel:0: ERROR: relation "detail_temp_host" does not exist
      prmlog September 13, 2010 1:00:00 PM Parallel:0: SchedOP: Exception: shissun1: Report request generation failed.
      prmlog September 13, 2010 1:00:05 PM Thread-294: Report successfully posted to web server.
      prmlog September 13, 2010 1:01:01 PM HandlerThread-0: Got trap: 2
      prmlog September 13, 2010 1:03:54 PM HandlerThread-0: Got trap: 2


      In /tmp directory I could see database logs directory (/tmp/SunMCDBLogFiles)
      .
      Below is an extarct from "db-start-sql.log"



      ERROR: table "summ_temp_events" does not exist
      LOG: autovacuum: processing database "postgres"
      LOG: autovacuum: processing database "sunmc"
      LOG: autovacuum: processing database "postgres"
      LOG: autovacuum: processing database "sunmc"
      LOG: autovacuum: processing database "postgres"
      LOG: autovacuum: processing database "sunmc"
      LOG: autovacuum: processing database "postgres"
      LOG: autovacuum: processing database "sunmc"
      LOG: autovacuum: processing database "postgres"
      LOG: autovacuum: processing database "sunmc"
      LOG: autovacuum: processing database "postgres"
      LOG: autovacuum: processing database "sunmc"
      LOG: autovacuum: processing database "postgres"
      LOG: autovacuum: processing database "sunmc"
      WARNING: there is already a transaction in progress
      ERROR: relation "detail_temp_host" does not exist
      CONTEXT: SQL statement "INSERT INTO detail_temp_host (host_id) VALUES (21)"
      PL/pgSQL function "get_alarm_data_ids" line 203 at execute statement
      PL/pgSQL function "sp_get_nonperf_summary_data" line 92 at assignment
      WARNING: there is already a transaction in progress
      WARNING: there is already a transaction in progress
      ERROR: table "summ_temp_events" does not exist
      ERROR: relation "detail_temp_host" does not exist
      CONTEXT: SQL statement "INSERT INTO detail_temp_host (host_id) VALUES (26)"
      PL/pgSQL function "get_alarm_data_ids" line 203 at execute statement
      PL/pgSQL function "sp_get_nonperf_summary_data" line 92 at assignment
      ERROR: relation "detail_temp_host" does not exist
      CONTEXT: SQL statement "INSERT INTO detail_temp_host (host_id) VALUES (25)"
      PL/pgSQL function "get_alarm_data_ids" line 203 at execute statement
      PL/pgSQL function "sp_get_nonperf_summary_data" line 92 at assignment
      WARNING: there is already a transaction in progress
      ERROR: table "summ_temp_events" does not exist
      WARNING: there is already a transaction in progress
      ERROR: table "summ_temp_events" does not exist
      ERROR: relation "detail_temp_host" does not exist
      CONTEXT: SQL statement "INSERT INTO detail_temp_host (host_id) VALUES (42)"
      PL/pgSQL function "get_alarm_data_ids" line 203 at execute statement
      PL/pgSQL function "sp_get_nonperf_summary_data" line 92 at assignment
      ERROR: relation "detail_temp_host" does not exist
      CONTEXT: SQL statement "INSERT INTO detail_temp_host (host_id) VALUES (1)"
      PL/pgSQL function "get_alarm_data_ids" line 203 at execute statement


      Kindly suggest me.. This SUNMC is doing more than killing.

      Thanks
      Srini