Solved

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

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction                                                 Was the var keyword really only brought out to shorten your syntax? Or have the VB language guys got their way in C#? What type of variable is it? All will be revealed.   Also called…
Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

758 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

23 Experts available now in Live!

Get 1:1 Help Now