Qlik Community

QlikView Connector for Salesforce

Discussion Board for collaboration related to the QlikView Connector for Salesforce.

Not applicable

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

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

1 Solution

Accepted Solutions
awqvuser
Contributor

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

Hi Prathap,

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

2 Replies
awqvuser
Contributor

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

Hi Prathap,

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

rammohan7
New Contributor

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

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

Community Browser