Failed to configure a Discovery Accelerator customer database.

book

Article ID: 100023095

calendar_today

Updated On:

Description

Error Message

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.)

Resolution

When configuring a Discovery Accelerator customer database, it failed with an error:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.)
This error typically mean that another application or service is blocking port on the SQL server.

Figure 1.
 

The following event Id's also occurred.

Event Type: Error
Event Source: Accelerator Manager
Event Category: None
Event ID: 49
Date: 1/13/2009
Time: 12:03:18 PM
User: N/A
Computer: DA_Server
Description:
APP ATM - Error Executing : D:\Symantec\DiscoveryAccelerator\AcceleratorDatabase.sql
Line: 14244
Failed to Execute the following command:

CREATE PROCEDURE usp_manage_jobStep
@JobID BINARY(16),
@JobStepName sysname = 'DefaultStep',
@OldJobStepName sysname = 'DefaultStep',
@JobDatabaseName sysname = null,
@JobCommand nvarchar(3200),
@JobServer nvarchar(30) = null,
@JobDatabaseUserName sysname = NULL,
@JobSubSystem nvarchar(40) = N'TSQL',
@JobCmdExecSuccessCode int = 0,
@JobFlags int = 0,
@JobRetryAttempts int = 5,
@JobRetryInterval int = 1,
@JobOutputFileName nvarchar(200) = N'',
@JobOnSuccessStepId int = 0,
@JobOnSuccessAction int = 1,
@JobOnFailStepId int = 0,
@JobOnFailAction int = 2,
@StepID int = 1
AS


Event Type: Error
Event Source: Accelerator Manager
Event Category: None
Event ID: 50
Date: 1/13/2009
Time: 12:03:19 PM
User: N/A
Computer: DA_Server
Description:
APP ATM - Failed to create database: server=SQL00A;Initial Catalog=DA_Customer2;Integrated Security=true;Connection TimeOut=500;Connection LifeTime=200;Max Pool Size=300;Application Name=Discovery Accelerator. System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.)
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning()
  at System.Data.SqlClient.TdsParserStateObject.WriteSni()
  at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
  at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
  at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  at KVS.Accelerator.Application.Install.RunScript(String ScriptName, SqlCommand CMD, Int32 CustomerID)
  at KVS.Accelerator.Application.Install.CreateDatabase(Int32 CustomerID, String DSN, CustomerType CustType, String LanguageID)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Event Type: Error
Event Source: Accelerator Manager
Event Category: None
Event ID: 64
Date: 1/13/2009
Time: 12:03:19 PM
User: N/A
Computer: DA_Server
Description:
APP ATM - Error installing a Customer.
Install Thread - worker thread (1)
Customer ID: 6
Number of tries: 1
Cause: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



From a dtrace log on the DA_Server with AcceleratorManager and AcceleratorService enabled, this information is found:
DTrace trace log for server: DA_Server.domain.com
[Opened: 2009/01/13 11:01:16]

Enabled Trace options

Id    Name                             Detail     Include Events
1   - AcceleratorManager               Verbose    No          
2   - AcceleratorService               Verbose    No          

-----


Display Filter:
 Include strings:
   EV-
   EV:
   EV~

 Exclude strings:
   CMMStream
   DBFramework
   DirectoryConnection
-----


Running in Terminal Services session...
 Monitoring debug output from processes running in the console session
 Monitoring debug output from processes running in the current Terminal Services session

1 11:01:19.067 [6084] (AcceleratorManager) EV-L {-} {MANAGER.EN_US} {C.EN_US} The Task module for the Customer: 'DA_Customer' is disabled because it needs to be updated from version 6 to version 8.00031
3 11:01:27.520 [3400] (AcceleratorService) <3600> EV-L {-} {TASKSMODULEINFO.EN_US} {CEVBAADMIN.EN_US} Ping from 'EVDA001':: Remote Caller Principal Name: NT AUTHORITY\NETWORK SERVICE


CAUSE:
Typically, this issue is caused by an application or service preventing TCP/IP calls from a Discovery Accelerator to properly communicate with a SQL server.  One of the possible culprits is an Antivirus (AV) software installed on the Discovery Sever.  It prevents TCP/IP calls from a Discovery Accelerator to communicate with a SQL server.

SOLUTION:
To resolve this issue, temporary disable the AV services on the Discovery Accelerator server.
Create a customer database from the Discovery Accelerator Administration webpage.
This time, the customer database should be created successfully.
Restart AV service once the DA customer database is created.
 
 

 

Issue/Introduction

Failed to configure a Discovery Accelerator customer database.