Forum OpenACS Q&A: ora_tcl errors

Collapse
1: ora_tcl errors
Posted by Michael Olan on 09/12/02 10:49 PM
I just installed OpenACS 4.5, and although it seems to be running ok, there are error messages being posted to the log every couple minutes: 
[-sched-] Error: ora8.c:3930:ora_tcl_command: error in 
`OCIStmtExecute ()': ORA-00936: missing expression
I don't know what the problem is.
Collapse
2: Response to ora_tcl errors (response to 1)
Posted by Jeff Davis on 09/12/02 11:06 PM
I think we need more context to figure out what is wrong.
It looks like a bad query in a scheduled procedure but there is
no way to tell which one from the information you have given.

You could also run
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/aolserver/nstelemetry/
to tell you which procs are scheduled and when they last ran.

Collapse
3: Response to ora_tcl errors (response to 1)
Posted by defunct defunct on 09/13/02 10:43 AM
Hmm... not the query dispatcher agian is it?

I've found that if you mistakenly put the query in the wrong file, or name it wrong, or don;t use the right naming convention, it tends to fail semi-silently.... i.e. it reports the failure of an empty query.

Might be worth checking your .xql files and ensuring you've got everything right.....

Or did you mean it does this before you've added any custom code?

Collapse
4: Response to ora_tcl errors (response to 1)
Posted by Michael Olan on 09/13/02 05:23 PM
This was on a fresh install. No custom code of any kind. After letting it run overnight, there are now also the following errors: 
 ORA-04045: errors during recompilation/revalidation of OPENACS./11caeda5_MessageParser
I did try (later) to create a bboard forum, which failed with many sql errors. Perhaps since this is a new install I may as well just start over?
Collapse
5: Response to ora_tcl errors (response to 1)
Posted by defunct defunct on 09/13/02 05:26 PM
Yes, might be best... I've got a stock 4.5 installation here and I'm not seeing anything like this....

Although the one running is a PG version, so this may be a red herring