Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview - QVSource FTP connection issue....!

Hi All,

QlikView is not reading data through qvsource service from SFTP....!

whenever I run the generate loadscript in qvsource it is running fine (status OK and I can see that files are reading while generating load script) but whenever i copied the load script to qlikview it says <Status> field not found.

I checked all the services QVSource and QlikView services all are running fine and I tried by restarting all the services, still unsuccessful?

Every reload in qlikview pop up with an error fieldnot found. I rechecked, recopied load script, using the SFTP connection string as it is from qvsource. Using 1.4.9.5 version it is not the very latest one. It was working fine for last 6 months.

Please give me any suggestions!

1 Solution

Accepted Solutions
chrisbrain
Partner - Specialist II
Partner - Specialist II

Could you rename any instances of the table name

SFTPDownloadFile

to

SFTPDownload

And:

FTPDownloadFile

to

FTPDownload


We changed this in version 1.0.1 of the connector, the old name should have been automatically mapped but wasn't (this has now been fixed).

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense

View solution in original post

5 Replies
chrisbrain
Partner - Specialist II
Partner - Specialist II

Whenever you get this 'field not found' error while your load script runs the first step is always to copy the WVSource request URL between the [...] brackets (it will probably start http://localhost:5555/QVSource/....] into a browser window address bar and run it, you should get a more helpful error message back. A typical reason is an expired licence but it could be something else.

Please see if this helps, I would also strongly recommend upgrading to the latest QVSource, we released an important update this week which fixes an SSL issue which may be affecting you.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Not applicable
Author

Chris,

Thanks for the replay, here is error msg "Error requesting table SFTPDownloadFile for FileTransferConnector". Could you please explain me what the msg is about?

Licence is still valid.

We planned for up gradation but postponed because of some internal reasons.

Thanks,

Santosh

chrisbrain
Partner - Specialist II
Partner - Specialist II

Could you rename any instances of the table name

SFTPDownloadFile

to

SFTPDownload

And:

FTPDownloadFile

to

FTPDownload


We changed this in version 1.0.1 of the connector, the old name should have been automatically mapped but wasn't (this has now been fixed).

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Not applicable
Author

Excellent! It's worked. Thanks Chris.

Sincerely,

Santosh

chrisbrain
Partner - Specialist II
Partner - Specialist II

Great

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense