1.6.8 & oracle inconsistent datatypes
Recently imported MySQL database to Oracle. When trying to start the server I am getting this:
7010:20091216:101758 [Z3005] Query failed: [0] ORA-00932: inconsistent datatypes: expected - got BLOB
[select distinct t.triggerid,t.expression,t.description,t.status,t. priority,t.value,t.url,t.comments from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1260976678 and i.key_<>'status' and h.status not in (4,3) and i.type not in (2)]
Also, the fronend is showing:
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01407: cannot update ("ZABBIX"."PROFILES"."SOURCE") to NULL[/var/www/html/zabbix/include/db.inc.php:478]
* SQL error [ORA-01407: cannot update ("ZABBIX"."PROFILES"."SOURCE") to NULL] in [UPDATE profiles SET value_id=0, value_int=0, value_str='dashboard.php', type=3, source='' WHERE userid=1 AND idx='web.menu.view.last']
Simple question. What do I need to do to fix it.
RHEL5
Zab 1.6.8
7010:20091216:101758 [Z3005] Query failed: [0] ORA-00932: inconsistent datatypes: expected - got BLOB
[select distinct t.triggerid,t.expression,t.description,t.status,t. priority,t.value,t.url,t.comments from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1260976678 and i.key_<>'status' and h.status not in (4,3) and i.type not in (2)]
Also, the fronend is showing:
* ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01407: cannot update ("ZABBIX"."PROFILES"."SOURCE") to NULL[/var/www/html/zabbix/include/db.inc.php:478]
* SQL error [ORA-01407: cannot update ("ZABBIX"."PROFILES"."SOURCE") to NULL] in [UPDATE profiles SET value_id=0, value_int=0, value_str='dashboard.php', type=3, source='' WHERE userid=1 AND idx='web.menu.view.last']
Simple question. What do I need to do to fix it.
RHEL5
Zab 1.6.8
Comment