Error starting at line : 11,887 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('28415','20','1.3.6.1.4.1.232.3.2.2.2.1.2.{#SNMPINDEX}','10256','#{#CACHE_CNTRL_INDEX}: Disk array cache controller status','system.hw.diskarray.cache.status[cpqDaAccelStatus.{#SNMPINDEX}]','1m','7d','0d','0','3','','','','',NULL,'71','','','0','','','','','2',NULL,TO_NCLOB('MIB: CPQIDA-MIB' || chr(13) || chr(10) || 'Cache Module/Operations Status. This describes the status of the cache module and/or cache operations.' || chr(13) || chr(10) || 'Note that for some controller models, a cache module board that physically attaches to the controller or chipset may not be an available option.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'The status can be:' || chr(13) || chr(10) || 'Other (1)' || chr(13) || chr(10) || ' Indicates that the instrument agent does not recognize the status of the cache module. You may need to upgrade the instrument agent.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'Invalid (2)' || chr(13) || chr(10) || ' Indicates that a cache module board has not been installed in this system or is present but not configured.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'Enabled (3)' || chr(13) || chr(10) || ' Indicates that cache operations are currently configured and enabled for at least one logical drive.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'Temporarily Disabled (4)' || chr(13) || chr(10) || ' Indicates that cache operations have been temporarily disabled. View the cache module board error code object to determine why the write cache operations have been temporarily disabled.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'Permanently Disabled (5)' || chr(13) || chr(10) || ' Indicates that cache operations have been permanently disabled. View the cache module board error code object to determine why the write cache operations have been disabled.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'Cache Module Flash Memory Not Attached (6)' || chr(13) || chr(10) || ' Indicates that the flash memory component of the flash backed cache module is not attached. This status will be set when the flash memory is not attached and the Supercap is attached. This value is only used on flash backed cache modules that support removable flash memory.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || '')|| TO_NCLOB('Cache Module Degraded Failsafe Speed (7)' || chr(13) || chr(10) || ' Indicates that the cache module board is currently degraded and operating at a failsafe speed. View variables cpqDaCacheMemoryDataWidth and cpqDaCacheMemoryTransferRate to obtain the cache module board`s current memory data width and memory transfer rate.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'Cache Module Critical Failure (8)' || chr(13) || chr(10) || ' Indicates that the cache module board has encountered a critical failure. The controller is currently operating in Zero Memory Raid mode.' || chr(13) || chr(10) || '' || chr(13) || chr(10) || 'Read Cache Could Not Be Mapped (9)' || chr(13) || chr(10) || '')|| TO_NCLOB(' Indicates that the read cache memory in a split cache configuration could not be mapped by the operating system and as a result is not available. This status may be caused by virtual space limitations in certain operating systems and is only applicable to B-Series controllers.'),'0','30d','0','',NULL,'3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-12899: value too large for column "ZABBIX2"."ITEMS"."DESCRIPTION" (actual: 2216, maximum: 2048) Error starting at line : 14,432 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('31362','11','','10329','Oracle: Get tablespaces stats','db.odbc.get[tablespace_stats,"{$ORACLE.DSN}"]','1m','0','0','0','4','','','','',NULL,NULL,|| TO_NCLOB('SELECT df.tablespace_name AS TABLESPACE, df.type AS TYPE, NVL(SUM(df.BYTES), 0) AS FILE_BYTES, NVL(SUM(df.MAX_BYTES), 0) AS MAX_BYTES, NVL(SUM(f.FREE), 0) AS FREE_BYTES, SUM(df.BYTES)-SUM(f.FREE) AS USED_BYTES, ROUND(DECODE(SUM(df.MAX_BYTES), 0, 0, (SUM(df.BYTES) / SUM(df.MAX_BYTES) * 100)), 2) AS USED_PCT_MAX, ROUND(DECODE(SUM(df.BYTES), 0, 0,(SUM(df.BYTES)-SUM(f.FREE))/ SUM(df.BYTES)* 100), 2) AS USED_FILE_PCT, DECODE(df.STATUS, ''ONLINE'', 1, ''OFFLINE'', 2, ''READ ONLY'', 3, 0) AS STATUS FROM ( SELECT ddf.file_id, dt.contents AS TYPE, dt.STATUS , ddf.file_name, ddf.tablespace_name, TRUNC(ddf.bytes) AS bytes, TRUNC(GREATEST(ddf.bytes, ddf.maxbytes)) AS max_bytes FROM dba_data_files ddf, dba_tablespaces dt WHERE ddf.tablespace_name = dt.tablespace_name ) df, ( SELECT TRUNC(SUM(bytes)) AS FREE, file_id FROM dba_free_space GROUP BY file_id ) f WHERE df.file_id = f.file_id (+) GROUP BY df.tablespace_name, df.TYPE, df.status UNION ALL SELECT Y.name AS TABLESPACE, Y.type AS TYPE, NVL(SUM(Y.BYTES), 0) AS FILE_BYTES, NVL(SUM(Y.MAX_BYTES), 0) AS MAX_BYTES, NVL(MAX(NVL(Y.FREE_BYTES, 0)), 0) AS FREE, SUM(Y.BYTES)-SUM(Y.FREE_BYTES) AS USED_BYTES, ROUND(DECODE(SUM(Y.MAX_BYTES), 0, 0, (SUM(Y.BYTES) / SUM(Y.MAX_BYTES) * 100)), 2) AS USED_PCT_MAX, ROUND(DECODE(SUM(Y.BYTES), 0, 0,(SUM(Y.BYTES)-SUM(Y.FREE_BYTES))/ SUM(Y.BYTES)* 100), 2) AS USED_FILE_PCT, DECODE(Y.TBS_STATUS, ''ONLINE'', 1, ''OFFLINE'', 2, ''READ ONLY'', 3, 0) AS STATUS FROM ( SELECT dtf.tablespace_name AS name, dt.contents AS TYPE, dt.STATUS AS tbs_status, dtf.status AS status, dtf.bytes AS bytes, (SELECT ((f.total_blocks - s.tot_used_blocks)* vp.value) FROM ( SELECT tablespace_name, SUM(used_blocks) tot_used_blocks FROM gv$sort_segment WHERE tablespace_name != ''DUMMY'' GROUP BY tablespace_name) s, ( SELECT tablespace_name, SUM(blocks) total_blocks FROM dba_temp_files WHERE tablespace_name != ''DUMMY'' GROUP BY tablespace_name) f, ( SELECT value FROM v$parameter WHERE name = ''db_block_size'') vp WHERE f.tablespace_name = s.tablespace_name AND f.tablespace_name = dtf.tablespace_name ) AS free_bytes, CASE WHEN dtf.maxbytes = 0 THEN dtf.bytes ELSE dtf.maxbytes END AS max_bytes FROM sys.dba_temp_files dtf, sys.dba_tablespaces dt WHERE dtf.tablespace_name = dt.tablespace_name ) Y GROUP BY Y.name, Y.TYPE, Y.tbs_status;'),'','0','{$ORACLE.USER}','{$ORACLE.PASSWORD}','','','0',NULL,'Get tablespaces stats.','0','30d','0','',NULL,'3s','','','','200','1','0','','0','0','0','0','0','0','0') Error at Command Line : 14,433 Column : 156 Error report - SQL Error: ORA-00936: missing expression 00936. 00000 - "missing expression" *Cause: *Action: Error starting at line : 26,781 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('31450','18','','10329','Oracle TBS ''{#TABLESPACE}'': Tablespace free, bytes','oracle.tbs_free_bytes["{#TABLESPACE}"]','0','7d','365d','0','3','','B','','',NULL,NULL,'','','0','','','','','2',NULL,'Free bytes of allocated space.','0','30d','0','','31362','3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_5) violated - parent key not found Error starting at line : 26,785 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('31451','18','','10329','Oracle TBS ''{#TABLESPACE}'': Tablespace MAX size, bytes','oracle.tbs_max_bytes["{#TABLESPACE}"]','0','7d','365d','0','3','','B','','',NULL,NULL,'','','0','','','','','2',NULL,'Maximum size of tablespace.','0','30d','0','','31362','3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_5) violated - parent key not found Error starting at line : 26,789 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('31452','18','','10329','Oracle TBS ''{#TABLESPACE}'': Open status','oracle.tbs_status["{#TABLESPACE}"]','0','7d','365d','0','3','','','','',NULL,'117','','','0','','','','','2',NULL,'Tablespace status. 1 - ''ONLINE'' 2 - ''OFFLINE'' 3- ''READ ONLY''','0','30d','0','','31362','3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_5) violated - parent key not found Error starting at line : 26,793 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('31454','18','','10329','Oracle TBS ''{#TABLESPACE}'': Tablespace allocated, percent','oracle.tbs_used_pct["{#TABLESPACE}"]','0','7d','365d','0','0','','%','','',NULL,NULL,'','','0','','','','','2',NULL,'Allocated bytes/Max bytes*100','0','30d','0','','31362','3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_5) violated - parent key not found Error starting at line : 27,361 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('31786','18','','10329','Oracle TBS ''{#TABLESPACE}'': Tablespace allocated, bytes','oracle.tbs_alloc_bytes["{#TABLESPACE}"]','0','7d','365d','0','3','','B','','',NULL,NULL,'','','0','','','','','2',NULL,'Currently allocated bytes for tablespace (sum of the current size of datafiles).','0','30d','0','','31362','3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_5) violated - parent key not found Error starting at line : 28,457 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('32590','18','','10329','Oracle TBS ''{#TABLESPACE}'': Tablespace used, bytes','oracle.tbs_used_bytes["{#TABLESPACE}"]','0','7d','365d','0','3','','B','','',NULL,NULL,'','','0','','','','','2',NULL,'Currently used bytes for tablespace (current size of datafiles-free space).','0','30d','0','','31362','3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_5) violated - parent key not found Error starting at line : 28,461 in command - INSERT INTO items (itemid,type,snmp_oid,hostid,name,key_,delay,history,trends,status,value_type,trapper_hosts,units,formula,logtimefmt,templateid,valuemapid,params,ipmi_sensor,authtype,username,password,publickey,privatekey,flags,interfaceid,description,inventory_link,lifetime,evaltype,jmx_endpoint,master_itemid,timeout,url,query_fields,posts,status_codes,follow_redirects,post_type,headers,retrieve_mode,request_method,output_format,verify_peer,verify_host,allow_traps,discover) values ('32591','18','','10329','Oracle TBS ''{#TABLESPACE}'': Tablespace usage, percent','oracle.tbs_used_file_pct["{#TABLESPACE}"]','0','7d','365d','0','0','','%','','',NULL,NULL,'','','0','','','','','2',NULL,'Used bytes/Allocated bytes*100','0','30d','0','','31362','3s','','','','200','1','0','','0','0','0','0','0','0','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_5) violated - parent key not found Error starting at line : 51,369 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('17977','28415','15787','count','#1,{$DISK_ARRAY_CACHE_CRIT_STATUS:"cacheModCriticalFailure"},eq') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 56,217 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('19994','31452','17043','last','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 56,221 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('19995','31452','17044','diff','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,197 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20816','32591','17715','min','5m') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,201 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20817','32591','17716','min','5m') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,205 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20818','31454','17717','min','5m') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,209 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20819','31454','17718','min','5m') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,477 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20892','28415','17769','count','#1,{$DISK_ARRAY_CACHE_WARN_STATUS:"cacheModDegradedFailsafeSpeed"},eq') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,481 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20893','28415','17769','count','#1,{$DISK_ARRAY_CACHE_WARN_STATUS:"cacheReadCacheNotMapped"},eq') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,485 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20894','28415','17769','count','#1,{$DISK_ARRAY_CACHE_WARN_STATUS:"cacheModFlashMemNotAttached"},eq') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,489 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20895','28415','17770','count','#1,{$DISK_ARRAY_CACHE_OK_STATUS:"enabled"},ne') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 59,493 in command - INSERT INTO functions (functionid,itemid,triggerid,name,parameter) values ('20896','28415','17770','last','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_FUNCTIONS_1) violated - parent key not found Error starting at line : 72,373 in command - INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values ('53927','1238','31786','0','0','1A7C11','0','2','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_GRAPHS_ITEMS_2) violated - parent key not found Error starting at line : 72,377 in command - INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values ('53928','1238','31451','0','1','2774A4','0','2','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_GRAPHS_ITEMS_2) violated - parent key not found Error starting at line : 72,381 in command - INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) values ('53929','1238','32590','0','2','F63100','0','2','0') Error report - ORA-02291: integrity constraint (ZABBIX2.C_GRAPHS_ITEMS_2) violated - parent key not found Error starting at line : 91,645 in command - INSERT INTO items_applications (itemappid,applicationid,itemid) values ('112545','1340','31362') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_APPLICATIONS_2) violated - parent key not found Error starting at line : 100,497 in command - INSERT INTO items_applications (itemappid,applicationid,itemid) values ('114758','1080','28415') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEMS_APPLICATIONS_2) violated - parent key not found Error starting at line : 108,661 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('1416','28415','28401') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 111,889 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('2393','31450','31438') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 111,893 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('2394','31451','31438') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 111,897 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('2395','31452','31438') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 111,901 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('2397','31454','31438') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 112,197 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('2471','31786','31438') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 113,121 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('2711','32590','31438') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 113,125 in command - INSERT INTO item_discovery (itemdiscoveryid,itemid,parent_itemid) values ('2712','32591','31438') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_DISCOVERY_1) violated - parent key not found Error starting at line : 124,965 in command - INSERT INTO item_application_prototype (item_application_prototypeid,application_prototypeid,itemid) values ('973','142','31450') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_APPLICATION_PROTOTYPE_2) violated - parent key not found Error starting at line : 124,969 in command - INSERT INTO item_application_prototype (item_application_prototypeid,application_prototypeid,itemid) values ('974','142','31451') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_APPLICATION_PROTOTYPE_2) violated - parent key not found Error starting at line : 124,973 in command - INSERT INTO item_application_prototype (item_application_prototypeid,application_prototypeid,itemid) values ('975','142','31452') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_APPLICATION_PROTOTYPE_2) violated - parent key not found Error starting at line : 124,977 in command - INSERT INTO item_application_prototype (item_application_prototypeid,application_prototypeid,itemid) values ('977','142','31454') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_APPLICATION_PROTOTYPE_2) violated - parent key not found Error starting at line : 125,189 in command - INSERT INTO item_application_prototype (item_application_prototypeid,application_prototypeid,itemid) values ('1030','142','31786') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_APPLICATION_PROTOTYPE_2) violated - parent key not found Error starting at line : 125,921 in command - INSERT INTO item_application_prototype (item_application_prototypeid,application_prototypeid,itemid) values ('1228','142','32590') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_APPLICATION_PROTOTYPE_2) violated - parent key not found Error starting at line : 125,925 in command - INSERT INTO item_application_prototype (item_application_prototypeid,application_prototypeid,itemid) values ('1229','142','32591') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_APPLICATION_PROTOTYPE_2) violated - parent key not found Error starting at line : 136,949 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('63442','31450','1','12','$[?(@.TABLESPACE==''{#TABLESPACE}'')].FREE_BYTES.first()','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found Error starting at line : 136,953 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('63443','31451','1','12','$[?(@.TABLESPACE==''{#TABLESPACE}'')].MAX_BYTES.first()','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found Error starting at line : 136,957 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('63444','31452','1','12','$[?(@.TABLESPACE==''{#TABLESPACE}'')].STATUS.first()','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found Error starting at line : 136,961 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('63445','31454','1','12','$[?(@.TABLESPACE==''{#TABLESPACE}'')].USED_PCT_MAX.first()','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found Error starting at line : 136,965 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('63446','31786','1','12','$[?(@.TABLESPACE==''{#TABLESPACE}'')].FILE_BYTES.first()','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found Error starting at line : 143,545 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65117','31971','1','21',TO_NCLOB('var Ami = {' || chr(10) || ' params: {' || chr(10) || ' url: ''{$AMI.URL}'',' || chr(10) || ' trunk: ''{$AMI.TRUNK_REGEXP}''' || chr(10) || ' },' || chr(10) || ' api_request: new CurlHttpRequest(),' || chr(10) || '' || chr(10) || ' request: function (url, action) {' || chr(10) || ' url += action;' || chr(10) || ' Zabbix.Log(4, ''[ Asterisk ] Sending request: '' + url);' || chr(10) || ' try {' || chr(10) || ' response = Ami.api_request.Get(url);' || chr(10) || ' } catch (error) {' || chr(10) || ' Zabbix.Log(4, ''[ Asterisk ] Get request returned error '' + error);' || chr(10) || ' throw ''Get request returned error '' + error + ''. Check debug log for more information.'';' || chr(10) || ' }' || chr(10) || ' Zabbix.Log(4, ''[ Asterisk ] Received response with status code '' +' || chr(10) || ' Ami.api_request.Status() + ''\n'' + response);' || chr(10) || '' || chr(10) || ' if (Ami.api_request.Status() !== 200) {' || chr(10) || ' var message = ''Request failed with status code '' + Ami.api_request.Status();' || chr(10) || ' if (response !== null) {' || chr(10) || ' if (typeof response.message === ''string'') {' || chr(10) || ' message += '': '' + response.message;' || chr(10) || ' }' || chr(10) || ' }' || chr(10) || '' || chr(10) || ' throw message + '' Check debug log for more information.'';' || chr(10) || ' }' || chr(10) || '' || chr(10) || ' var match = response.match(''Response: (.+)\r\n'');' || chr(10) || ' if (match !== null && match[1] !== ''Success'' && match[1] !== ''Goodbye'' && match[1] !== ''Follows'') {' || chr(10) || ' var message = ''Request failed with message '' + match[1];' || chr(10) || '' || chr(10) || ' match = response.match(''Message: (.+)\r\n'');' || chr(10) || ' if (match !== null && match[1]) {' || chr(10) || '')|| TO_NCLOB(' message += '': '' + match[1];' || chr(10) || ' }' || chr(10) || '' || chr(10) || ' throw message + ''. Check debug log for more information.'';' || chr(10) || ' }' || chr(10) || '' || chr(10) || ' return {' || chr(10) || ' status: Ami.api_request.Status(),' || chr(10) || ' body: response' || chr(10) || ' };' || chr(10) || ' }' || chr(10) || '};' || chr(10) || '' || chr(10) || 'var asterisk = {' || chr(10) || ' version: '''',' || chr(10) || ' uptime: 0,' || chr(10) || ' uptime_reload: 0,' || chr(10) || ' active_channels: 0,' || chr(10) || ' active_calls: 0,' || chr(10) || ' calls_processed: 0,' || chr(10) || ' sip: {' || chr(10) || ' trunks: [],' || chr(10) || ' monitored_online: 0,' || chr(10) || ' monitored_offline: 0,' || chr(10) || ' unmonitored_online: 0,' || chr(10) || ' unmonitored_offline: 0,' || chr(10) || ' total: 0' || chr(10) || ' },' || chr(10) || ' iax: {' || chr(10) || ' trunks: [],' || chr(10) || ' online: 0,' || chr(10) || ' offline: 0,' || chr(10) || ' unmonitored: 0,' || chr(10) || ' total: 0' || chr(10) || ' },' || chr(10) || ' pjsip: {' || chr(10) || ' trunks: [],' || chr(10) || ' available: 0,' || chr(10) || ' unavailable: 0,' || chr(10) || ' total: 0' || chr(10) || ' },' || chr(10) || ' queue: {' || chr(10) || ' queues: [],' || chr(10) || ' total: 0' || chr(10) || ' }' || chr(10) || '};' || chr(10) || '' || chr(10) || 'function block2Object(text) {' || chr(10) || ' var fields = [],' || chr(10) || ' dict = {};' || chr(10) || '' || chr(10) || ' text.split(''\r\n'').forEach(function (line) {' || chr(10) || ' fields = line.split('': '');' || chr(10) || ' dict[fields[0]] = fields[1];' || chr(10) || ' })' || chr(10) || '' || chr(10) || ' return dict;' || chr(10) || '}' || chr(10) || '' || chr(10) || '')|| TO_NCLOB('function text2Object(text) {' || chr(10) || ' var blocks = text.split(''\r\n\r\n''),' || chr(10) || ' arr = [],' || chr(10) || ' i = 1,' || chr(10) || ' j = blocks.length - 2;' || chr(10) || '' || chr(10) || ' for (i; i < j; i++) {' || chr(10) || ' arr.push(block2Object(blocks[i]));' || chr(10) || ' }' || chr(10) || '' || chr(10) || ' return arr;' || chr(10) || '}' || chr(10) || '' || chr(10) || 'function getSipPeers() {' || chr(10) || ' var response = Ami.request(url, ''SIPpeers''),' || chr(10) || ' elements = text2Object(response.body);' || chr(10) || ' asterisk.sip.total = elements.length;' || chr(10) || ' asterisk.sip.trunks = elements.filter(function (element) {' || chr(10) || ' return element.ObjectName.search(Ami.params.trunk) != -1;' || chr(10) || ' });' || chr(10) || ' elements.forEach(function (element) {' || chr(10) || ' if (element.IPaddress === ''-none-'') {' || chr(10) || ' switch (element.Status) {' || chr(10) || ' case ''Unmonitored'':' || chr(10) || ' asterisk.sip.unmonitored_offline++;' || chr(10) || ' break;' || chr(10) || '' || chr(10) || ' case ''UNKNOWN'':' || chr(10) || ' asterisk.sip.monitored_offline++;' || chr(10) || ' break;' || chr(10) || ' }' || chr(10) || ' }' || chr(10) || ' else {' || chr(10) || ' if (element.Status === ''Unmonitored'') {' || chr(10) || ' asterisk.sip.unmonitored_online++;' || chr(10) || ' }' || chr(10) || ' else {' || chr(10) || ' asterisk.sip.monitored_online++;' || chr(10) || ' if (element.Status.search(''^OK'') != -1) {' || chr(10) || ' element.Status = element.Status.split('' '')[0];' || chr(10) || ' }' || chr(10) || ' }' || chr(10) || ' }' || chr(10) || ' });' || chr(10) || ' asterisk.sip.trunks.forEach(function (trunk) {' || chr(10) || '')|| TO_NCLOB(' var active_channels = channels.match(new RegExp('' SIP/'' + trunk.ObjectName.split(''/'')[0], ''g''));' || chr(10) || ' trunk.active_channels = (active_channels === null) ? 0 : active_channels.length;' || chr(10) || ' });' || chr(10) || '}' || chr(10) || '' || chr(10) || 'function getIaxPeerList() {' || chr(10) || ' response = Ami.request(url, ''IAXpeerlist'');' || chr(10) || ' elements = text2Object(response.body);' || chr(10) || ' asterisk.iax.total = elements.length;' || chr(10) || ' asterisk.iax.trunks = elements.filter(function (element) {' || chr(10) || ' return element.ObjectName.search(Ami.params.trunk) != -1;' || chr(10) || ' });' || chr(10) || ' elements.forEach(function (element) {' || chr(10) || ' if (element.Status.search(''^OK'') != -1) {' || chr(10) || ' element.Status = element.Status.split('' '')[0];' || chr(10) || ' }' || chr(10) || ' switch (element.Status) {' || chr(10) || ' case ''Unmonitored'':' || chr(10) || ' asterisk.iax.unmonitored++;' || chr(10) || ' break;' || chr(10) || '' || chr(10) || ' case ''UNKNOWN'':' || chr(10) || ' asterisk.iax.offline++;' || chr(10) || ' break;' || chr(10) || ' }' || chr(10) || ' });' || chr(10) || ' asterisk.iax.online = asterisk.iax.total - asterisk.iax.offline;' || chr(10) || ' asterisk.iax.trunks.forEach(function (trunk) {' || chr(10) || ' var active_channels = channels.match(new RegExp(''( IAX2/'' + trunk.ObjectName.split(''/'')[0] +' || chr(10) || ' ''| IAX2/'' + trunk.ObjectUsername + '')'', ''g''));' || chr(10) || ' trunk.active_channels = (active_channels === null) ? 0 : active_channels.length;' || chr(10) || ' });' || chr(10) || '}' || chr(10) || '' || chr(10) || 'function getPjsipShowEndpoints() {' || chr(10) || ' response = Ami.request(url, ''PJSIPShowEndpoints'');' || chr(10) || ' elements = text2Object(response.body);' || chr(10) || '')|| TO_NCLOB(' asterisk.pjsip.total = elements.length;' || chr(10) || ' asterisk.pjsip.trunks = elements.filter(function (element) {' || chr(10) || ' return element.ObjectName.search(Ami.params.trunk) != -1;' || chr(10) || ' });' || chr(10) || '' || chr(10) || ' elements.forEach(function (element) {' || chr(10) || ' if (element.DeviceState === ''Unavailable'') {' || chr(10) || ' asterisk.pjsip.unavailable++;' || chr(10) || ' }' || chr(10) || ' });' || chr(10) || ' asterisk.pjsip.available = asterisk.pjsip.total - asterisk.pjsip.unavailable;' || chr(10) || ' asterisk.pjsip.trunks.forEach(function (trunk) {' || chr(10) || ' var active_channels = channels.match(new RegExp('' PJSIP/'' + trunk.ObjectName.split(''/'')[0], ''g''));' || chr(10) || ' trunk.active_channels = (active_channels === null) ? 0 : active_channels.length;' || chr(10) || ' });' || chr(10) || '}' || chr(10) || '' || chr(10) || 'function getQueueSummary() {' || chr(10) || ' response = Ami.request(url, ''QueueSummary'');' || chr(10) || ' asterisk.queue.queues = text2Object(response.body);' || chr(10) || ' asterisk.queue.total = asterisk.queue.queues.length;' || chr(10) || '}' || chr(10) || '' || chr(10) || 'var cookie = value.match(/mansession_id="([0-9A-z]+)"/);' || chr(10) || 'if (cookie == null) {' || chr(10) || ' throw ''Cannot find mansession_id with cookie in response.'';' || chr(10) || '}' || chr(10) || '' || chr(10) || 'var url = Ami.params.url.split(''?'')[0] + ''?action='';' || chr(10) || '' || chr(10) || 'Ami.api_request.AddHeader(''Cookie: mansession_id="'' + cookie[1] + ''"'');' || chr(10) || '' || chr(10) || 'var response = Ami.request(url, ''CoreSettings'');' || chr(10) || 'var coreSettings = block2Object(response.body);' || chr(10) || 'if (typeof coreSettings.AsteriskVersion !== ''undefined'') {' || chr(10) || ' asterisk.version = coreSettings.AsteriskVersion;' || chr(10) || '}' || chr(10) || '' || chr(10) || 'response = Ami.request(url, ''CoreStatus'');' || chr(10) || '')|| TO_NCLOB('var coreStatus = block2Object(response.body);' || chr(10) || 'if (typeof coreStatus.CoreStartupDate !== ''undefined'') {' || chr(10) || ' asterisk.uptime = (Date.now() - Date.parse(coreStatus.CoreStartupDate + " " + coreStatus.CoreStartupTime)) / 1000;' || chr(10) || '}' || chr(10) || 'if (typeof coreStatus.CoreReloadDate !== ''undefined'') {' || chr(10) || ' asterisk.uptime_reload = (Date.now() - Date.parse(coreStatus.CoreReloadDate + " " + coreStatus.CoreReloadTime)) / 1000;' || chr(10) || '}' || chr(10) || '' || chr(10) || 'response = Ami.request(url, ''command&command=core%20show%20channels'');' || chr(10) || 'channels = response.body;' || chr(10) || 'var fields = {' || chr(10) || ' active_channels: ''active channels?'',' || chr(10) || ' active_calls: ''active calls?'',' || chr(10) || ' calls_processed: ''calls? processed''' || chr(10) || '};' || chr(10) || '' || chr(10) || 'Object.keys(fields).forEach(function (field) {' || chr(10) || ' var match = channels.match(''(\\d+) '' + fields[field]);' || chr(10) || ' if (match !== null && typeof match[1] !== ''undefined'') {' || chr(10) || ' asterisk[field] = parseInt(match[1]);' || chr(10) || ' }' || chr(10) || '});' || chr(10) || '' || chr(10) || 'response = Ami.request(url, ''ListCommands'');' || chr(10) || 'var list = response.body;' || chr(10) || 'if (list.includes(''SIPpeers'')) {' || chr(10) || ' getSipPeers();' || chr(10) || '}' || chr(10) || 'if (list.includes(''IAXpeerlist'')) {' || chr(10) || ' getIaxPeerList();' || chr(10) || '}' || chr(10) || 'if (list.includes(''PJSIPShowEndpoints'')) {' || chr(10) || ' getPjsipShowEndpoints();' || chr(10) || '}' || chr(10) || 'if (list.includes(''QueueSummary'')) {' || chr(10) || ' getQueueSummary();' || chr(10) || '}' || chr(10) || '' || chr(10) || 'try {' || chr(10) || ' response = Ami.request(url, ''Logoff'');' || chr(10) || '}' || chr(10) || 'catch (e) {}' || chr(10) || '' || chr(10) || 'return JSON.stringify(asterisk);' || chr(10) || ''),'0','') Error report - ORA-12899: value too large for column "ZABBIX2"."ITEM_PREPROC"."PARAMS" (actual: 7932, maximum: 2048) Error starting at line : 144,146 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65266','32590','1','12','$[?(@.TABLESPACE==''{#TABLESPACE}'')].USED_BYTES.first()','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found Error starting at line : 144,150 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65267','32591','1','12','$[?(@.TABLESPACE==''{#TABLESPACE}'')].USED_FILE_PCT.first()','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found Error starting at line : 144,650 in command - INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65393','28415','1','20','6h','0','') Error report - ORA-02291: integrity constraint (ZABBIX2.C_ITEM_PREPROC_1) violated - parent key not found