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

Errors - what is the minum permissions for a DBAmp user to pull all object data.


We are using DBAmp for pulling data only; therefore, we need to remove admin access as much as possible. I created a integration profile with only API access and a perm set with only VIEW ALL - READ ONLY access to all objects. I am seeing different errors in the DBAmp logs such as below. Are there specific system permissions that need to be given to a DBAmp user and if so what would I have to turn on?

Or could this be an issue with the Spring '20 as I have not run DBAmp in on our DBAmp test server since last SF release.

Or something else?

I am on DBAmp version

--- Starting SF_Replicate for BackgroundOperationResult V3.7.2 [SQLSTATE 01000]
08:57:15: Parameters: SF_CD_LINK_SERVER BackgroundOperationResult Version: V3.7.2 [SQLSTATE 01000]
08:57:15: Drop BackgroundOperationResult_Previous20200130T085715160 if it exists. [SQLSTATE 01000]
08:57:15: Create BackgroundOperationResult_Previous20200130T085715160 with new structure. [SQLSTATE 01000]
08:57:15: DBAmpNet2 (c) Copyright 2015-2017 LLC [SQLSTATE 01000]
08:57:15: Parameters: replicate BackgroundOperationResult_Previous20200130T085715160 SV-DBAMP-T1 SF_CD_BKUP SF_CD_LINK_SERVER [SQLSTATE 01000]
08:57:16: Error System.Web.Services.Protocols.SoapException: BIG_OBJECT_UNSUPPORTED_OPERATION: You must have a single WHERE clause with a single ParentId filter. [SQLSTATE 01000]
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) [SQLSTATE 01000]
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) [SQLSTATE 01000]
at DBAmpNet2.sforce.SforceService.query(String queryString) [SQLSTATE 01000]
at DBAmpNet2.SFDataLayer3.QuerySF() [SQLSTATE 01000]
08:57:16: DBAmpNet2 Operation FAILED. [SQLSTATE 01000]
08:57:18: Error: Replicate program was unsuccessful. [SQLSTATE 01000]
08:57:18: Error: Command string is E:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "BackgroundOperationResult_Previous20200130T085715160" "SV-DBAMP-T1" "SF_CD_BKUP" "SF_CD_LINK_SERVER" [SQLSTATE 01000]
--- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
Error: SF_Replicate failed for table BackgroundOperationResult [SQLSTATE 01000]
Error 50000, Severity 16, State 1, Line 383 [SQLSTATE 01000]
--- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

1 person has
this question