Sitemap

Amicuk Programming Answers

Windows Service Enterprise Library Data Access Application Blocks Connection Pooling Issue

-0001-11-30   Views:0

Advertisement

Hello, We are developing a windows service using c# .net v 4.5.1 which communicates with SQL database (SQL 2008 R2 x64), communication with SQL server is done using Enterprise Library data access block v 6, The windows service does a file copy proces

Hello,
We are developing a windows service using c# .net v 4.5.1 which communicates with SQL database (SQL 2008 R2 x64), communication with SQL server is done using Enterprise Library data access block v 6, The windows service does a file copy process in bulk &
updates the database about the status of file copy, it is observed that as soon as we start the service the number of connections get max out & we start receiving a "Timeout expired.  The timeout period elapsed prior to obtaining a connection
from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached."
This issue is only observed when we run the code logic by deploying it as a windows service, When we run the exactly same code as a standalone exe (right click -> run as administrator) / non windows service, the connections on database are not exceeded
& we do not receive the above mentioned error.
The code block which makes calls to the database is under the c# "using" statement, hence connection pooling should be handled by default.
Could you please recommend any suggestions on areas which I might have missed on to investigate this issue.
Thanks in advance.

The replay answer
Advertisement
Hi
The issue got resolved after refresh the SCOM Data base access service  account in SQL 2012.
Unable to launch the operations manager 2012 R2 console after extended the C drive of the SQl server ,getting error "The Data
Access service is either not
running or not yet initialized.
Got to your SQL server -->databases-operationsmanager--security-users--locate the daa service account and refresh.issue fixed and am able to luanch.

Go to See the other 26 answers

Windows Service Enterprise Library Data Access Application Blocks Connection Pooling Issue

Category:DefaultRelease time:-0001-11-30Views:130

Hello, We are developing a windows service using c# .net v 4.5.1 which communicates with SQL database (SQL 2008 R2 x64), communication with SQL server is done using Enterprise Library data access block v 6, The windows service does a file copy proces[More]

Data Access Application Block

Category:DefaultRelease time:-0001-11-30Views:130

Is there any talk of doing a Oracle version of Data Access Application Block for .NET? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.aspInitial implementation here: http://forums.oracle.com/forums/thread.jspa?thr[More]

Issue with Enterprise Library's Data Access Application

Category:DefaultRelease time:2015-10-11Views:130

I do not know if I have the correct forum for this post. I hve put it in what I believe is the most likely best forum, but please move this if there is a more germane forum for it. I have inherited a solution (C#) which uses the reference Microsoft.P[More]

Oracle Application server connection pool and database links

Category:DefaultRelease time:-0001-11-30Views:130

I am using Oracle application server 10g with connection pools, the db used by the application connects to another oracle db using a database link. My question is when the application starts it creates 10 connections, does it also create x amount of[More]

KIMYONG : Applications Database Connection Pool 관련 parameter 설명

Category:DefaultRelease time:-0001-11-30Views:130

Purpose JVM 이 과도한 CPU / Memory를 사용하게 되어 Application Performance에 영향을 미칠때가 있으며 이럴경우 Connection Pool 관련하여 Parameter Tunning을 해야 할때가 있습니다. 이때 사용되는 Parameter들의 의미를 설명하고자 합니다. The Applications Database Connection Pool is a pool of JDBC database connection[More]

Application wide connection pooling

Category:DefaultRelease time:-0001-11-30Views:130

Just a quick question about connection pooling. How would one go about using application-side connection pooling? For example, I have multiple users logged into my application, all wanting to access the same database (with different username/password[More]

Excel Automation with Interop - Windows Service - Microsoft Excel cannot access the file

Category:DefaultRelease time:2015-10-11Views:130

I have a windows console application, which automates Excel. In our scenario the application gets called from a Windows Service. If the console app is executed directly everything works fine. If the console app is executed through the Win Service, we[More]

Windows 7 Enterprise - Cannot Print - Access Denied

Category:DefaultRelease time:-0001-11-30Views:130

Hello Guys, I have strange issues..i just created a new Windows 7 Image. Even if i'am connected with Local Admin or Domain users, i cannot print to any printers. When i want to print a test page, i receive the following error message " Print Test pag[More]

Connection pool issue with packaged application

Category:DefaultRelease time:-0001-11-30Views:130

we are using 9.2 mp1 for a Oarcle packaged application which is talking to Oracle RAC. In production one of the RAC nodes went down and we see that the wbelogic connection pool is never able to reconnect This is a packaged application Bharosa which i[More]

Read data using 2 diff connection pool for same DB folder in physical layer

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, i am using two connection pool which have different dsn connection information (both are directed to different database name or database server).. so if i view the data of any table, a prompt will come asking for the connection pool, so how d[More]

Hyperion Enterprise historic data access (tool)

Category:DefaultRelease time:-0001-11-30Views:130

we are moving from Hyperion Enterprise to SAP SEM. As the historic data won't be moved we are looking for the best and easiest way to be able to access that data in the future. Is there an option of not using Enterprise anymore? Reading the data with[More]

Hot
Hello, Just started learning threads a few days ago.. my objective is to move an oval from left to right, then right to left, back and forth and so on.. however, it wont work, the source code i have below seems logical, but it doesnt fulfill my objec [More]
Hi, I went to bed at 10:30pm last night, set my iPhone alarm for 05:30am this morning, dimmed my brightness to its lowest setting (as I always do, so I don't get blinded when I check the time during the night) and then left my phone beside my bed. Th [More]
I have an 17" iMac that I'm preparing to upgrade from 10.2.8 to 10.4. In preparation, I did the following: * Mounted a new external HD (LaCie) (my second one) * Backed-up all personal files / folders to the new drive * Ran Software Update to check fo [More]
My bank emailed me an important adobe file as a zip and I keep getting an error message not an adobe format or not encoded properly.  How do I open the zip file?Hi ferretlady, As you mentioned that you have zip file that contains Adobe files, you nee [More]
Hi I had AR Invoice with 100000 Inr amount, But I got Payment 50000 ,25,000,25000 in diffrent dates. If i made In coming payment first time . Ok that invoice displaying in incoming payments , Second time no Invoice displaying In incoming payment so N [More]
hi, we're using WM which needs to print picking list for picking(TO), i would like to know how the picking list is determined, i mean the logic setup for picking list, where is the path for config in the system. i knew that if we are using by Tcode t [More]
Hello, I have FCS 2 on Mavericks installed and evything works fine except preview in Color 1.0.4 During playback or color correction preview flashes- I have only this one issue (I don't use qmaster so doesn't working pref pane is not issue for me) Ha [More]
I have a multi tab report that all the tabs are based off different queries.  I want to suppress individual tabs and not have them export in Excel if the query returns no records.Hi, We can do this manually by selecting required report tabs (copy) an [More]
Hi, I'm just trying to understand how to work with sound.  Although you can find many mp3 player codes available to use it's difficult to customize them if don't really know what's going on. So I set about looking at the sound examples in the help me [More]
Ok, How can I get my virtual app to show in the list of Default Programs in Windows control panel? For instance I want to set my virtualized Notes client to be the default mail client for the workstation.Ron, That took longer than I thought it would, [More]

    Database error: [Table 'ac_posts' is marked as crashed and should be repaired]

    SELECT * FROM ac_posts WHERE `ID` IN (3259126,5047759,3626820,2732979,2819904,4588816,1527346,608435,4395469,3623039,3516941,3239901,2867303,2624181,4688830,29446,3112964,964238,3615404,3117993,1923989) LIMIT 10;