Using QlikView 10SR2 and the most current SalesForce connector. Running Publisher on a x64 server.
I have a simple extract file that selects records from a couple of Salesforce tables and creates QVDs. The file works fine from my desktop, and also runs fine when run from the QlikView desktop on the server where publisher is installed. However, when run as a publisher job, although it does not error or abend, it simply pulls 0 records. So it seems to connect fine and the SELECT statements are fine, but nothing is retrieved.
I've re-installed the connector, played with proxy settings, restarted services, restarted the server, all without success. Oddly, I tried to re-create the connection string along the way, and it actually ran ONCE from Publisher, but only that one time. All other attempts have failed.
When run from my workstation or from the Publisher/Server but using QlikView desktop, the log output is as follows:
0020 CUSTOM CONNECT*Provider*SalesForceDLL.dll*XUserId*XPassword*
0023 Portfolio:
0024 SQL SELECT *
0025 FROM Portfolio__c
237 fields found: Id, IsDeleted, Name, RecordTypeId, [etc... omitted to simplify post], 603 lines fetched
0027 STORE * FROM Portfolio INTO ..\Datasources\QVD\Salesforce\Portfolio.qvd (qvd)
0029 DROP TABLE Portfolio
0031 Account:
0032 SQL SELECT *
0033 FROM Account
334 fields found: Id, IsDeleted, MasterRecordId, Name, [etc... omitted to simplify post], 1,774 lines fetched
0035 STORE * FROM Account INTO ..\Datasources\QVD\Salesforce\Account.qvd (qvd)
0037 DROP TABLE Account
0039 exit script
Execution finished.
However, when run from Publisher, this same file generates a lot like the following, and retrieves no records:
0020 CUSTOM CONNECT*Provider*SalesForceDLL.dll*XUserId*XPassword*
0023 Portfolio:
0024 SQL SELECT *
0025 FROM Portfolio__c
1 fields found: *, 0 lines fetched
0027 STORE * FROM Portfolio INTO ..\Datasources\QVD\Salesforce\Portfolio.qvd (qvd)
0029 DROP TABLE Portfolio
0031 Account:
0032 SQL SELECT *
0033 FROM Account
1 fields found: *, 0 lines fetched
0035 STORE * FROM Account INTO ..\Datasources\QVD\Salesforce\Account.qvd (qvd)
0037 DROP TABLE Account
0039 exit script
Execution finished.
I've also tried using specific columns in the SELECT rather than the * wildcard, but no joy.
Any ideas from folks using Salesforce in a Server/Publisher environment? Thanks so much for any inputs or suggestions.
