Hi,
since two weeks we are getting error when replicating all of our salesforce objects. The error does occur randomly not specific to an object. See error example message:
--- Starting SF_Replicate for ContentWorkspaceDoc V8641 1SQLSTATE 01000]
16:21:52: Parameters: :LS_SALESFORCE_PROD] ContentWorkspaceDoc Version: V8641 1SQLSTATE 01000]
16:22:20: Running DBAmpAZ.exe. .SQLSTATE 01000]
16:22:20: DBAmpAZ 22.0.8642.0 Copyright © 2023 CData Software, Inc. cSQLSTATE 01000]
16:22:20: Using options specified in Options parameter: soap aSQLSTATE 01000]
16:22:36: Error: Unable to open a connection to SQL Server. rSQLSTATE 01000]
16:22:36: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) ---> System eSQLSTATE 01000]
.ComponentModel.Win32Exception (0x80004005): The wait operation timed out uSQLSTATE 01000]
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserI rSQLSTATE 01000]
nstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) rSQLSTATE 01000]
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) sSQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) sSQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) nSQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) nSQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) nSQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) nSQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) nSQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) sSQLSTATE 01000]
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) ySQLSTATE 01000]
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) ySQLSTATE 01000]
at System.Data.SqlClient.SqlConnection.Open() (SQLSTATE 01000]
at afo220j.G.d() (SQLSTATE 01000]
ClientConnectionId:e7f89121-cd7a-4a46-b6fe-7efc7f0b317d 7SQLSTATE 01000]
Error Number:258,State:0,Class:20 2SQLSTATE 01000]
16:22:36: DBAmpAZ Operation FAILED. DSQLSTATE 01000]
16:22:50: Error: Replicate program was unsuccessful. lSQLSTATE 01000]
16:22:50: Error: Command string is C:\"Program Files"\CData\"CData DBAmp"\bin\DBAmpAZ.exe FullCopy "ContentWorkspaceDoc" "ds-apps1-461" "SALESFORCE PROD" " LS_SALESFORCE_PROD]" "soap" pSQLSTATE 01000]
--- Ending SF_Replicate. Operation FAILED. DSQLSTATE 01000]
Error: SF_Replicate failed for table ContentWorkspaceDoc oSQLSTATE 01000]
Error 50000, Severity 16, State 1, Line 318 1SQLSTATE 01000]
--- Ending SF_Replicate. Operation FAILED. DSQLSTATE 01000]
What is the cause and how can i fix this?
thanks
Peter