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
Hi, Is it possible to purchase an item for a sales order but item is not actually on sales order? I know we can create PO through SO logistic tab and also through procurement confirmation wizard but these functionalities can be used to buy the item w [More]
Hello! I just "upgraded" my setup from macmini to mbp. Which means I'm new to 2 screen setup, that I have now on my table. There are some really annoying things about it. As I use laptop in front of my cinema display I have laptop screen on the [More]
Ipohne 4S  - When I use the headphones the sound is distortedi have the same problem in my iphone, i restored and update but the problem persist. HELP!Read other 2 answers [More]
Trying to update my iphone 5 to iOS7 - got the error 1667 after iOS7 was downloaded. HelpApple's servers are busy. Check again in a few hours or tomorrow. (89483)Read other 4 answers [More]
i am having trouble uploading photos from my ipad onto my macbook version 10.6.6. any suggestions?There are third party apps that will enable you to transfer the photos wirelessly via WiFi  - apps like Photo Transfer for example. You can also connect [More]
Hi, I have an requirement to retrive network user id and domain based on SAP user id from HR infotypes. Does anyone knows in which infotype can i find these fields. Regards HemaHi Hema, <b>1</b>. Infotype :<b>0105</b>. Database tab [More]
User environment (Not Working): Windows 8.1 Enterprise Internet Explorer 11.0.9600.17498 (Update Version: 11.0.15 KB3008923) User Environment (Working): Windows 7 Internet Explorer 10.0.9200.17148 (Update Version: 10.0.22 KB3003057) Server environmen [More]
About 2 days ago, all Youtube videos from the site and embedded ones stopped loading. I would just get a black screen on Youtube.com and a white space on an embedded video. I have not touched any Firefox settings. I have all the latest plugins includ [More]
Hi : I am having a Text editor swf file.I am omporting thst fiel into director and when i enter the data into text editor and make customiztion like bold,underline i am able to apply it to the content and also i am able to get the htnl format of that [More]
We are migrating EP6 SP2 P5 to NW04 on Unix HP-UX 11.11. We immediately launched the KMC migration and it comes up and the hour glasses endlessly.  We are migration the customers Production system and need some ideas of what might be wrong ASAP. Than [More]