topic Re: Reload problem in QlikView

Reload problem

Tue, 26 Jul 2011 15:54:54 GMT

Hi Experts,

We are getting this error message when we try to reload the qlik file by the reload server. Any help is appreciated.

Thanks,

Nima

7/26/2011 11:13:09 AM Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QLIKVIEW.FOLDERS\TEST\siq-sales.qvw.

7/26/2011 11:13:09 AM Error Reload failed.

7/26/2011 11:13:09 AM Error Reload failed. Distribution skipped.

7/26/2011 11:13:09 AM Error The task "test/siq-sales.qvw" failed. ErrorCount=3

Reload problem

erichshiino — Tue, 26 Jul 2011 16:31:56 GMT

Hi,

Is it the log from the server? If it is, you can get more details if you enable (and check) the log generated by the file itself.

You can enable it in settings-> Document properties -> Generate log file.

During reload, a file with the same name, but with the extension .log will be generated in the same folder of the application.

Hope this helps,

Erich

Reload problem

Tue, 26 Jul 2011 17:01:10 GMT

Hello Erich,

Thanks for the reply. Here you are the log file you said:

2011-07-26 12:59:37: Execution started.

2011-07-26 12:59:37: QlikView Version:10.00.8935.7

2011-07-26 12:59:37: 0002 SET ThousandSep=','

2011-07-26 12:59:37: 0003 SET DecimalSep='.'

2011-07-26 12:59:37: 0004 SET MoneyThousandSep=','

2011-07-26 12:59:37: 0005 SET MoneyDecimalSep='.'

2011-07-26 12:59:37: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

2011-07-26 12:59:37: 0007 SET TimeFormat='hh:mm:ss'

2011-07-26 12:59:37: 0008 SET DateFormat='YYYY-MM-DD'

2011-07-26 12:59:37: 0009 SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]'

2011-07-26 12:59:37: 0010 SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.'

2011-07-26 12:59:37: 0011 SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.'

2011-07-26 12:59:37: 0014 ODBC CONNECT*

2011-07-26 12:59:37: Error: SQL##f - SqlState: S1009, ErrorCode: 4294966273, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

2011-07-26 12:59:37: General Script Error

2011-07-26 12:59:37: Execution Failed

2011-07-26 12:59:37: Execution finished.

Thanks,

Nima

Reload problem

erichshiino — Tue, 26 Jul 2011 17:04:49 GMT

Does it work when you reload it in your machine (not in the server)

Does the ODBC connection exist on the server?

Is the connection on the server a system DNS or user DNS (if it is a user DNS, it will not be availabe to other users and the server can be running on a different account).

Is it a different environment? (32 x 64 bit). If you change the environment you may need different drivers and different connection strings.

Re: Reload problem

Tue, 26 Jul 2011 17:39:36 GMT

We found the solution: I did not have access to the folder that report was saved.

Thanks for your help