[zabbix 1.6] ERROR: Cannot delete host with Oracle DB

[luissma]

Found following error when trying to delete a host (Oracle). Same problem as for postgresql (http://www.zabbix.com/forum/showthread.php?p=37242):

ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: OCIStmtExecute: ORA-01722: invalid number [/var/www/html/zabbix/include/db.inc.php:474]
SQL error [ORA-01722: invalid number ] in [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=2 AND (value IN (13383,13399,13385,13425,13400,13397,13384,13389,1 3388,13387,13398,13386,13395,13407,13408,13409,133 96,13394,13393,13401,13421,13392,13420,13390,13424 ,13417,13416,13414,13415,13413,13411,13412,13426,1 3391,13404,13402,13405,13410,13406,13423,13403,134 18,13419,13422)) ]
Undefined variable: stid[/var/www/html/zabbix/include/db.inc.php:401]
SQL error [] in []
ocifetchinto(): supplied argument is not a valid OCI8-Statement resource[/var/www/html/zabbix/include/db.inc.php:523]
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: OCIStmtExecute: ORA-01722: invalid number [/var/www/html/zabbix/include/db.inc.php:474]
SQL error [ORA-01722: invalid number ] in [DELETE FROM conditions WHERE conditiontype=2 AND (value IN (13383,13399,13385,13425,13400,13397,13384,13389,1 3388,13387,13398,13386,13395,13407,13408,13409,133 96,13394,13393,13401,13421,13392,13420,13390,13424 ,13417,13416,13414,13415,13413,13411,13412,13426,1 3391,13404,13402,13405,13410,13406,13423,13403,134 18,13419,13422)) ]

[.....]

ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: OCIStmtExecute: ORA-01722: invalid number [/var/www/html/zabbix/include/db.inc.php:474]
SQL error [ORA-01722: invalid number ] in [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=1 AND (value IN (10051)) ]
Undefined variable: stid[/var/www/html/zabbix/include/db.inc.php:401]
SQL error [] in []
ocifetchinto(): supplied argument is not a valid OCI8-Statement resource[/var/www/html/zabbix/include/db.inc.php:523]
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: OCIStmtExecute: ORA-01722: invalid number [/var/www/html/zabbix/include/db.inc.php:474]
SQL error [ORA-01722: invalid number ] in [DELETE FROM conditions WHERE conditiontype=1 AND (value IN (10051)) ]

[Aly]

You can try frontend from a Nightly build: http://www.zabbix.com/developers.php

It contains many fixes.

[luissma]

Ok ,tried the nightly build but found a similar problem...


ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: OCIStmtExecute: ORA-01722: invalid number [/var/www/html/zabbix/include/db.inc.php:476]
SQL error [ORA-01722: invalid number ] in [SELECT DISTINCT actionid FROM conditions WHERE conditiontype=2 AND ( CAST(value AS NUMBER(20)) IN (13383,13399,13385,13425,13400,13397,13384,13389,1 3388,13387,13398,13386,13395,13407,13408,13409,133 96,13394,13393,13401,13421,13392,13420,13390,13424 ,13417,13416,13414,13415,13413,13411,13412,13426,1 3391,13404,13402,13405,13410,13406,13423,13403,134 18,13419,13422)) ]
Undefined variable: stid[/var/www/html/zabbix/include/db.inc.php:403]
SQL error [] in []
ocifetchinto(): supplied argument is not a valid OCI8-Statement resource[/var/www/html/zabbix/include/db.inc.php:525]
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: OCIStmtExecute: ORA-01722: invalid number [/var/www/html/zabbix/include/db.inc.php:476]
SQL error [ORA-01722: invalid number ] in [DELETE FROM conditions WHERE conditiontype=2 AND ( CAST(value AS NUMBER(20)) IN (13383,13399,13385,13425,13400,13397,13384,13389,1 3388,13387,13398,13386,13395,13407,13408,13409,133 96,13394,13393,13401,13421,13392,13420,13390,13424 ,13417,13416,13414,13415,13413,13411,13412,13426,1 3391,13404,13402,13405,13410,13406,13423,13403,134 18,13419,13422)) ]

[gsaini]

[zabbix 1.6.1] ERROR: Cannot delete host with Oracle DB

Hi,

I have configured Zabbix 1.6.1 with Oracle 9i on Solaris 10. I am trying to delete host but I am getting following error in Web interface.

ERROR: Cannot delete host

I am not sure but looks like I am getting following message in the log file when I try to remove the host.

13400:20090105:214620 Type of received value [NaN] is not sutable for [vfs.fs.size[/home,pfree]@ZABBIX Server] having type [0]
13400:20090105:214620 Returning NOTSUPPORTED
13403:20090105:214627 Type of received value [NaN] is not sutable for [vfs.fs.inode[/home,pfree]@ZABBIX Server] having type [0]
13403:20090105:214627 Returning NOTSUPPORTED

Is this some security feature or am doing something wrong.

Thanks
Gurdeep.