I am currently in the process of working on a replication application to pull data down from Salesforce via the Bulk API and push data into an Enterprise Data Warehouse. The schema is pulled for objects first and then the tables are populated. Currently I am running into an issue on both the ObjectPermissions and FieldPermissions objects as the field SObjectType is defined with a length of 40 characters. However, it seems that this is a soft length when used in conjunction with a namespace. We currently have BMC Remedyforce installed and they have created the following table: BMCServiceDesk__CommunicationEndpoint__c which is greater than 40 characters with the namespace and less than 40 characters without the namespace.
I have a couple of questions:
- Has anyone seen this before and come up with a workaround for defining a schema where the length does not represent a hard limit?
- Is there any documentation to support that this is expected behaviour?