Error in Denial History report in 2009.08

  • nwallace
Posted: Wed, 09/16/2009 - 15:51

I get the following error when trying to run a Denial History report. I have upgraded to 2009.08 and have applied the update. I restarted LM after installing the patch and saw the message about having added the account_id column. My first inclination is to manually add the column per the patch readme, but I thought I should ask before hosing my DB.

Attention!! The program generated some stderr

vovsh ERROR Sep 16 15:47:00 Evaluating line 1 of /usr/apps/rtda/2009.08/common/etc/cgi/lmwidgets.cgi:
Cannot run sqlite3:
SQL error near line 3: no such column: account_id
child process exited abnormally
/usr/apps/rtda/2009.08/linux/bin/sqlite3
LD_LIBRARY_PATH=.......:/usr/apps/rtda/2009.08/linux/lib
db=/usr/apps/rtda/licmon/licmon.swd/sq3/licmon.sq3
cmdfile=/usr/tmp/vovsq3query_cdsmgr_9441.cmd
at line 1
Cannot run sqlite3:
SQL error near line 3: no such column: account_id
child process exited abnormally
/usr/apps/rtda/2009.08/linux/bin/sqlite3
LD_LIBRARY_PATH=...........:/usr/apps/rtda/2009.08/linux/lib
db=/usr/apps/rtda/licmon/licmon.swd/sq3/licmon.sq3
cmdfile=/usr/tmp/vovsq3query_cdsmgr_9441.cmd
while executing
"error "Cannot run sqlite3: $msg""
invoked from within
"if [catch { set result [exec sqlite3 $db < $tmpCmdFile] } errmsg] {
global env
set msg ""
append msg "\n\t$errmsg"
if..."
(procedure "vtk_sql_query_SQLite" line 66)
invoked from within
"vtk_sql_query_SQLite $index $query $htmlformat"
("SQLite" arm line 1)
invoked from within
"switch -- $vendor {
"ORACLE" { return [vtk_sql_query_ORACLE $index $query $htmlformat $useterminator]}
"MYSQL" { return [vtk_sql_quer..."
(procedure "vtk_sql_query" line 17)
invoked from within
"vtk_sql_query $handle $query"
(procedure "vtk_sql_loop" line 24)
invoked from within
"vtk_sql_loop $DBHANDLE $query { id userId hostId accountId ts } {
set name [getNameFromId $DBHANDLE $reportByTableName $id]
set user [..."
(procedure "VovLM::getDenialDetails" line 127)
invoked from within
"VovLM::getDenialDetails -output html -title $title -ldapenabled 0 -feature Assura_UI -limit 100 -reportby feature -url table /cgi/ftlm.cgi?origin=samp..."
("eval" body line 1)
invoked from within
"eval VovLM::getDenialDetails -output html -title { $title } -ldapenabled $ldapenabled $filterSpec -limit $max -reportby $reportby -url table /cgi/f..."
invoked from within
"if $WIDGET_ALONE {
eval VovLM::getDenialDetails -output html -title { $title } -ldapenabled $ldapenabled $filterSpec -limit $max -reportby $reportby
..."
(procedure "LMwidget::genDenialDetails" line 76)
invoked from within
"LMwidget::genDenialDetails "
("denialdetails" arm line 1)
invoked from within
"switch -- [string tolower $opt(widget)] {
"ckoutstats" { LMwidget::genCheckoutStats }
"ckoutdetails" { LMwidget::genCheckoutDetails ..."
(file "/usr/apps/rtda/2009.08/common/etc/cgi/lmwidgets.cgi" line 87)
invoked from within
"source /usr/apps/rtda/2009.08/common/etc/cgi/lmwidgets.cgi"
("uplevel" body line 1)
invoked from within
"uplevel #0 source /usr/apps/rtda/2009.08/common/etc/cgi/lmwidgets.cgi"
vovsh ERROR Sep 16 15:47:00 Parsing /usr/apps/rtda/2009.08/common/etc/cgi/lmwidgets.cgi

Thanks,

Nathan

That worked... Thanks!

  • nwallace
  • 06/15/09
  • Thu, 09/17/2009 - 10:31

That worked... Thanks!

Very odd to see the message

  • btjanes
  • 05/08/09
  • Wed, 09/16/2009 - 17:19

Very odd to see the message without the column being created. Please run:

% vovproject enable licmon
% vovsql_create_tables_licmon

manually and let us know if that takes care of it.