[Openroad-users] Error E_DO0073 - Intermediate storage file couldnot be opened.
Brian Risley
brisleyor at embarqmail.com
Wed Aug 29 12:23:48 EST 2007
Paul,
The user we created for the remote access on the other server had some
of our key domain group rights to do some things, so we specifically
denied them access to the C drives on the local computers, as they had
setup some public shares or shares using thegroups we gave the remote
user access to on their local drives for internal work between systems.
We simply went into the security property on the local C drive, and
added the remote user account from the domain, then selected the deny
all rights checkbox, which automatically marked the other deny boxes.
This effectively shut them out of the local machines without changing
any of the shares.
It also apparently killed the ability for OR to run on any account it
ran on before, including local machine admin.
If MS does something when you deny any user, OR should be aware of this
and still run if the user running OR and any user starting the Ingres
processes has proper rights. This is something that any of our clients
could do and we would never know about it, except for them telling us
that OR won't run.
At least it should be in the knowledge base at this point that this
situation can shut down OR.
This situation needs to be checked in OR2006 and 4.1sp4 and if present,
resolved. We spent 1 whole day trying to resolve this. It wasn't until
we started checking every machine that we discovered a pattern. Filemon
and Performance monitor did not indicate a specific problem. We
directly compared 2 different machines, 1 working, 1 not, and we could
see when things started to vary, but as far as we could tell there was
no access failure that caused this.
If it is some weird MS bug that OR can't deal with, then MS needs to fix
it. This is a security issue.
Not complaining, this was weird and Ingres folk may never have seen it.
If they can dup it, then please get it in the support knowledge base as
an issue with denied access rights. Better to have someone else run
into it and find an answer in 5 minutes then have them spend a lot of
time on it, or spend Ingres time on figuring it out.
Thanks to all who had ideas on things to check. We tried all of them!
Brian
Paul White wrote:
>Hi Brian,
>
>I've experienced problems in the past with inherited directory permissions that even my MS gurus couldnt explain.
>
>Can you be a bit more specific about how you set up the access permissions. It sounds as if you have denied all access to the local C drive for that user, however you said the user can access and write to the C: drive.
>
>
>
>
>
>
>________________________________
>
> From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Brian Risley
> Sent: Wednesday, 29 August 2007 4:14 AM
> To: International OpenROAD Users
> Subject: Re: [Openroad-users] Error E_DO0073 - Intermediate storage file couldnot be opened.
>
>
> Ok, figured it out.
> Ingres folk, you need to explain why this happens.
>
> We added a new domain user coming in to our Citrix machine to do some review work where they needed some privlidges on our network, but we didn't want them to have access to the local user machines which had numerous public shares, so we went into the permissions on the C drive, added the domain user, and denied them access (Full control and all the others auto checked) and then applied it.
>
> I just tried this on one of the working machines, and it stopped working, removed the user from the C permissions, and I was allowed back in.
> No other user was changed, the local user Everyone had full access, and only the new domain account was denied, but this shut OR down!
>
> Brian
>
>
> Brian Risley wrote:
>
>
> That's next.
> Nothing we can find in any security or other permission is a problem. We looked at filemon and the 'errors', problem is things are looked for in multiple directories, and it is a failure until a success is met. Reporting just the failures doesn't work.
>
> Brian
>
>
> Brigitte Duplenne wrote:
>
>
>
> Hi Brian,
>
> As Joe suggested you should open a Service Desk issue so a technician could
> connect on your machine.
>
> You may also try to run "File Monitor" available from Microsoft web site and
> filter 'w4gldev.exe' or 'w4glrun.exe' and search for different errors in
> the Result column.
>
> Brigitte
>
>
>
> _____
> From: openroad-users-bounces at peerlessit.com
> [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Brian Risley
> Sent: mardi 28 août 2007 10:00
> To: International OpenROAD Users
> Subject: Re: [Openroad-users] Error E_DO0073 - Intermediate storage file
> couldnot be opened.
>
>
> Bodo,
> Have tried it with and without a machine level environment variable, no go.
> No space in path.
>
> We have tried other machines in house, we have seen this on 2 others that
> were not actively used. Our other machines, including 2 I use, have no
> problem. All the latest patches from MS and Symantec AV are loaded.
> Brian
>
>
> Bodo Bergmann wrote:
>
>
> Some random thoughts:
>
>
>
> Have you checked the user's environment variables for another
>
> II_TEMPORARY setting
>
> (use "set" on a command prompt) ?
>
> This would take precedence over the "ingsetenv" setting.
>
>
>
> Where does II_TEMPORARY point to - a path containing a space?
>
>
>
> Bodo.
>
>
>
> Bodo Bergmann
>
> Senior Software Engineer
>
> OpenROAD Worldwide Development
>
> Ingres Corp.
>
>
>
>
>
>
>
> ________________________________
>
>
>
> From: openroad-users-bounces at peerlessit.com
>
> [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Brian Risley
>
> Sent: Tuesday, August 28, 2007 5:32 PM
>
> To: Russell Neal
>
> Cc: International OpenROAD Users
>
> Subject: Re: [Openroad-users] Error E_DO0073 - Intermediate storage file
>
> couldnot be opened.
>
>
>
>
>
> Russell,
>
> Checked ingprenv
>
> II_TEMPORARY is present and the directory can be written to. (We even
>
> tried the old symbol.tbl file from before the reload as well as the one
>
> created during the reload, no dice.)
>
>
>
> We see a file being created by the name management utility in the
>
> directory, so permissions shouldn;t be an issue.
>
> We don't see anything in the errlog.log to indicate there is a problem.
>
>
>
> I've been going bald, but this one has definitely accelerated the
>
> process!
>
>
>
> Brian
>
>
>
>
>
> Russell Neal wrote:
>
>
>
>
>
> Hi Brian,
>
> The Ingres System Administrator's Guide says
>
>
>
> "II_TEMPORARY Specifies the directory where temporary files used
>
> by the
>
> Ingres/Tools are
>
> created. By default, these files are created in the user's
>
> current
>
> directory. "
>
>
>
> I'm not sure what that equates to in Windows - perhaps the
>
> "start in"
>
> directory in the properties of the Ingres program you are
>
> running- e.g.
>
> on my PC the OpenROAD Workbench starts in
>
> %II_SYSTEM%\ingres\bin.
>
>
>
> And I did not get quite the same results as Graham Jakins, I
>
> found that
>
> if ran "ingunset II_TEMPORARY", then Ingres and OpenROAD started
>
> fine,
>
> but if I set II_TEMPORARY to an invalid directory, then Ingres
>
> started
>
> but OpenROAD gave the E_DO0073 error.
>
>
>
> Let me know what you find tomorrow. I am in Australia, so don't
>
> expect
>
> an answer until late in your day.
>
> Cheers
>
> Russell
>
>
>
> -----Original Message-----
>
> From: Brian Risley [mailto:brisleyor at embarqmail.com]
> Sent: Tuesday, 28 August 2007 12:46 PM
>
> To: International OpenROAD Users; Russell Neal
>
> Subject: Re: [Openroad-users] Error E_DO0073 - Intermediate
>
> storage file
>
> couldnot be opened.
>
>
>
> Russell,
>
> I checked, at first it did not have an II_TEMPORARY variable.
>
> It would
>
> not load.
>
> I checked my machine's variables and saw one, so I set one on
>
> his and
>
> made sure he had the directory. Still no luck.
>
> Machine is at the office, so I will have to work more with it in
>
> the
>
> morning.
>
> Didn't look at errlog.log, but did check w4gl.log, but it only
>
> had what
>
> I saw in the trace window.
>
> If II_temporary is not set, what directory is it using?
>
> I patched up through 11526.
>
> Brian
>
>
>
>
>
> Russell Neal wrote:
>
>
>
>
>
>
> Hi Brian,
>
> I had a quick look in our catalogue of old bugs and
>
> found the
>
>
>
>
> following:
>
>
>
>
> Bug 104897
>
> Get the following error when II_TEMPORARY is set to an
>
> invalid value,
>
> "E_DO0073 An intermediate storage file could not be
>
> opened in the
> temporary file area. Make sure the temporary file area
>
> exists, has
> room, and is available to you."
>
> There are no patches for this bug, but a workaround is
>
> listed:
>
> Set II_TEMPORARY to a valid value or unset II_TEMPORARY
>
> altogether.
>
>
> Let me know if this fixes the problem, and I will put an
>
> entry in the
> Ingres Service Desk Knowledge Base for it.
>
>
>
> Thanks and regards
>
> Russell Neal
>
> Technical Consultant
>
> Ingres Corporation
>
> russell.neal at ingres.com
>
> Phone: +1 (650) 587 5557
>
>
>
> -----Original Message-----
>
> From: openroad-users-bounces at peerlessit.com
>
> [mailto:openroad-users-bounces at peerlessit.com] On Behalf
>
> Of Brian
> Risley
>
> Sent: Tuesday, 28 August 2007 11:07 AM
>
> To: openroad-users at peerlessit.com
>
> Subject: [Openroad-users] Error E_DO0073 - Intermediate
>
> storage file
> couldnot be opened.
>
>
>
> I have one of our developers suddenly start getting this
>
> message. He
> has full permission to his local drive via his domain
>
> account. Drive
> is not full.
>
> I have uninstalled and re-installed OR, still no joy.
>
> Any ideas what directory this is having fits about?
>
> Be nice if the error message gave the path it had
>
> problems with!
>
> His windows Temp environment variables seem ok.
>
> He did not have an II_temporary, but I created one to
> c:\Ingresii\ingres\temp and tried again. No luck.
>
> Ingres Net is running fine as far as I can tell,
>
> IIGCC/GCN are up.
>
> Netutil works fine. CBF works fine.
>
>
>
> I can write files to C:\ C:|winnt c:\winntsystem32
>
> C:\ingresii\ingres
>
>
>
>
>
>
>
>
>
> and its subdirectories. It builds the w4gl.log file.
>
> C: has 236gb free.
>
>
>
> Text of message is: An intermediate storage file area
>
> could not be
> opened in the temporary file area.
>
> Make sure the temporary file area exists, has room, and
>
> is available to
>
>
>
>
>
>
>
>
>
> you.
>
> Searched for the error message/text on support knowledge
>
> base.
>
>
>
> Thanks for any ideas.
>
> Brian Risley
>
>
>
>
>
> ________________________________________________________________
>
> OpenROAD-Users mailing list
>
>
>
> You can maintain your subscription here:
>
>
>
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>
>
> To unsubscribe click on this link
>
>
>
> mailto:openroad-users-unsubscribe at peerlessit.com
> <mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe> <mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe>
> &subject=unsubscribe
>
>
>
> To subscribe click on this link
>
>
>
> mailto:openroad-users-subscribe at peerlessit.com
> <mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe> <mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe>
> &subject=subscribe
>
>
>
>
>
> ________________________________________________________________
>
> OpenROAD-Users mailing list
>
>
>
> You can maintain your subscription here:
>
>
>
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>
>
> To unsubscribe click on this link
>
>
>
> mailto:openroad-users-unsubscribe at peerlessit.com
> <mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe> <mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe>
> &subject=unsubscribe
>
>
>
> To subscribe click on this link
>
>
>
> mailto:openroad-users-subscribe at peerlessit.com
> <mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe> <mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe>
> &subject=subscribe
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _____
>
> ________________________________________________________________
>
> OpenROAD-Users mailing list
>
>
>
> You can maintain your subscription here:
>
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>
>
> To unsubscribe click on this link
>
> mailto:openroad-users-unsubscribe at peerlessit.com
> <mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe> <mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe>
> &subject=unsubscribe
>
>
>
> To subscribe click on this link
>
> mailto:openroad-users-subscribe at peerlessit.com
> <mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe> <mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe>
> &subject=subscribe
>
>
>
> ------------------------------------------------------------------------
>
> ________________________________________________________________
> OpenROAD-Users mailing list
>
> You can maintain your subscription here:
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
> To unsubscribe click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
> To subscribe click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
>
>
>
>________________________________
>
>
> ________________________________________________________________
> OpenROAD-Users mailing list
>
> You can maintain your subscription here:
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
> To unsubscribe click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
> To subscribe click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
>
>
>
>------------------------------------------------------------------------
>
>________________________________________________________________
>OpenROAD-Users mailing list
>
>You can maintain your subscription here:
>http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>To unsubscribe click on this link
>mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
>To subscribe click on this link
>mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20070828/a597a09c/attachment.html
More information about the Openroad-users
mailing list