Forum OpenACS Q&A: ds_collect_db_call Warning in log

Collapse
1: ds_collect_db_call Warning in log
Posted by Nima Mazloumi on 03/08/04 02:38 PM
Hi,

I get the following warning and have no idea why this happens. Any idea?

My installation:
Postgres 7.3.4
dotLRN 2.0.1 (Migrated from rc1 using Upgrade sql)
SuSE Linux 9.0

Greetings,
Nima

[08/Mar/2004:14:30:19][4501.311316][-conn16-] Warning: ds_collect_db_call: can't read "SS": no such variable
[08/Mar/2004:14:30:20][4501.802866][-conn46-] Warning: ds_collect_db_call: can't read "SS": no such variable
[08/Mar/2004:14:30:21][4501.802866][-conn46-] Warning: ds_collect_db_call: can't read "00": no such variable
[08/Mar/2004:14:30:21][4501.802866][-conn46-] Warning: ds_collect_db_call: can't read "00": no such variable
[08/Mar/2004:14:30:21][4501.802866][-conn46-] Warning: ds_collect_db_call: can't read "MI": no such variable
[08/Mar/2004:14:30:21][4501.802866][-conn46-] Warning: ds_collect_db_call: can't read "SS": no such variable
[08/Mar/2004:14:30:21][4501.802866][-conn46-] Warning: ds_collect_db_call: can't read "SS": no such variable

Collapse
2: Re: ds_collect_db_call Warning in log (response to 1)
Posted by Jeff Davis on 03/08/04 03:01 PM
ds_collect_db_call tries to fill in bind variable values and somewhere there is a sql statement which has :SS in it and SS is undefined (I think it's a time format string, not sure where though).
Collapse
3: Re: ds_collect_db_call Warning in log (response to 1)
Posted by Don Baccus on 03/08/04 10:49 PM
Nima, the file's in acs-developer-support/tcl/acs-developer-support-procs.tcl, and the logging of the error message is easy to find - you might add the SQL that triggers an error to the error message, that will help us figure out the problem.

This won't cause a problem on a production system, though, you should normally have developer support disabled on a production system.

Collapse
4: Re: ds_collect_db_call Warning in log (response to 1)
Posted by Nima Mazloumi on 03/09/04 09:05 AM
Thank you both for your help.