Our application is written in C# with Visual Studio 2005 using Oracle Data
Access Component (ODAC) 10.2.0.2.21 and Oracle Client 10.2.0.1.0 for
connection to the Oracle database. Specifically, the window's application is
using Oracle.DataAcce ss.dll 2.102.2.20. The windows application is served to
the user through Citrix. Since we pushed out a new version of the application
two weeks ago, I have seen a lot of "Connection must be open for this
operation" messages in the application log (I implemented log4Net rolling
file appender). The result to the user is that their user profile is getting
corrupted and the updates they are making to data are not persisting. An
Oracle error is not being thrown except for the one above. The code and
stored procedures for the user profile have not changed in well over a year.
The last change that would affect it was when we upgraded the ODAC and Oracle
Client back in January. Till this deployment two weeks ago, the users were
not having any problem. During testing, with the new application, we did not
have any problems.The machines hosting the windows application were brand new
out of the box when we installed the ODAC and Oracle Client so there are no
previous versions of Oracle on the machines. The tnsnames.ora and sqlnet.ora
files have not been altered. No changes to the host machines were made,
except for the updated version of our application since January. No settings
in Citrix have been altered. In searching different forums,
• I have checked the system32 folder and there are no Oracle files in there.
• I tried removing the Oracle.DataAcce ss.dll file from the installation
directory, but that just resulted in our application not working.
The only other alteration is that we are allowing another application to
"share" two of our tables. They are using a trigger from their side to update
the two tables using a DBLink. The table with the product updates is one of
the two tables that we are sharing with them, but I don't believe that they
can even see the table where we store the user profiles. A coworker of mine
has suggested altering some of the connection string settings as the other
application sharing tables with us may be hogging resources. For instance, we
are not setting the Min Pool Size, Connection Lifetime, Connection Timeout,
Incr Pool Size, or Decr Pool Size when we open a connection to Oracle from
the application, but have the ability to set them from the application config
file so that they will be used. Any suggstions on what numbers to use for
these? We have less than 500 users on at a time and the other application is
a lot less popular so has less than 100 users on at once, but I don't know
how they handle connections.
Any ideas? I'm really at the point where I'm pulling my hair.
Thank you,
Susan
1  6377 
Susan wrote:
Our application is written in C# with Visual Studio 2005 using Oracle Data
Access Component (ODAC) 10.2.0.2.21 and Oracle Client 10.2.0.1.0 for
connection to the Oracle database. Specifically, the window's application is
using Oracle.DataAcce ss.dll 2.102.2.20. The windows application is served to
the user through Citrix. Since we pushed out a new version of the application
two weeks ago, I have seen a lot of "Connection must be open for this
operation" messages in the application log (I implemented log4Net rolling
file appender). The result to the user is that their user profile is getting
corrupted and the updates they are making to data are not persisting. An
Oracle error is not being thrown except for the one above. The code and
stored procedures for the user profile have not changed in well over a year.
The last change that would affect it was when we upgraded the ODAC and Oracle
Client back in January. Till this deployment two weeks ago, the users were
not having any problem. During testing, with the new application, we did not
have any problems.The machines hosting the windows application were brand new
out of the box when we installed the ODAC and Oracle Client so there are no
previous versions of Oracle on the machines. The tnsnames.ora and sqlnet.ora
files have not been altered. No changes to the host machines were made,
except for the updated version of our application since January. No settings
in Citrix have been altered. In searching different forums,
• I have checked the system32 folder and there are no Oracle files in there.
• I tried removing the Oracle.DataAcce ss.dll file from the installation
directory, but that just resulted in our application not working.
The only other alteration is that we are allowing another application to
"share" two of our tables. They are using a trigger from their side to update
the two tables using a DBLink. The table with the product updates is one of
the two tables that we are sharing with them, but I don't believe that they
can even see the table where we store the user profiles. A coworker of mine
has suggested altering some of the connection string settings as the other
application sharing tables with us may be hogging resources. For instance, we
are not setting the Min Pool Size, Connection Lifetime, Connection Timeout,
Incr Pool Size, or Decr Pool Size when we open a connection to Oracle from
the application, but have the ability to set them from the application config
file so that they will be used. Any suggstions on what numbers to use for
these? We have less than 500 users on at a time and the other application is
a lot less popular so has less than 100 users on at once, but I don't know
how they handle connections.
Any ideas? I'm really at the point where I'm pulling my hair.
Thank you,
Susan
How are you reading the data from the database?
The error message is the same or similar to what you get if you try to
use a DataReader after you have closed the database connection. If you
have a small result set so that it all fits in the buffer, it might be
able to use a DataReader after the connection has been closed, but this
can stop working at any time if the data grows by a few bytes.
--
Göran Andersson
_____ http://www.guffa.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Keiran Reilly |
last post by:
We have a site running on w2k, IIS5.0. The problem is that
the site intermittently stops working and returns the
error "Not enough storage is available to complete this
operation.". This is only for ASP pages. HTML pages are
served fine. Restarting the services gets the site working
for a few minutes...
There is no problem with space on any drives.
The size of the paging file seems fine.
The registry size is fine.
|
by: KWINTERS |
last post by:
I have a 2GB Ram, Win2K SP4, SQL 2K SP3, 2 1.8GHz AMD
processor server that is getting occasional "not enough
storage space to complete this operation" errors on
certain ASP pages. The only way to fix it is to do
an "iisreset /restart" from a command prompt. I have the
latest MDAC, Scripting engine and have checked all sorts
of things. I cannot find any "on error resume next"
problems in the code as suggested by Microsoft. this This...
|
by: erikpaulmiller |
last post by:
I am trying to open up a blank email message by using the mailto: url.
I have noticed that it will work for any value under 2013 characters,
but once I have a To: list longer than 2014 chars then I get this IE
error "Could not perform this operation because the default mail client
is not properly installed".
I know that this is not the ideal solution to have this many people in
a To list, but it is a requirement that Outlook open up with...
|
by: pardhi a via SQLMonster.com |
last post by:
Hi
when i right click table and click design table then error occured
(an unexpected error occured during this operation)
If any one knows please let let me know your help would be appreciated .
thanks
pardhi
|
by: ujjc001 |
last post by:
access subquery error: "not enough storage is available to complete
this operation"
Query---
SELECT
TOP 100 PERCENT
UPPER(dbo.Employee.last + N', ' + dbo.Employee.first) AS Employee,
Employee.employeeNumber
FROM
| | |
by: webspinner |
last post by:
I'm trying to develop a web service using C# and everytime I try to
instantiate a NotesSession object like so:
m_session = new NotesSessionClass();
the object throws an exception with the message:
|
by: John Donnell |
last post by:
We have recently added another PC to the network and have run into
difficulty when trying to open access files from the server using the
new box. We get the error message
'MS Access cannot open this file. The file is located outside your
intranet or on an untrusted site. MS Access will not open the file due
to potential security problems. To open the file, copy it to your
machine or an accessible network location.'
Yes it can be...
|
by: JavaDev |
last post by:
When i am trying to display progress bar using javascript with the first page load of my application
i was getting an error with IE "internet Explorer cannot open this site "
how to get rid of this problem ? can any one suggest me
Thanks
JavaDev
|
by: sandhya20 |
last post by:
Hi,
the following code is working fine when i am running the application.exe file.
System.Diagnostics.Process.Start(filename);
But when i am opening it by using "Run As" option & giving user name & pwd it is throwing exception
No application is associated with the specified file for this operation.
plz help me out
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
