QvSource mongodb connector not work

Fri, 11 Dec 2015 07:51:23 GMT

hello,

I am using QvSource mongodb connector web edition, I can preview the data successfully in QVSource. I get the following script and pasted it into Edit Script dialog of QlikView.

MongoDBConnectorV2_Collection:
LOAD
    _id as Collection_id,
    Company as CollectionCompany,
    [Company Code] as [CollectionCompany Code],
    EmployeeCount as CollectionEmployeeCount,
    profile as Collectionprofile,
    subs as Collectionsubs
FROM
[http://localhost:5555/QVSource/MongoDBConnectorV2/?table=Collection&server=localhost&port=27017&database=QlikViewTest&collection=HierarchyDocuments&maxRows=20&appId=]
(qvx);
// IMPORTANT: If, when loading the above script, you receive a 'Script Error' Dialog box with a 'Field Not Found'
// (or other) error, the first thing you should do is copy and paste the full request URL (i.e. the URL between the square [...]
// brackets IN THE QLIKVIEW / QLIK SENSE SCRIPT ERROR DIALOG) into a browser address bar and check the response.

There is no error pop up and there is no error logs created.

I tried to access the data source Url in IE directly, and can get the data. please see the attachment for the data.

but when I open Table Viewer in QlikView, there is nothing show.

and when I run chart wizard, there is no dimension show.

Does anyone know why the Tableview is blank and there is no dimension available? thanks for your help.

Re: QvSource mongodb connector not work

chrisbrain — Sat, 12 Dec 2015 09:25:37 GMT

Can you confirm you reloaded the QlikView application after you pasted in the generated load script?

topic Re: QvSource mongodb connector not work in QlikView

QvSource mongodb connector not work

Re: QvSource mongodb connector not work