Error Message: No such column 'contractid' on entity 'Opportunity'.

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.

      • Related Articles

      • 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 ...

      • 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: "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: Could not create a managed connection manager

        Action: While using Oracle Destination, the following error message was encountered.:  Error Message: 'Could not create a managed connection manager' Solution: Most probably the required Oracle ODAC package is not installed on the machine where it ...