topic Re: Issue on Data Type's after Upgrating the QlikSalesforceConnector.exe Version 13.1.0. in QlikView

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

Mon, 26 Jan 2026 21:26:37 GMT

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)]

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

Anonymous — Thu, 08 Sep 2016 15:08:39 GMT

Hi Prathap,

If you're not doing convertcurrency, but just pulling the fields as-is, does it work?

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

Anonymous — Wed, 13 Dec 2017 06:35:19 GMT

yes its working if we just pulling the fields as-is,,

Issue is only when we use convertcurrency

getting below error while loading

Unable to get column information for the fields that are used in the query. Please make sure you have only one SELECT statement in a query editor. Description: Length cannot be less than zero.

Parameter name: length

SQL SELECT

Opportunity_ID__c,

Win_Loss_Reason__c,

[convertCurrency(Amount)],

[convertCurrency(Tier_1_Opportunity_Value__c)]

FROM Opportunity