Error ORA-01795
Hi,
We have this error while trying to access 'Configuration/Graphs':
# ociexecute(): OCIStmtExecute: ORA-01795: maximum number of expressions in a list is 1000 [/srv/www/htdocs/zabbix-1.5.3/include/db.inc.php:458]
# SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT DISTINCT g.* FROM graphs g, graphs_items gi,items i WHERE g.graphid IN (78,91,83,22,25,30,34,<... MORE THAN 1K IDs HERE... >,3018,3015,3186,3029,3419,3242,3252,3483,3486) AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND i.hostid=10280 ORDER BY g.name ASC,g.graphid]
Oracle foruns talk about a limit (1000 statements) in a where clause. Some workaround ?
We have this error while trying to access 'Configuration/Graphs':
# ociexecute(): OCIStmtExecute: ORA-01795: maximum number of expressions in a list is 1000 [/srv/www/htdocs/zabbix-1.5.3/include/db.inc.php:458]
# SQL error [ORA-01795: maximum number of expressions in a list is 1000 ] in [SELECT DISTINCT g.* FROM graphs g, graphs_items gi,items i WHERE g.graphid IN (78,91,83,22,25,30,34,<... MORE THAN 1K IDs HERE... >,3018,3015,3186,3029,3419,3242,3252,3483,3486) AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND i.hostid=10280 ORDER BY g.name ASC,g.graphid]
Oracle foruns talk about a limit (1000 statements) in a where clause. Some workaround ?
Comment