topic Re: Reload task in Qlikview Server in QlikView

Reload task in Qlikview Server

Thu, 02 Feb 2017 00:08:47 GMT

Hello everyone,

I am doing a small project in Qlikview, and I have stopped with the below exception occurred in Reload task of a Qlikview file in the Qlikview Server.

I need your suggestions in trouble shooting the Exception.

Attached the log file for more information.

Exception details :

System.Security.Principal.IdentityNotMappedException, occurred after reloading of the document, while saving the document. Could you

rwunderlich‌ punitpopli‌ have any idea on this.

Thank you.

Re: Reload task in Qlikview Server

punitpopli — Thu, 02 Feb 2017 04:13:56 GMT

Hi,

It seems the account through which you are running the file is not able to read the file on target location.

Can you check reloading the file locally i.e on server using Desktop client.

Let me know if you find out error details.

-Punit

Re: Reload task in Qlikview Server

Thu, 02 Feb 2017 22:23:37 GMT

Hi,

Thanks for the information. Here are the few points

The file is created in my local system (user: me/admin - both are same)

The same file copied into the Qlikview Server using Remote Desktop Connection (user: administrator)

Some part of the job is done, i.e he file is able to connect and reload the data from the other machine, but when it tries to save the document (after reloading), it is getting the exception.

I can't open the file in the Qlikview Server, as I think I don't have Desktop client on server, (Just let me know if I am wrong)

Re: Reload task in Qlikview Server

Thu, 02 Feb 2017 22:23:55 GMT

punitpopli‌

Re: Reload task in Qlikview Server

vishsaggi — Thu, 02 Feb 2017 22:36:40 GMT

What is that you are trying to save from the dashboard after reload? Can you share some more information on how you saving the file (what file is it?) and did you check the path you are trying to save it to?

Re: Reload task in Qlikview Server

Thu, 02 Feb 2017 22:52:10 GMT

Hi vishsaggi‌

As of my knowledge, in the local system using, Qlikview personal addition, if you reload the data in the .qvw file, you should save the same .qvw file, to get your changes done. Otherwise, we will lose changes from reload. and I think it applies to Qlikview Server as well.

I have created a job in the Qlikview Server for this .qvw file, under reload section. and it is able to connect to the other machine, through ODBC driver and fetching data from that database and after completion of reloading process, Qlikview Management Console is trying to save the .qvw file, to persist those reload changes.

Please find the attachment(log file of failed job) in the below link, for more information.

Reload Exception.txt | Slack

Kindly let me know if you need anything else.

Re: Reload task in Qlikview Server

punitpopli — Fri, 03 Feb 2017 04:00:04 GMT

Hi,

The logs which you had shared are the task logs, please share or verify the document logs, this will provide you more detail.

How to enable document logs :

go to document properties (ctl+Alt_D)
On General tab > right side> check in Generate Log File and Timestamp in log file name
reload on server through QMC
Verify the log files on default location (c:\ProgramData\Qliktech\Distribution Service\Logs\1\)

Let me know if this provide you more details which will help to get into the issue.

-Punit

Re: Reload task in Qlikview Server

Fri, 03 Feb 2017 05:06:20 GMT

Hi punitpopli‌

I understood, but in the document log, I didn't find anything wrong. The log contains, it is connected to database, fetched the data from database, number of rows effected etc. I will share you tomorrow, if you need it.

Thanks

Re: Reload task in Qlikview Server

stabben23 — Fri, 03 Feb 2017 06:48:00 GMT

Hi,

Feels like premissions on folders, does the account that runs QDS/QVS services have correct authorization on the folder where you have the qvw-file? Is it only a reload (server) or a reload and distribute(Publisher) to another folder?

Re: Reload task in Qlikview Server

Fri, 03 Feb 2017 15:24:08 GMT

Hi punitpopli‌

Here is the log file content:

2/2/2017 4:10:01 PM: Execution started.

2/2/2017 4:10:01 PM: QlikView Version:11.20.12904.0

2/2/2017 4:10:01 PM: CPU Target x64

2/2/2017 4:10:01 PM: Operating System Windows Server 2012 R2 Standard (64 bit edition)

2/2/2017 4:10:01 PM: Wow64 mode Not using Wow64

2/2/2017 4:10:01 PM: MDAC Version ..............

2/2/2017 4:10:01 PM: MDAC Full Install Version ..............

2/2/2017 4:10:01 PM: PreferredCompression 2

2/2/2017 4:10:01 PM: EnableParallelReload 1

2/2/2017 4:10:01 PM: ParallelizeQvdLoads 1

2/2/2017 4:10:01 PM: AutoSaveAfterReload 0

2/2/2017 4:10:01 PM: BackupBeforeReload 0

2/2/2017 4:10:01 PM: EnableFlushLog 0

2/2/2017 4:10:01 PM: SaveInfoWhenSavingFile 0

2/2/2017 4:10:01 PM: UserLogfileCharset 1200

2/2/2017 4:10:01 PM: OdbcLoginTimeout -1

2/2/2017 4:10:01 PM: OdbcConnectionTimeout -1

2/2/2017 4:10:01 PM: ScriptWantsDbWrite false

2/2/2017 4:10:01 PM: ScriptWantsExe false

2/2/2017 4:10:01 PM: LogFile CodePage Used: 1200

2/2/2017 4:10:01 PM: Reload Executed By QVSERVER\QlikAdmin

2/2/2017 4:10:01 PM: Process Executing: QVB

2/2/2017 4:10:01 PM: Process ID: 3228

2/2/2017 4:10:01 PM: 0002 SET ThousandSep=','

2/2/2017 4:10:01 PM: 0003 SET DecimalSep='.'

2/2/2017 4:10:01 PM: 0004 SET MoneyThousandSep=','

2/2/2017 4:10:01 PM: 0005 SET MoneyDecimalSep='.'

2/2/2017 4:10:01 PM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

2/2/2017 4:10:01 PM: 0007 SET TimeFormat='h:mm:ss TT'

2/2/2017 4:10:01 PM: 0008 SET DateFormat='M/D/YYYY'

2/2/2017 4:10:01 PM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

2/2/2017 4:10:01 PM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

2/2/2017 4:10:01 PM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

2/2/2017 4:10:01 PM: 0013 ODBC CONNECT*XUserId*XPassword*

2/2/2017 4:10:06 PM: 0017 Query 1:

2/2/2017 4:10:06 PM: 0018 SQL Query 1

2/2/2017 4:10:06 PM: 3 fields found: scenario name, version number, created by, 10 lines fetched

.........................

2/2/2017 4:10:08 PM: Execution finished.

Thanks

Re: Reload task in Qlikview Server

Peter_Cammaert — Fri, 03 Feb 2017 15:31:50 GMT

Staffan has a point. In addition to his suggested actions, check whether the document copy on the server has appropriate permissions for other users (including the account running the distribution service), or just for you. In the latter case, you will be the only one that is allowed to overwrite the document.

Re: Reload task in Qlikview Server

Fri, 03 Feb 2017 15:43:59 GMT

I will try in that way pcammaert‌ @staffan

Re: Reload task in Qlikview Server

swiftfahad — Thu, 26 Oct 2017 08:16:04 GMT

had you find a solution for it?

Re: Reload task in Qlikview Server

swiftfahad — Thu, 26 Oct 2017 08:21:51 GMT

I also want to reload file from server that hits the database on the same domain..... plz guide can i have your personal email add??

Re: Reload task in Qlikview Server

swiftfahad — Thu, 26 Oct 2017 08:24:43 GMT

as you said

"Some part of the job is done, i.e he file is able to connect and reload the data from the other machine"

I wana do this part that you have done plz guide