Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Operation time out error for replicating EmailMessage object. Help needed ASAP

I'm trying to replicate few salesforce objects into our datawarehouse using DBAmp.

I received this error while replicating 'EmailMessage' table to SQL server. And for other tables it is working fine.

Could you please advise me to resolve this issue.

Error Message:
--- Starting SF_Replicate for EmailMessage
08:00:34: Drop EmailMessage_Previous if it exists.
08:00:34: Create EmailMessage_Previous with new structure.
08:00:35: Run the DBAmp.exe program.
08:00:35: DBAmp Bulk Operations. V2.17.8 (c) Copyright 2006-2013 forceAmp.com LLC
08:00:35: Populating local table EmailMessage_Previous , Servername / salesforce backups .
08:00:36: DBAmp is using the SQL Native Client.
08:00:36: Opening SQL Server rowset
08:50:37: Error: RunQuery failed with com_error.
08:50:37: FAHttp::Send::WinHttpReceiveResponse
Win32Error::
The operation timed out

08:50:37: Error: DBAmp.exe was unsuccessful.
08:50:37: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "EmailMessage_Previous" "Servername" "salesforce backups" "SALESFORCE_RP_PROD"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 244
--- Ending SF_Replicate. Operation FAILED.
1 person has
this problem
+1
Reply
  • One possible cause of this is the use of web inspection boxes at the network layer that are struggling with the large messages returned by this query.

    Try reducing the batch size of the replicate:

    exec sf_replicate 'SALESFORCE_RP_PROD','EmailMessage','batchsize(10)'
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • With batchsize(10), this is the error message I received. And also the firewall is disabled at the server so nothing is stopping access to the internet.

    --- Starting SF_Replicate for EmailMessage
    00:09:28: Drop EmailMessage_Previous if it exists.
    00:09:28: Create EmailMessage_Previous with new structure.
    00:09:30: Run the DBAmp.exe program.
    00:09:30: DBAmp Bulk Operations. V2.17.8 (c) Copyright 2006-2013 forceAmp.com LLC
    00:09:30: Populating local table EmailMessage_Previous , servername / salesforce backups .
    00:09:30: Batch size reset to 10 rows per batch.
    00:09:30: DBAmp is using the SQL Native Client.
    00:09:30: Opening SQL Server rowset
    00:59:31: Error: RunQuery failed with com_error.
    00:59:31: FAHttp::Send::WinHttpReceiveResponse
    Win32Error::
    The operation timed out

    00:59:31: Error: DBAmp.exe was unsuccessful.
    00:59:31: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export:batchsize(10) "EmailMessage_Previous" "servername" "salesforce backups" "SALESFORCE_RP_PROD"
    --- Ending SF_Replicate. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 244
    --- Ending SF_Replicate. Operation FAILED.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited