# DBAmp - Mirror of data fails when object has a lower case character after initial double underscore \_\_

**URL:** <https://community.cdata.com/t/dbamp-mirror-of-data-fails-when-object-has-a-lower-case-character-after-initial-double-underscore/782>\
**Category:** CData DBAmp\
**Tags:** question, salesforce, bug\
**Created:** [June 12, 2024, 10:46am UTC](https://community.cdata.com/t/dbamp-mirror-of-data-fails-when-object-has-a-lower-case-character-after-initial-double-underscore/782 "2024-06-12T10:46:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alastair\_Bacon](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@Alastair\_Bacon](https://community.cdata.com/u/Alastair_Bacon)\
**Post date:** [June 12, 2024, 10:46am UTC](https://community.cdata.com/t/dbamp-mirror-of-data-fails-when-object-has-a-lower-case-character-after-initial-double-underscore/782/1 "2024-06-12T10:46:48Z")

</div>

When trying to mirror a salesforce object using the following:

EXEC SF\_Mirror ‘SFPROD’, ‘c2g\_\_codaBankAccount\_\_c’;

I get a failure as follow:

--- Starting SF\_Mirror for c2g\_\_codaBankAccount\_\_c V8774  
11:34:52: Parameters: SFPROD c2g\_\_codaBankAccount\_\_c &nbsp;Version: V8774  
11:34:52: Running DBAmpAZ.exe.  
11:34:52: DBAmpAZ 22.0.8775.0 Copyright © 2023 CData Software, Inc.  
11:34:52: Obtaining Connection Props  
11:34:52: Obtaining User Information  
11:34:53: Using settings from Registry.  
11:34:53: Retrying describeSObject call to Salesforce.  
11:34:53: Retrying describeSObject call to Salesforce.  
11:34:53: Retrying describeSObject call to Salesforce.  
11:34:53: System.Web.Services.Protocols.SoapException: INVALID\_TYPE: sObject type ‘c2g\_\_c’ is not supported. If you are attempting to use a custom object, be sure to append the ‘\_\_c’ after the entity name. Please reference your WSDL or the describe call f  
or the appropriate names.  
&nbsp; &nbsp;at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)  
&nbsp; &nbsp;at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)  
&nbsp; &nbsp;at DBAmpAZ.sforce.SforceService.describeSObject(String sObjectType)  
&nbsp; &nbsp;at afo220A.ER.Q(String , Boolean& )  
11:34:53: DBAmpAZ Operation FAILED.  
11:34:53: Error: MirrorCopy program was unsuccessful.  
11:34:53: Error: Command string is C:\“Program Files”\CData\“CData DBAmp”\bin\DBAmpAZ.exe MirrorCopy “c2g\_\_codaBankAccount\_\_c” &nbsp;“aagaz1polsql01” &nbsp;“SF\_Extract” &nbsp;“SFPROD” &nbsp;“”&nbsp;  
--- Ending SF\_Mirror. Operation FAILED.  
Msg 50000, Level 16, State 1, Procedure SF\_Mirror, Line 283 [Batch Start Line 18]  
--- Ending SF\_Mirror. Operation FAILED.

Permissions aren’t an issue as I can use the following to get the actual data from a query:

select \* from SFPROD.CData.Salesforce.c2g\_\_CodaBankAccount\_\_c;

I can also run SF\_Mirror for other objects which have the same prefix e.g.

EXEC SF\_Mirror ‘SFPROD’, ‘c2g\_\_Reminder\_\_c’;

The only thing I can put this down to is the failing versions have a lower case character after the initial c2g\_\_&nbsp; which leads to the stored procedure failing to find the object name as it seems to always use:&nbsp;&nbsp;‘c2g\_\_c’

Has anyone else seen this?

Thanks for any guidance in getting around this.

Alastair

---

<div class="post-metadata">

**Author:** ![Alastair\_Bacon](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@Alastair\_Bacon](https://community.cdata.com/u/Alastair_Bacon)\
**Post date:** [June 13, 2024, 3:48pm UTC](https://community.cdata.com/t/dbamp-mirror-of-data-fails-when-object-has-a-lower-case-character-after-initial-double-underscore/782/2 "2024-06-13T15:48:52Z")

</div>

As an update to this, there is a fix to a known issue where the tables are in a managed package. Issue was occuring in 22.0.0.0 Build 8775. The download of the fix which is version 22.0.0.0 build 8924&nbsp;is available from support.