I wouldn't have noticed mine too but as a habit if I have control of the backend database I usually am in the habit of restricting number of user connections if that is possible and since it is on SQL, I had it down to 50. We hit the 50 limit twice today on our development box, and that's how we ended up noticing that EIE seems to hog all these 'extra' connections..
Also one of my co developer was noticing degradation on performance due to timeouts so we think we know why we were getting these timeouts. Right now I am in the process of writing what we have learnt to our first line of support.. Is there any chance I could have your Issue number so we could inform our first line of support that there is a related ticket open? Maybe that might help them help us.. We don't as yet have a ticket open directly with Remedy but if we can have our first line understand this is a potential bug we could have a remedy support ticket created quicker.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Tuesday, July 10, 2007 3:00 PM To: [email protected] Subject: Re: EIE Service crashing periodically with a Windows error... ** I have an open issue on the memory leaks in EIE patch 004 and 005, and I posted this information to it right after I sent it to the list. If you had not mentioned seeing extra connections, I might not have noticed it - the SQL Server involved is x64 on a dedicated server with 10 gb RAM, so I suspect it could have gone a _lot_ farther down the road before it started giving me any kinds of errors. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, July 10, 2007 1:51 PM To: [email protected] Subject: Re: EIE Service crashing periodically with a Windows error... ** Hi Chris, Thank you for the information.. What you are describing is exactly what I am seeing on my server.. I have 5 instances of EIE, 3 of which are being used by Data exchanges that are defined. So what happens the minute I start all these 5 instances is that it opens 5 user connections to the SQL database and in a minute or so 2 connections close, (instances where no exchanges are defined on) leaving me with 3 open user connections to SQL consumed by EIE.. However, as the exchanges kick of periodically, it opens up an additional connection leaving the previous open so from 3 open connections from the time I started these services about an hour ago, I have now ended up with 11 open connections that are sleeping! And I think this keeps on increasing till it hits the SQL server limit we defined at 50 connections and then it throws up SQL errors of no more available SQL connections to attach itself to! If this what looks like an obvious defect on the EIE, I wonder if its being addressed to??? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Tuesday, July 10, 2007 11:59 AM To: [email protected] Subject: Re: EIE Service crashing periodically with a Windows error... ** You know, that's a real possibility. My AR server where I have a form updated by EIE every 15 minutes is showing similar connections to a server without EIE active - about 25 connections to the ARSystem database. The SQL Server with the vendor form EIE is reading from and posting back a Response to is a separate server from those hosting the ARSystem databases, and it is showing 918 sleeping connections from EIE!! Obviously it is opening a new connection every time it checks for any new data exchange definitions (hourly) and when it runs a scheduled data exchange (every 15 minutes), and is not releasing any of them. No wonder the eie.exe (patch 005) is gaining 200 K every time it runs!! Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/ ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, July 10, 2007 10:35 AM To: [email protected] Subject: Re: EIE Service crashing periodically with a Windows error... ** I see this in the <exchange name>-T2.dbg file just before the time the service crashed. The service crashed at 5:00:41 AM [04:56:41,07/10/07] - CONNECT CDC, USER ARAdmin (Native Database) [04:56:41,07/10/07] - *** ERROR *** [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11) [04:56:41,07/10/07] - VendorOpenConnection: unable to connect to database, rc = 590 [04:56:41,07/10/07] - Error: Adapter.OpenConnection completed with errors issued [04:56:41,07/10/07] - StartDataHandlers: Vendor Data Handler failed to start. [04:57:41,07/10/07] - CONNECT CDC, USER ARAdmin (Native Database) [04:57:41,07/10/07] - *** ERROR *** [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11) [04:57:41,07/10/07] - VendorOpenConnection: unable to connect to database, rc = 590 [04:57:41,07/10/07] - Error: Adapter.OpenConnection completed with errors issued [04:57:41,07/10/07] - StartDataHandlers: Vendor Data Handler failed to start. [04:58:41,07/10/07] - CONNECT CDC, USER ARAdmin (Native Database) [04:58:41,07/10/07] - *** ERROR *** [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11) [04:58:41,07/10/07] - VendorOpenConnection: unable to connect to database, rc = 590 [04:58:41,07/10/07] - Error: Adapter.OpenConnection completed with errors issued [04:58:41,07/10/07] - StartDataHandlers: Vendor Data Handler failed to start. [05:00:41,07/10/07] - Thread started [05:00:41,07/10/07] - ExchangeByComparingLists: [935] entries will be processed into AR/CMDB [05:00:41,07/10/07] - Start comparing list of records on Tue Jul 10 05:00:41 2007 [05:00:41,07/10/07] - SessionID=CDC data [05:00:41,07/10/07] - direction=VendorDataIntoAR [05:00:41,07/10/07] - updateType=Both New and Changed [05:00:41,07/10/07] - AR System Data Server=remedydev1 [05:00:41,07/10/07] - >> Intermediate statistics [05:00:41,07/10/07] - [05:00:41,07/10/07] - ExchangeByComparingLists: Vendor Key = 1, AR Key = 1, Vendor Key = AR Key, check for changes Would the service have reasons to fail and terminate because there are unavailable user connections to the database? I looked at the SQL logs and it did look like the number of SQL users had exceeded 50. That the user connections should rise to 50 is almost impossible at 5:00 AM in the morning at this site as we have only 5 Fast, 10 List and 2 Private threads configured to the database and besides the AR System, there are no other connects to the database. What would bring the user connections up to 50? Are there connections established to the database that are not being released once its been established? And is there a fresh connection activated everytime a data exchange service runs leaving it open after its completed??? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Axton Sent: Tuesday, July 10, 2007 10:49 AM To: [email protected] Subject: Re: EIE Service crashing periodically with a Windows error... We have similar issues on Solaris. We have been though multiple debug builds and as far as I know the problem is still happening, occasionally. Axton Grams On 7/10/07, Joe D'Souza <[EMAIL PROTECTED]> wrote: > I have a test data exchange established on a database that resides on the > same database server as the AR System server.. Everything seems to work well > as far as the exchanges run but periodically, I get a windows error that > kills the EIE service that this exchange is tied to. > > This windows error pops up in a typical windows fashion, with the dialog box > that can send the information to Microsoft. > > This is what I see in the Windows Event Application log > > Faulting application eie.exe, version 768.0.4480.0, faulting module > sqladpr.dll, version 4.0.0.920, fault address 0x000032bc. > > Before this service failed it must have successfully executed the exchange > at least 20 times. > > I have 5 instances of the EIE service enabled, 3 of these instances are > being consumed by 3 different data exchanges.. The service seems to have > failed for the first instance, while the remaining 4 continue to run. > > Anyone else have experienced similar errors? > > Joe __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.2/893 - Release Date: 7/9/2007 5:22 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
