[Info-Ingres] "Query Detail Object Failed" in Vdba

[Bernard Casgrain]

Hi, Gurus.

I got a problem with Vdba. In the Performance Monitor, when I try to see the log system header (or the Log File itself), I got the message "Query Detail Object Failed". And no value is shown.

With printqry, I found that Vdba uses the table ima_lgmo_lgd in imadb to get the data. 

Usually a select from this table returns 1 row. In my production installation, this select returns no row. Why?

What is wrong with my installation?

Then I played with the table ima_lgmo_lgd definition. I found that there is a specific column, lgd_stat_wait, that causes the problem. Here is the definition found in makeiman.sql
         lgd_stat_wait     i4 not null not default is 'exp.dmf.lg.lgd_stat.wait'

I registered a table with the same column definition and select returned no row. Any other column from ima_lgmo_lgd returned a single row as expected.

What is wrong with lgd_stat_wait?

Someone can help, please?

Version: Ingres II 9.1.0 (int.w32/119) on Window server 2003 R2 SP2
___________________________
Bernard Casgrain
Computer Analyst
Projet BALSAC
Université du Québec à Chicoutimi
http://www.uqac.uquebec.ca/balsac/
bernard_casgrain at uqac.ca
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
NOTICE: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately by email and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20071102/9d5cf0ae/attachment.html