Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Hi Prathap,

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi Prathap,

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

Anonymous
Not applicable
Author

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