Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2006-06-08
4
Medium Priority
?
5,430 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 1500 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

606 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