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] <mailto:[email protected]> ]On 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
