topic QMC dont reload a report in QlikView

QMC dont reload a report

Mon, 26 Jan 2026 18:19:17 GMT

Hi, i need to reload a report using data from a outside network, i make the vpn conection with hamachi from logmein, i have the access and i can reload the report from desktop app, but when i program the task to reload the report it fails, i open the ports inbound and outbound in the two server, but i still have the problem

TKS

Re: QMC dont reload a report

bnichol — Sun, 28 Feb 2016 15:23:32 GMT

Hi Victor,

Please let me paraphrase what I'm reading, to avoid confusion. You are successfully reloading a document using QV desktop client, but when you reload using the distribution service (QDS) it fails.

What's the error message you are getting in the QVW.log?

What part of the process fails?

The report you've identified, is it a screen object, a QV report or an extract using macros/script?

If it's a scripted item started by an afterReload trigger, this will fail because the distribution service doesn't launch these triggers.

Does the service account running the QDS have the same permission as the user running the desktop app? Are they the same UID?

Regards,

Re: QMC dont reload a report

Peter_Cammaert — Sun, 28 Feb 2016 23:14:07 GMT

Most VPN connections started from a user session are for that particular user session only. You'll have to either let the VPN connection be created by the server itself as a system wide network interface, or configure some network hardware to make the conneciton upon request

QlikView services run as background services that are totally ignorant of the things you do in your desktop session.

Best,

Peter

Re: QMC dont reload a report

Mon, 29 Feb 2016 15:51:00 GMT

Hi, Brent, i send the error, to eliminate options i test just with a select * from, but i have the same error, the desktop and the QMC are in the same server.

The DB is on a diferent server, i make a vpn with hamachi (logmein), and i open all the ports on both modems, i make a test with the firewalls disable.

0015 ODBC CONNECT32*

SQL SELECT *

FROM histhues

Error: SQL##f - SqlState: S0002, ErrorCode: 173, ErrorMsg: [Microsoft][ODBC Visual FoxPro Driver]File 'histhues.dbf' does not exist.

General Script Error

Execution Failed

Execution finished.

tks

Re: QMC dont reload a report

Mon, 29 Feb 2016 15:55:58 GMT

I will try to make a test with some hardware, is my last option, becouse i dont want to make a daily copy of the DB to other server and do the reload localy.

TKS

Re: QMC dont reload a report

Colin-Albert — Mon, 29 Feb 2016 16:16:59 GMT

The reload from the QMC will be running as the QDS service account so will not have access to any vpn configured on your account. Also the service will be running is session 0 so may not be able to access user based vpn connections in a similar way that drive mappings are not available to session zero.

Can you generate a file of the daily data that can be accessed via ftp and then loaded onto QlikView?

Re: QMC dont reload a report

Wed, 02 Mar 2016 22:58:21 GMT

Hi, i make an example giving permission to everybody with all access and i have the same problem, i dont have restriction on the file.

TKS