Error Message: Invalid Batch: type is not needed for non polymorphic foreign key references: <Relationship Field>
Action:
When I am executing a package that includes Salesforce Destination component in bulk mode I get the following error message:
Error Message:
Invalid Batch: type is not needed for non polymorphic foreign key references: <Relationship Field>
Solution:
It's possible your configuration is inaccurate. To solve the issue you should remove the ReferenceType property specified : <Object> and try to process the package again.Go to http://cozyroc.com/ssis/salesforce-destination and find "Upsert with external ID" demo video. You should follow the instructions from the video to configure your Salesforce Destination component.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Setting up Salesforce Bulk Mode with COZYROC Script Salesforce Bulk Result Transformation
When using COZYROC Salesforce components in Bulk Mode the operations are asynchronous, meaning the results are not immediately available. If needed, the status, identifiers of newly created records, and any error information can be retrieved in an ...Error Message: Invalid Server Host (Salesforce Connection)
Action: When using the Salesforce Connection I am getting the error message below: Error Message: "Invalid Server Host" Solution: Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated ...Why is the batch size in my Salesforce bulk data load different than the batch size I set?
Scenario: We are doing bulk data load to Salesforce and the default size which we have set is 10000 but when i look at the Salesforce the number of records are processing per batch is 112 records Here is the Salesforce destination configuration Can ...An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP".
Action: When executing an SSIS package containing an ODBC Destination, the following error message occurred. Error Message: An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP". ...Why am I unable to see a lookup field that is newly added in Salesforce?
Scenario: The Salesforce Admin created some new fields in an object, but a lookup field is still not showing in the Salesforce Source or Destination component. Solution: It may be that your Salesforce Admin created the field but did not properly set ...