topic Re: Can't Reload the QVW on Server in QlikView

Can't Reload the QVW on Server

Mon, 15 Dec 2014 09:16:19 GMT

Hi All,

I am not able to reload the qvw using Qlikview Server/Publisher, all the services are up and running. Attaching the log file. Any help would be much appreciated.

Thanks,

Neha

Re: Can't Reload the QVW on Server

rajeshvaswani77 — Mon, 15 Dec 2014 09:23:46 GMT

Hi Neha,

Can you uncheck reload and run, to check if it runs?

Also does this reload without any errors when you do it directly with the QVW file?

thanks,

Rajesh Vaswani

Re: Can't Reload the QVW on Server

saumyashah90 — Mon, 15 Dec 2014 09:25:01 GMT

Have you tried it through qvworkbench?
if not try it once on qvowrkbench.

Re: Can't Reload the QVW on Server

Anonymous — Mon, 15 Dec 2014 09:26:05 GMT

Just check whether you have any static path references.If yes change that to relative paths.

It should work,if not send me the log file again

Re: Can't Reload the QVW on Server

saumyashah90 — Mon, 15 Dec 2014 09:35:35 GMT

Try it three ways.

1)Locally run the application

2)On Qvworkbench

3)On Publisher(Check the Paths if it has changed.)

Re: Can't Reload the QVW on Server

ashfaq_haseeb — Mon, 15 Dec 2014 09:36:11 GMT

Hi,

Make sure you have enough ram on server..

Regards

ASHFAQ

Re: Can't Reload the QVW on Server

Mon, 15 Dec 2014 09:57:36 GMT

Hi Rajesh,

Yes its running successfully in local.

Thanks,

Neha

Re: Can't Reload the QVW on Server

Mon, 15 Dec 2014 10:00:08 GMT

Hi Ashfaq,

I guess it's there because that is in Log file I attached in original post. Please check, I think that should not be the issue.

Thanks,

Neha

Re: Can't Reload the QVW on Server

rajeshvaswani77 — Mon, 15 Dec 2014 10:01:07 GMT

Hi Neha,

Can you delete and recreate the task, then retry?

thanks,

Rajesh Vaswani

Re: Can't Reload the QVW on Server

ashfaq_haseeb — Mon, 15 Dec 2014 10:01:44 GMT

from Log I see that you are running out of ram.

Regards

ASHFAQ

Re: Can't Reload the QVW on Server

Peter_Cammaert — Mon, 15 Dec 2014 10:04:59 GMT

In your document, go to Settings->Document Properties->General and enable "Generate log file". Rerun the task and check the file DocumentLog.txt.

Your script probably doesn't work well on the server. The TaskLog.txt itself is useless for debugging script errors...

Peter

Re: Can't Reload the QVW on Server

Mon, 15 Dec 2014 16:01:27 GMT

Hi Guys,

When I run the QVW locally it runs fine but when I run it using QMEC, the task fails. The underlying database in Microsoft ACCESS Db . Below mentioned is connection string and error log of qvw

I tried to google the error, it says that connection should be "System DSN" not "User DSN" but I am not sure how to add MS ACCESS DB as System DSN.

Connection String -

Let vdb='C:\ProgramData\QlikTech\Documents\Project\Database';

ODBC CONNECT32 TO [MS Access Database;DBQ=$(vdb)\QWT.mdb];

Error in LOG FILE -

12/15/2014 8:49:14 PM: 0026 ODBC CONNECT32*

12/15/2014 8:49:14 PM: Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

12/15/2014 8:49:14 PM: General Script Error

12/15/2014 8:49:14 PM: Execution Failed

12/15/2014 8:49:14 PM: Execution finished.

Thanks,

Neha

Re: Can't Reload the QVW on Server

rajeshvaswani77 — Tue, 16 Dec 2014 02:24:53 GMT

Hi Neha,

Go to control panel, lookup odbc, choose setup data sources(ODBC), go under system DSN tab. Click Add, choose microsoft access driver OR jet oledb driver. say next choose the path of database (do not put in program files, it should be in non system folders) Test conection should show success. The same DSN name now use in the connection string.

This should work.

thanks,

Rajesh Vaswani

Re: Can't Reload the QVW on Server

Tue, 16 Dec 2014 11:37:17 GMT

Hi Rajesh,

I can't find Microsoft Access/JET OLEDB drivers, only Vertica,SQL Server is present. Please find below the screenshot

Thanks,

Neha

Re: Can't Reload the QVW on Server

Peter_Cammaert — Tue, 16 Dec 2014 11:46:10 GMT

Maybe there aren't any OLEDB/ODBC drivers for MS Office installed on your server machine. You'll need an SQL-capable driver installed on that machine before you can open an Access DB in this way. The drivers come with Microsoft Office.

If you don't have Microsoft Office on your server, you can download just the drivers from this place beyond the mountains: Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center

Good luck,

Peter

Re: Can't Reload the QVW on Server

rajeshvaswani77 — Thu, 18 Dec 2014 05:53:30 GMT

Neha,

Did you click on Add?

thanks,

Rajesh Vaswani