Bug #1315

Insert Hosts and Services in Oracle Datenbank

Added by pdeneu about 3 years ago. Updated about 3 years ago.

Status:ClosedStart date:03/21/2011
Priority:NormalDue date:
Assignee:Tommi% Done:

0%

Category:-
Target version:-
Icinga Version: DB Type:
IDO Version: DB Version:

Description

Hello,

afte a succesfull connection to the oracle databse i get the error in syslog:

ERROR: QUERY 'MERGE INTO service 

status USING DUAL ON (service_object_id=:X2) WHEN MATCHED THEN UPDATE SET instan 
ce_id=:X1, status_update_time=(SELECT unixts2date(:X3) FROM DUAL), output=:X4, l 
ong_output=:X5, perfdata=:X6, current_state=:X7, has_been_checked=:X8, should_be 
_scheduled=:X9, current_check_attempt=:X10, max_check_attempts=:X11, last_check= 
(SELECT unixts2date(:X12) FROM DUAL), next_check=(SELECT unixts2date(:X13) FROM 
DUAL), check_type=:X14, last_state_change=(SELECT unixts2date(:X15) FROM DUAL), 
last_hard_state_change=(SELECT unixts2date(:X16) FROM DUAL), last_hard_state=:X1 
7, last_time_ok=(SELECT unixts2date(:X1 FROM DUAL), last_time_warning=(SELECT 
unixts2date(:X19) FROM DUAL), last_time_unknown=(SELECT unixts2date(:X20) FROM D 
UAL), last_time_critical=(SELECT unixts2date(:X21) FROM DUAL), state_type=:X22, 
last_notification=(SELECT unixts2date(:X23) FROM DUAL), next_notification=(SELEC 
T unixts2date(:X24) FROM DUAL), no_more_notifications=:X25, notifications_enable 
d=:X26, problem_has_been_acknowledged=:X27, acknowledgement_type=:X28, current_n 
otification_number=:X29, passive_checks_enabled=:X30, active_checks_enabled=:X31 
, event_handler_enabled=:X32, flap_detection_enabled=:X33, is_flapping=:X34, per 
cent_state_change=:X35, latency=:X36, execution_time=:X37, scheduled_downtime_de 
pth=:X38, failure_prediction_enabled=:X39, process_performance_data=:X40, obsess 
_over_service=:X41, modified_service_attributes=:X42, event_handler=:X43, check_ 
command=:X44, normal_check_interval=:X45, retry_check_interval=:X46, check_timep 
eriod_object_id=:X47 WHEN NOT MATCHED THEN INSERT (id, instance_id, service_obje 
ct_id, status_update_time, output, long_output, perfdata, current_state, has_bee 
n_checked, should_be_scheduled, current_check_attempt, max_check_attempts, last_ 
check, next_check, check_type, last_state_change, last_hard_state_change, last_h 
ard_state, last_time_ok, last_time_warning, last_time_unknown, last_time_critica 
l, state_type, last_notification, next_notification, no_more_notifications, noti 
fications_enabled, problem_has_been_acknowledged, acknowledgement_type, current_ 
notification_number, passive_checks_enabled, active_checks_enabled, event_handle 
r_enabled, flap_detection_enabled, is_flapping, percent_state_change, latency, e 
xecution_time, scheduled_downtime_depth, failure_prediction_enabled, process_per 
formance_data, obsess_over_service, modified_service_attributes, event_handler, 
check_command, normal_check_interval, retry_check_interval, check_timeperiod_obj 
ect_id) VALUES (seq_servicestatus.nextval, :X1, :X2, (SELECT unixts2date(:X3) FR 
OM DUAL), :X4, :X5, :X6, :X7, :X8, :X9, :X10, :X11, (SELECT unixts2date(:X12) FR 
OM DUAL), (SELECT unixts2date(:X13) FROM DUAL), :X14, (SELECT unixts2date(:X15) 
FROM DUAL), (SELECT unixts2date(:X16) FROM DUAL), :X17, (SELECT unixts2date(:X18 
) FROM DUAL), (SELECT unixts2date(:X19) FROM DUAL), (SELECT unixts2date(:X20) FR 

OM DUAL), (SELECT unixts2date(:X21) FROM DUAL), :X22, (SELECT unixts2date(:X23) 
FROM DUAL), (SELECT unixts2date(:X24) FROM DUAL), :X25, :X26, :X27, :X28, :X29, 
:X30, :X31, :X32, :X33, :X34, :X35, :X36, :X37, :X38, :X39, :X40, :X41, :X42, :X 
43, :X44, :X45, :X46, :X47)' 
16:54:59 [1298649299.158559] [001.2] [pid=5217] ERROR: MSG 'ORA-01438: value lar 
ger than specified precision allowed for this column 

Any ideas? I used the original oracle.sql script and the database scripts from https://wiki.icinga.org/display/howtos/Icinga+and+Oracle+Part3+-+Configuration
in both situations i get the same error....

Kind regards,
Philipp


Related issues

Related to IDOUtils - Bug #1173: int(11) to small for some of ido tables Closed 01/31/2011

History

#1 Updated by dnsmichi about 3 years ago

  • Status changed from New to Feedback
  • Priority changed from High to Normal

http://ora-01438.ora-code.com

should be sufficient as first explaination. this is a follow up on issue #1173, whereas the column is not defined as int, but as number with precision 6 and/or 11, which gets exceeded.

#2 Updated by dnsmichi about 3 years ago

  • Status changed from Feedback to Closed
  • Assignee set to Tommi

thomas will work on that in #1173, completely dropping number precision.

Also available in: Atom PDF