1 Reply Latest reply: Sep 8, 2016 11:08 AM by Anton Wibowo RSS

    Issue on Data Type's  after Upgrating the QlikSalesforceConnector.exe Version 13.1.0.

    prathap kakarla

      I am trying to loading Opportunity object from salesforce  where the fields will be

      Salesforce Object Field's:

      select

      Opportunity_ID__c,

      Win_Loss_Reason__c,

      Amount,

      Tier_1_Opportunity_Value__c

      FROM Opportunity

       

      Script in Qlikview:

      CUSTOM CONNECT*Provider*QlikSalesforceConnector.exe*XUserId*XPassword*

      LET vAuditStartTime = Now(1);

       

      Opportunities:

      Load Opportunity_ID__c,

      Win_Loss_Reason__c,

      Amount as converted1,

      Tier_1_Opportunity_Value__c as converted ;

      SQL SELECT

      Opportunity_ID__c,

      Win_Loss_Reason__c,

      [convertcurrency(Amount)],

      [convertcurrency(Tier_1_Opportunity_Value__c)]

      FROM Opportunity ;

       

      Earlier i am using salesforce connector 11.0.1  and i have no issue  but now getting the ERROR

       

      Error: Unable to get column information for the fields that are used in the query: Length cannot be less than zero.

      Parameter name: length

      General Script Error

      Execution Failed

       

      I think Data Type's are not Supported to QlikSalesforceConnector.exe Version 13.1.0..Please any one help on this?

      Example:

      [convertcurrency(Amount)],

      [convertcurrency(Tier_1_Opportunity_Value__c)]