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
I am using a Power Mac G4 with the original 20GB hard drive and running OS 9.2.2. I would like to upgrade to 10.4 (Tiger) installing it on a 80 GB Seagate Ultra/ATA 100 which I need to install as a second hard drive. This is where my problem arises. [More]
Hi, Long time reader, first time requesting help. My FCP 7 won't launch... says I have "0" VRAM. I actually have 12GB. Apps that wont launch - FCP, Bridge, After Effects, Compressor. HELP!!!! I am using a 2 x 2.8 GHz Quad-Core Intel Xeon with 12 [More]
I got a set of the HN-505 headphones for my laptop. But the problem is that is it has a two-prong connection. but my laptop only has a single output jack and a micro-phone jack. so when i plug in the headphones I can only hear audio on one side. I wa [More]
Hello, The error is coming as "Posting complete retirement not poss.with value date" when i am executing ABUMN. I am providing the asset value date same as the old assets Capitalisation date.The output comes as: Diagnosis Transactions have been [More]
hi I want to my webcenter Application to make webservice dataControl with external application(BPEL/Jd Edwards) consuming the WSDL url. I have created DataControl consuming a WSDl URL which is deployed on Server instance within the Firewall of my org [More]
hello I am using map definitions tool to define my legends, but i have a dynamic application which needs a numerous number of legend, so i need a command to define my legend instead of creating in a GUI interface of this tool. thanks in advanceHi!, m [More]
hi friends , i have created a JTabbePane and added few tabs like, addd tab, delete tab, modify tab.... etc how do i track the evnt when user select different tab . i have to perform few tasks when the tab selectio changes.. so how do i do that pls do [More]
Hello! Can embedding be done through code? [Embed(source="images/up.png")] private static const _up:Class; And how can I use such variables in this kind of context: var name:String="up'; this["_"+up] etc Thank you!I thought that m [More]
Photoshop CS3, Mac OS 10.5.2 After I create a custom soft proof I would like it show up in the "View" drop down. Where is the "default" location to save custom soft proofs so that they show up in the drop down menu? ThanksWhen you save [More]
Bonjour, J'ai acheté aujourd'hui à apple store en même temps qu'un Mac, la version étudiante de : Adobe Creative Suite 6 Design Standard. On me propose d'aller sur ce site: adobe.com/go/edu_verify_ecomm_fr qui ne marche pas et apres un chat d'une dem [More]