[Openroad-users] Error E_DO0073 - Intermediate storage file could not be opened.

587 views
Skip to first unread message

Brian Risley

unread,
Aug 27, 2007, 9:07:07 PM8/27/07
to openroa...@peerlessit.com
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-user...@peerlessit.com&subject=unsubscribe

To subscribe click on this link
mailto:openroad-use...@peerlessit.com&subject=subscribe

Russell Neal

unread,
Aug 27, 2007, 10:30:56 PM8/27/07
to International OpenROAD Users
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
russel...@ingres.com
Phone: +1 (650) 587 5557

Brian Risley

unread,
Aug 27, 2007, 10:31:05 PM8/27/07
to Brigitte Duplenne, openroa...@peerlessit.com
Brigitte,
This occurs before I have even selected a database. I can't get the
workbench to open even far enough to setup a connection.
Not a database issue, I connected to the server fine from my workstation.
I checked Netutil, it connects to itself fine and to the main server fine.
I have seen things like this with 3.5 when new XPsp2 machines were
loaded and the users didn't have permissions to the windows system
directories, but I haven't run into it with 4.x before. No major
changes to the system this is happening to, it was working fine last week.
Only thing done was that a POS SDK was loaded for .Net.

Brian


Brigitte Duplenne wrote:

>
>Hi Brian,
>
>Have you checked if you have error in the errlog.log?
>This could be a problem on the server not on the client.
>Can you access to that OR database from other OpenROAD installations?
>
>Brigitte


>
>-----Original Message-----
>From: openroad-us...@peerlessit.com
>[mailto:openroad-us...@peerlessit.com] On Behalf Of Brian Risley
>Sent: lundi 27 août 2007 18:07
>To: openroa...@peerlessit.com
>Subject: [Openroad-users] Error E_DO0073 - Intermediate storage file
>couldnot be opened.
>

Graham Jakins

unread,
Aug 27, 2007, 10:55:32 PM8/27/07
to International OpenROAD Users
Hi,

The Workbench start up will still give this error if II_TEMPORARY is not set to a correct location without having a database opened.

I have tried it here and if II_TEMPORARY is not set or is not set to a directory then the workbench will not start (we are using OR 4.1).

We had a problem once where the "II_TEMPORARY" directory - was actually a file and this would not allow the workbench to open. II_TEMPORARY must be in uppercase as well.

Regards

Graham Jakins

Database Administrator

tel: 08 9340 5234

fax: 08 9340 5111

mbl: 0408 956 864

Brian


Brigitte Duplenne wrote:

________________________________________________________________
OpenROAD-Users mailing list


This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

Brian Risley

unread,
Aug 27, 2007, 10:54:27 PM8/27/07
to International OpenROAD Users
Thanks,
Will check in the am.  Not sure if I did it in all uppercase.
Brian

Brian Risley

unread,
Aug 27, 2007, 10:45:55 PM8/27/07
to International OpenROAD Users, Russel...@ingres.com
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

unread,
Aug 28, 2007, 1:19:44 AM8/28/07
to Brian Risley, International OpenROAD Users
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

gareth.2...@bt.com

unread,
Aug 28, 2007, 5:54:31 AM8/28/07
to openroa...@peerlessit.com
I've had this error when the temp directory does not exist for the
installation. Usually: %II_SYSTEM%\temp


Cheers,
Gareth Edwards

BT Global Services
tel: +44 (0)131 345 4671
email: gareth.2...@bt.com

-----Original Message-----
From: openroad-us...@peerlessit.com
[mailto:openroad-us...@peerlessit.com] On Behalf Of Brian Risley
Sent: Tuesday, August 28, 2007 2:07 AM
To: openroa...@peerlessit.com
Subject: [Openroad-users] Error E_DO0073 - Intermediate storage file
couldnot be opened.

Pete Rabjohns

unread,
Aug 28, 2007, 6:05:32 AM8/28/07
to International OpenROAD Users
If you download the filemon utility from MS (aka sysinternals) you can
trace the file access and the failures as they happen and it will give
you the details you need to resolve it.

Pete

Kenneth....@tietoenator.com

unread,
Aug 28, 2007, 6:45:34 AM8/28/07
to openroa...@peerlessit.com
Hi,

If the user lacks local administrator privileges try giving him that.
If that solves the problem it ought to be related to bug 116137.

Hope this helps

Kenneth Olsson
TietoEnator Corporation
Digital Innovations
Phone +46 (0) 10 481 30 15
Mobile +46 (0) 70 365 46 38
Kenneth....@TietoEnator.com

Brian Risley

unread,
Aug 28, 2007, 7:59:50 AM8/28/07
to International OpenROAD Users
He had this, I will check that it wasn't cancelled.
Brian

Brian Risley

unread,
Aug 28, 2007, 11:17:24 AM8/28/07
to International OpenROAD Users
Pete,
Can't find anything specifically offending. We have compared things
with another machine, but there are slight differences due to DLL's
present on the machines and all the initialization processing going on.
Also tried the Process Monitor to see if we could spot the problem.
We can see where the error log starts to be written and the exit of
w4gldev, but nothing immediately in front of that indicates a problem.
The 2 are fairly in synch just before this and there is no error
condition that we can see.
Brian

Brian Risley

unread,
Aug 28, 2007, 11:18:29 AM8/28/07
to International OpenROAD Users
Directory exists, II_TEMPORARY is present in upper case and spelled
correctly.
We can write to the directory.

Brian Risley

unread,
Aug 28, 2007, 11:14:19 AM8/28/07
to International OpenROAD Users
He is a member of the administrators group on the machine and is
properly indicated as an administrative user.

Pete Rabjohns

unread,
Aug 28, 2007, 11:51:40 AM8/28/07
to International OpenROAD Users
I don't suppose there is any virus software running, or entries in the
event log that would point to anything?

Also, you could try enabling Auditing on Failures on all actions, in the
Local Security Policy utility, which may throw up something.

I've seen this error before quite a few times and it's always been some
kind of file access/permissions problem.

Brian Risley

unread,
Aug 28, 2007, 11:31:56 AM8/28/07
to Russell Neal, International OpenROAD Users
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!

Bodo Bergmann

unread,
Aug 28, 2007, 12:20:35 PM8/28/07
to International OpenROAD Users
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-us...@peerlessit.com [mailto:openroad-us...@peerlessit.com] On Behalf Of Brian Risley
Sent: Tuesday, August 28, 2007 5:32 PM
To: Russell Neal
Cc: International OpenROAD Users

Joseph C. Kronk

unread,
Aug 28, 2007, 12:53:35 PM8/28/07
to International OpenROAD Users, Russell Neal

Brian,

 

Have you opened an Ingres Service Desk issue?

 

-Joe

 

From: openroad-us...@peerlessit.com [mailto:openroad-us...@peerlessit.com] On Behalf Of Brian Risley


Sent: Tuesday, August 28, 2007 4:32 PM
To: Russell Neal
Cc: International OpenROAD Users

Brian Risley

unread,
Aug 28, 2007, 1:00:12 PM8/28/07
to International OpenROAD Users
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:

Brigitte Duplenne

unread,
Aug 28, 2007, 1:29:44 PM8/28/07
to International OpenROAD Users
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-us...@peerlessit.com [mailto:openroad-us...@peerlessit.com] On Behalf Of Brian Risley
Sent: mardi 28 août 2007 10:00
To: International OpenROAD Users

Brian Risley

unread,
Aug 28, 2007, 1:05:13 PM8/28/07
to International OpenROAD Users
Will try that,
but we did log on as Local Machine Admin, and it still didn't fly.
Brian

Peter van Bennekom

unread,
Aug 28, 2007, 1:33:56 PM8/28/07
to International OpenROAD Users

This may be a long shot but do you start Ingres as a service?  You may want to check what user is used to run the service…

 

Peter van Bennekom | Sr. Principal Architect | Infor | office: 610-407-8113 | fax: 610-407-8027 | mailto:peter.va...@infor.com

Brian Risley

unread,
Aug 28, 2007, 1:42:14 PM8/28/07
to International OpenROAD Users
Yes, it is starting as the local service account and starts fine.
CBF/Netutil are happy.
Brian


Peter van Bennekom wrote:
This may be a long shot but do you start Ingres as a service?  You may
want to check what user is used to run the service...

 

Peter van Bennekom | Sr. Principal Architect | Infor | office:

Brian Risley

unread,
Aug 28, 2007, 1:45:03 PM8/28/07
to International OpenROAD Users
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-us...@peerlessit.com
[mailto:openroad-us...@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-us...@peerlessit.com
&subject=unsubscribe

		

		To subscribe click on this link

	

mailto:openroad-use...@peerlessit.com

<mailto:openroad-use...@peerlessit.com&subject=subscribe>
&subject=subscribe

		

	

________________________________________________________________

		OpenROAD-Users mailing list

		

		You can maintain your subscription here:

	


&subject=unsubscribe

		

		To subscribe click on this link

	

mailto:openroad-use...@peerlessit.com

<mailto:openroad-use...@peerlessit.com&subject=subscribe>
&subject=subscribe

		

		

		 

		

		    



	

	

	

	  





  


  _____  


________________________________________________________________

OpenROAD-Users mailing list



You can maintain your subscription here:


&subject=unsubscribe



To subscribe click on this link

mailto:openroad-use...@peerlessit.com

Brian Risley
unread,
Aug 28, 2007, 2:14:02 PM8/28/07
to International OpenROAD Users



  
  



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:



------------------------------------------------------------------------
    

    

________________________________________________________________
    

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-user...@peerlessit.com&subject=unsubscribe
    

    

To subscribe click on this link
    

mailto:openroad-use...@peerlessit.com&subject=subscribe 

  
Paul White
unread,
Aug 28, 2007, 9:37:37 PM8/28/07
to International OpenROAD Users







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-us...@peerlessit.com 
  [mailto:openroad-us...@peerlessit.com] On Behalf Of Brian 
  Risley
Sent: Wednesday, 29 August 2007 4:14 AM
Brian Risley
unread,
Aug 28, 2007, 10:23:48 PM8/28/07
to International OpenROAD Users



  
  



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:


  
 
			<mailto:openroad-user...@peerlessit.com&subject=unsubscribe> <mailto:openroad-user...@peerlessit.com&subject=unsubscribe>  
			&subject=unsubscribe 
			
			        
			
			        To subscribe click on this link 
			
			     
			
			mailto:openroad-use...@peerlessit.com 
			<mailto:openroad-use...@peerlessit.com&subject=subscribe> <mailto:openroad-use...@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-user...@peerlessit.com 
			<mailto:openroad-user...@peerlessit.com&subject=unsubscribe> <mailto:openroad-user...@peerlessit.com&subject=unsubscribe>  
			&subject=unsubscribe 
			
			        
			
			        To subscribe click on this link 
			
			     
			
			mailto:openroad-use...@peerlessit.com 
			<mailto:openroad-use...@peerlessit.com&subject=subscribe> <mailto:openroad-use...@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-user...@peerlessit.com 
			<mailto:openroad-user...@peerlessit.com&subject=unsubscribe> <mailto:openroad-user...@peerlessit.com&subject=unsubscribe>  
			&subject=unsubscribe 
			
			
			
			To subscribe click on this link 
			
			mailto:openroad-use...@peerlessit.com 
			<mailto:openroad-use...@peerlessit.com&subject=subscribe> <mailto:openroad-use...@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-user...@peerlessit.com&subject=unsubscribe 
			
			To subscribe click on this link 
			mailto:openroad-use...@peerlessit.com&subject=subscribe 
			


		
________________________________


		________________________________________________________________
		OpenROAD-Users mailing list
		
		You can maintain your subscription here:
		http://www.peerlessit.com/mailman/listinfo/openroad-users
Reply all
Reply to author
Forward
0 new messages