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

RefreshIAD failing for Account

Our usual refresh job is failing since moving to a different server but it has only started failing on Account:

--- Starting SF_RefreshIAD for Account V3.6.3
14:37:32: Using Schema Error Action of yes
14:37:32: Local table does not exist. Using SF_ReplicateIAD to create the local table.
--- Starting SF_ReplicateIAD for Account V3.6.3
14:37:32: Parameters: DEHSALESFORCE Account Version: V3.6.3
14:37:32: DBAmpNet2 is being used with queryAll.
14:37:32: Drop Account_Previous if it exists.
14:37:32: Drop Account_DeleteIAD if it exists.
14:37:32: Create Account_Previous with new structure.
14:37:33: Run the DBAmpNet2.exe program.
14:37:33: DBAmpNet2 (c) Copyright 2015-2017 LLC
14:37:33: Error: Invalid operation.
14:37:33: DBAmpNet2 Operation FAILED.
14:37:33: Error: DBAmp.exe was unsuccessful.
14:37:33: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate:queryall" "Account_Previous" "FRLN1PAOAG14" "SalesforceDEH" "DEHSALESFORCE"
--- Ending SF_ReplicateIAD. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_ReplicateIAD, Line 544
--- Ending SF_ReplicateIAD. Operation FAILED.

Event, Task, Opportunity all refreshIAD fine but Account seems to be at a sticking point. I've dropped all the tables relating to Account so the proc can create it's own but it still fails a this point.

Please can you advise?

1 person has
this question