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
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 ...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 ...Error Message: An existing connection was forcibly closed by the remote host
Action When making a request to a service connection, the following error message was returned. Error Message Error Message: An existing connection was forcibly closed by the remote host Solution The error message can be somewhat generic across ...