Solved

Getting Errors during replication

P
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

icon

Best answer by Dani Moran 26 July 2024, 19:51

View original

3 replies

A

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.

P
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.

D
Userlevel 4
Badge

For that particular error, looking into the daemon logs are the best way to troubleshoot it. You can get that by going to the Settings dialog in the DBAmp Configuration Program, and setting the Daemon Logfile parameter to a full file path (where the folder already exists and is able to be written to, example: c:\Logs\DBAmpDaemonLog.txt), Enable Logs to True, and Log Mode to DEBUG. Once you've done that, you should restart the daemon using the Daemon Console in the DBAmp Configuration Program, then wait until the error re-creates. 

 

With those, I would recommend writing in to DBAmpSupport@CData.com - that will create a ticket, and the agent picking it up will be able to send you a link to our secure file repository to transfer those logs so we can help go over them.

 

The main reason I recommend that path is there are a couple of things that can show up this way. it could be that you are hitting the Max Connections setting, especially as agold noted that they were getting it when running many SF_Replicate commands simultaneously. That can be set in the DBAmp Configuration Program - we recommend Max Threads be upped to match whatever you set Max Connections to. It could also be that the daemon service is shutting off temporarily, restarting in time to run the next command just fine. It can occasionally come from something off about the configuration of DBAmp, though that seems least likely since you are seeing it intermittently.

Reply


Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=
Terms and ConditionsCookie settings