Missing Columns when exported to SQL using ODBC Driver

Posted by p_shashidhar on 14-Aug-2015 14:04

After export we noticed few fields are missing on Opportunity Line Items & Quote Line Items.

ProductId is missing on Quote Line Items & ProductCode is missing on Opportunity Line Items. Is there any configuration option we have specify in order to get all the columns.

Here is our current configuration.

AuditColumns=All;MapSystemColumnNames=0;CustomSuffix=Include;PersistMetadata=true;

All Replies

Posted by Rashmi Gupta on 17-Aug-2015 13:12

I did not find a ProductId field in the QuoteLineItems object in Salesforce. Did you mean Product2ID instead?

What is the exact Salesforce ODBC driver version and sforce.jar version (knowledgebase.progress.com/.../000044116) that you are using?

Regards,

Rashmi

Posted by p_shashidhar on 17-Aug-2015 13:42

Yes i am referring to Product2ID and here the driver information.

[DataDirect][SForce JDBC Driver]Driver Version: 5.1.3.000116(C0131.F000153.U000068)

Posted by Rashmi Gupta on 17-Aug-2015 13:49

Can you provide the exact DataDirect Salesforce ODBC driver version (xxsfrcnn.dll)

- Right click on the driver dll

- Select Properties

- Navigate to the Details or Version tab and the File version should be listed there

Posted by p_shashidhar on 17-Aug-2015 14:03

I am unable to find xxsfrcnn.dll in my machine. is it the same file i should be looking for?

Posted by Rashmi Gupta on 17-Aug-2015 14:08

If you are using the Connect64 for ODBC 7.1 64-bit Salesforce driver, the file name will be ddsrfc27.dll otherwise, the 32-bit dll will be ivsfrc27.dll.

The dll will be located in the {ODBC_install_dir}/Drivers folder.

Posted by p_shashidhar on 17-Aug-2015 14:14

Thanks I found it. Here is the version 7.10.4.113

Posted by Rashmi Gupta on 17-Aug-2015 14:21

The driver and sforce.jar version you are using support Salesfroce API version 29.

In this version of the Salesforce API, the columns Product2ID for the QuoteLineitem object and the ProductCode for OpportunityLineItem were not available which is why the driver does not show the columns.

These were added in Salesforce API version 30.

developer.salesforce.com/.../sforce_api_objects_quotelineitem.htm

developer.salesforce.com/.../sforce_api_objects_opportunitylineitem.htm

The latest hot fix supports Salesforce API version 33. Please contact Support to request the latest hot fix and test.

Regards,

Rashmi

Posted by p_shashidhar on 17-Aug-2015 17:18

Thanks for clarification after installing the updated version i am able to get the missing columns.

Now the versions shows as below

ivsfrc27.dll file version 7.10.5.169

Driver version: [DataDirect][SForce JDBC Driver]Driver Version: 5.1.4.000132(C0185.F000209.U000089)

Thanks a lot.

This thread is closed