Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m sad

Refresh and Replicate operations now fail on the IdeaComment object

Upon upgrading from DBAmp 2.15.1 to 2.17.6, we have found that calls to SF_Refresh and SF_Replicate no longer work for the IdeaComment object. The error we are receiving is:

--- Starting SF_Replicate for ideacomment
12:38:33: Drop ideacomment_Previous if it exists.
12:38:33: Create ideacomment_Previous with new structure.
12:38:34: Run the DBAmp.exe program.
12:38:34: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 LLC
12:38:34: Populating local table ideacomment_Previous , [SERVERNAME] / [DBNAME] .
12:38:35: DBAmp is using the SQL Native Client.
12:38:35: Opening SQL Server rowset
12:38:35: Error: RunQuery failed with com_error.
12:38:35: MALFORMED_QUERY: Implementation restriction. When querying the Idea Comment object, you must filter using the following syntax: CommunityId = [single ID], Id = [single ID], IdeaId = [single ID], Id IN [list of IDs], or IdeaId IN [list of IDs].
12:38:35: Error: DBAmp.exe was unsuccessful.
12:38:35: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "ideacomment_Previous" "[SERVERNAME]" "[DBNAME]" "[LINKEDSERVERNAME]"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 286
--- Ending SF_Replicate. Operation FAILED.

I noticed that this object has been dropped from the *All stored procedures due to the new SFDC API restriction on querying it. Does this mean that the standard DBAmp Refresh and Replicate SPs no longer support this object? I would have expected a note of some kind in the Readme, if so.

Matt Coles
1 person has
this problem