Login Register Actian.com  

Actian Community Forum



Reply
 
LinkBack Thread Tools Display Modes
Old 2012-02-08   #1 (permalink)
Ingres Community
 
Join Date: Sep 2010
Location: Germany
Posts: 57
Default Disabling OpenROAD Logfile

Hello,

it seems that sometimes our OpenROAD Programs can't open the w4gl.log-File - maybe because there is some read/write or write/write conflict ?
Everytime this happens - the program raises a MessageBox with the text 'Unable to Open the w4gl.log File'.

The bad thing here, is that this kind of processes have been started from a service - and so they got no visible Windows. No visible Windows means that no one can push the 'Ok' Button !

Iv'e tried to disable the Logfile simply by not setting the ingprenv 'II_LOG' and starting the Image with '-Tno' - but, as you can see in the attached picture, OpenROAD keeps on reading (and writing) to a trace file called 'w4gl.log' with resides in %II_SYSTEM%/ingres/files.

If there is happen something not good, I think the Error-Messagebox is displayed. I can't reproduce it, because this only seem to happen if many background-processes start at the same time.

Anyone has got any solutions for this problem ?

Thanks a lot !

Thomas
Attached Images
File Type: jpg w4gl_log.jpg (90.4 KB, 8 views)
Thomas_cim is offline   Reply With Quote
Old 2012-02-08   #2 (permalink)
Ingres Corp
 
Join Date: Mar 2007
Location: On the OpenROAD
Posts: 1,306
Default

I think there are some misunderstandings here.
If you start with "-Tno", then NO w4gl.log file is created.
If this is not the case, then this would be a bug.
In other cases (-T flag not set or in combination with "yes" or "all" options) the log file gets created in the directory %II_SYSTEM%\ingres\files by default (if II_LOG is not set), setting II_LOG redirects it to another directory.
Are you having multiple users using the same installation on a network drive (what's your II_SYSTEM)?
The "read/write" conflicts seem to point into that direction.
If that is the case you should make sure that at least II_LOG and II_TEMPORARY point to a local, user-specific directory.
You can also use a -L flag to specify the name of the logfile (e.g. containing the username and current date/time), so a conflict because of several processes trying to access the same file shouldn't happen.
Bodo is offline   Reply With Quote
Old 2012-02-08   #3 (permalink)
Ingres Community
 
Join Date: Sep 2010
Location: Germany
Posts: 57
Default

Hello Bodo,

I am very sure that I've started w4glrun with -Tno - but I will doublecheckit !

And you're right: We use the same installation for many user by using UNC-paths...

Thanks for your fast reply - hopefully we can find the failure or bug (I tend to think it's a bug, because I'm sure I've typed '-Tno' AND 'ingunsetenv II_LOG'...)

Greetings,

Thomas
Thomas_cim is offline   Reply With Quote
Old 2012-02-08   #4 (permalink)
Ingres Corp
 
Join Date: Mar 2007
Location: On the OpenROAD
Posts: 1,306
Default

I just tested and it seems that there is in fact a bug - an empty w4gl.log file gets created even if "-Tno" is specified.
But there is workaround: Additionally specify the "-L" flag and point it to the NUL device, e.g.:
w4glrun my.img -Tno -LNUL

Anyway, you should open a ServiceDesk issue in order to get a fix for the bug.
Bodo is offline   Reply With Quote
Old 2012-02-09   #5 (permalink)
Ingres Community
 
Join Date: Mar 2009
Location: UK
Posts: 129
Default

Hi,

On a simliar note;

I've seen that 'unable to open w4gl.log file' before on machines that are shared between users. (Different login credentials - just shared PCs)

We used the cacls command to change the access control list on the w4gl.log file to allow the everyone group to read and write to it.

Regards,

Adrian
Adrian Williamson is offline   Reply With Quote

Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


© 2011 Actian Corporation. All Rights Reserved