This discussion is archived
0 Replies Latest reply: Sep 13, 2010 6:24 AM by 807567 RSS

Report generation fails with below error

807567 Newbie
Currently Being Moderated
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