Question

Getting Errors during replication


Userlevel 1
Badge

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 [SQLSTATE 01000]
16:21:52: Parameters: [LS_SALESFORCE_PROD] ContentWorkspaceDoc Version: V8641 [SQLSTATE 01000]
16:22:20: Running DBAmpAZ.exe. [SQLSTATE 01000]
16:22:20: DBAmpAZ 22.0.8642.0 Copyright © 2023 CData Software, Inc. [SQLSTATE 01000]
16:22:20: Using options specified in Options parameter: soap [SQLSTATE 01000]
16:22:36: Error: Unable to open a connection to SQL Server. [SQLSTATE 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 [SQLSTATE 01000]
.ComponentModel.Win32Exception (0x80004005): The wait operation timed out [SQLSTATE 01000]
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserI [SQLSTATE 01000]
nstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) [SQLSTATE 01000]
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) [SQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) [SQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) [SQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) [SQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) [SQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) [SQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) [SQLSTATE 01000]
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) [SQLSTATE 01000]
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) [SQLSTATE 01000]
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) [SQLSTATE 01000]
at System.Data.SqlClient.SqlConnection.Open() [SQLSTATE 01000]
at afo220j.G.d() [SQLSTATE 01000]
ClientConnectionId:e7f89121-cd7a-4a46-b6fe-7efc7f0b317d [SQLSTATE 01000]
Error Number:258,State:0,Class:20 [SQLSTATE 01000]
16:22:36: DBAmpAZ Operation FAILED. [SQLSTATE 01000]
16:22:50: Error: Replicate program was unsuccessful. [SQLSTATE 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" [SQLSTATE 01000]
--- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
Error: SF_Replicate failed for table ContentWorkspaceDoc [SQLSTATE 01000]
Error 50000, Severity 16, State 1, Line 318 [SQLSTATE 01000]
--- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

What is the cause and how can i fix this?

 

thanks

Peter


2 replies

My org is also experiencing this issue. Not sure if there is some limit to how many SF_Replicate commands can run simultaneously, but it seems like a deadlock. Also not clear if it’s due to DBAMP or the partial copy Sandbox we’re running replicate on.

Userlevel 1
Badge

My org is also experiencing this issue. Not sure if there is some limit to how many SF_Replicate commands can run simultaneously, but it seems like a deadlock. Also not clear if it’s due to DBAMP or the partial copy Sandbox we’re running replicate on.

mhh i dont think it should be an issue whether it is a production system or a anykind of sandbox. We usually test scripts on a full copy.

 

But still a valid thought.

Reply