Solved

ClickOnce: Error while trying to retrieve text for error ORA-01019

Posted on 2006-06-08
4
5,166 Views
Last Modified: 2007-12-19
I was trying to deploy my application with ClickOnce using C# 2.0, VS2005, windows app.
After the app detect there is a latest version, it downloads the latest and restarts the app.
Error occurred after the restarts:

Error while trying to retrieve text for error ORA-01019

Stack Trace:
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
...

Check on Oracle Document says:
ORA-01019: unable to allocate memory in the user side
Cause: The user side memory allocator returned error.
Action: Increase the processes heap size or switch to the old set of calls.

Can anyone helps? What went wrong?
0
Comment
Question by:michellechan57
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
topdog770 earned 500 total points
ID: 16870915
It almost sounds as though there are some Oledb objects getting created when your app starts that don't get cleaned up correctly when the app does a shutdown in prep for being updated.

0
 

Author Comment

by:michellechan57
ID: 16875333
Any suggestions to cleaned up correctly?

I called close method of OleDbDataReader after finish reading all data and
close method of OleDbConnection is in finally block to ensure that all connection are closed.
I have also used OleDbCommand and OleDbDataAdapter.
0
 

Author Comment

by:michellechan57
ID: 16965571
Can I request to delete this question?
0
 
LVL 12

Expert Comment

by:topdog770
ID: 16970429
michelle, I'm sorry, I lost track of this question.. I'm certainly ok with your delete request, did you get the issue resolved?

If not, two things to check..

First, if you have installed several versions of Oracle on a computer, there are some web threads that have correlated "left over" oracle 'stuff' causing this oracle error, where the 'left over' pieces can be either registry settings, etc and or code specific issues( where taking the same code into a new project allowed the Oracle connection process to occur successfully )

Also, ( indirect example ) http://help.netscape.com/kb/corporate/19970825-5.html

We have seen this issue.  ( We started using a much earlier version of Oracle ( 6 or 7) it was before my time here, and we've had to maintain this NLS_LANG=american_america.US7ASCII setting even into our current flavor on Oracle 9, or 10 now, in order to allow some of our applications to be able to connect properly.


0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exit the loop 4 43
Question! 4 36
Graphics 2 30
c# - Best approach for objects in functions 3 17
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question