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

UserProfileFeed queries must include a 'WITH UserId = user-id' clause

Hello All,

I'm trying to replicate the UserProfileFeed SFDC object using the below statement. However, I'm getting the following error: "UserProfileFeed queries must include a 'WITH UserId = user-id' clause". The complete message is at the bottom.

I am able to use the same statement with a different SFDC object name such as 'Account' which runs without error. I've searched the documentation for DBAmp as well as the support forum but couldn't find much of any info on this error.

Anyone experience this before? What is the workaround?

Statement that returns error:
exec sf_replicate 'DevLS', 'UserProfileFeed'

--- Starting SF_Replicate for UserProfileFeed
14:50:16: Drop UserProfileFeed_Previous if it exists.
14:50:16: Create UserProfileFeed_Previous with new structure.
14:50:16: Run the DBAmp.exe program.
14:50:16: DBAmp Bulk Operations. V2.14.3 (c) Copyright 2006-2012 forceAmp.com LLC
14:50:16: Populating local table UserProfileFeed_Previous , DevServer / DevDB .
14:50:17: DBAmp is using the SQL Native Client.
14:50:17: Opening SQL Server rowset
14:50:17: Error: RunQuery failed with com_error.
14:50:17: MALFORMED_QUERY: UserProfileFeed queries must include a 'WITH UserId = user-id' clause
14:50:17: Error: DBAmp.exe was unsuccessful.
14:50:17: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "UserProfileFeed_Previous" "DevServer" "DevDB" "DevLS"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 198
--- Ending SF_Replicate. Operation FAILED.
1 person has
this problem
+1
Reply