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 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"
