Solved

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

Posted on 2006-06-08
4
5,117 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now