Forum OpenACS Q&A: search

I'm having trouble with the search pacakge after Yon ported it to Oracle.

Specifically, the search_observer_dequeue_entry query called from inside search_indexer doesn't get picked up by the query dispatcher, and hence it tries to execute the empty string.

[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = 
calling namespace = 
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = 
proc_name is -search_indexer-
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = tcl 
file is packages/search/tcl/search-procs.tcl
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = 
TEMP - QD: proc_name is search_indexer
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = 
TEMP - QD: local_name is search_observer_dequeue_entry
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = 
generated fullname of dbqd.search.tcl.search-
procs.search_indexer.search_observer_dequeue_entry
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = NO 
FULLQUERY FOR dbqd.search.tcl.search-
procs.search_indexer.search_observer_dequeue_entry --> using default 
SQL
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = 
PLPGSQL: using anonymous function
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = PRE-
QD: the SQL is 
[01/Aug/2002:10:41:05][27966.94218][-conn1-] Debug: QD_LOGGER = NO 
FULLQUERY FOR dbqd.search.tcl.search-
procs.search_indexer.search_observer_dequeue_entry --> using default 
SQL

I've tried to see if I can figure out what goes wrong, but I find it very hard to troubleshoot and debug when the query dispatcher fails.

Anybody else have any ideas?

Forum OpenACS Q&A: search_indexer error