Error Message: No such column 'contractid' on entity 'Opportunity'.
Action:
When executing an SSIS package containing a COZYROC task and/or component, the following error is encountered.
Error Message:
No such column 'contractid' on entity 'Opportunity'.
Solutions:
By default Contract field on Opportunity is hidden from all profiles. In order to make the field visible to the profile, You have to Set Field Level Security. Here is a link in How-To make the contract ID visible.
If you have already performed this step, verify the SOAP API version that you have set for the Server URL (optional) on the Advanced tab. The ContractID field on the Opportunity object is not available in API version 20. It is available in API version 35.0 and later.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
Missing objects or columns when using Salesforce Destination Component
Most likely the reason for object or column to be missing is that you are using older version of Salesforce API. To verify which version of Salesforce API you are using please check what is showing in the Server URL field on the Salesforce Connection ...Error Message: Salesforce Connection Manager: The operation has timed out.
Action: When manually executing SSIS+ package that includes Salesforce Connection Manager component I don't get any errors. But when I execute the package via SQL Server Agent I get the following error message: Error Message: The operation has timed ...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 ...Error Message: "Failed to process ... for column COLUMN_NAME"
Action: The Salesforce object I am using has new columns and I am trying to add the new columns and map them to our destination table. When I execute the package I get the following error: Error Message: "Failed to process ...