Qlikview Publisher Loop and Distribute QVW NT Permissions Issue

[#1]

I've created a task in QV Publisher to perform a reduction and distribution.  The distribution is based off a security table we have populated in the data model with SAMAccountName and a field linking to our fact table (to support the reduction of data based off a customer).

Within our security table we have three records all pointing to the same customer, each having a different SAMAccountName.  The goal is one qvw for Customer 9116 with the windows security permissions allowing for 3 different users to access the document.

Data model security table

SAMAccountName     CustomerID

User1                          9116

User2                          9116

User3                          9116

User4                          9116

Problem:  The resultant reduced QVW is named for Customer 9116, the data within is reduced and contains only data for Customer 9116 BUT the windows permissions on the QVW show 3 rows (in addition to the standard QV Publisher AD account) where one of the users is missing (User 2), and there are two duplicate records for User 1.

Resultant QVW NT Security permissions for CustomerA.qvw

User1

User1

User3

User4

QVPublisher

We not using Section Access in this situation, just the publisher reduction/distribution.

Attempting to add User2 manually to the file Security Tab/Add dialog does not work either for this user.   We can find the user in AD, check it but when you click on add nothing happens.  We can add other users (as a test knowing the publisher will overwrite it) successfully.

Has anyone seen this behavior with the loop in field processing?

Thanks

[Bill_Britt]

What does the distribution look show? It should have why USER2 isn't being added to the document.

Bill

[#3]

Bill,

I had the admin pull the log and send it my way.  I didn't see any errors in the log and it did list my each of my users.   Below is the pertinent portion of the log I believe.  I've xxx'ed out items for security reasons but basically all of my users are listed as I would expect.  I see no errors pertaining to the User 2 which is experiencing the issue.

I did notice that the task has both the  a "Manually" tab entry and the "Loop Field in Document".  I'm wondering if having both these specified is causing some issue.

5/13/2013 06:10:35.0149856 Information Reloading

5/13/2013 06:10:44.7184344 Information The Source Document reload complete. DocumentPath=E:\QlikView Documents\xxxxxxxxxxxxxxxxx.qvw

5/13/2013 06:10:44.7184344 Information Memory Allocation Delta for this file=1866.55 Mb. Available Physical Memory Before Reload=7008.45 Mb. Available Physical Memory After Reload=5172.64 Mb. Total Physical Memory=5172.64 Mb.

5/13/2013 06:10:44.9212396 Information The Source Document was reloaded successfully.

5/13/2013 06:10:44.9212396 Information Reload finished successfully

5/13/2013 06:10:44.9212396 Information Start saving document

5/13/2013 06:10:57.2923568 Information Check in document: E:xxxxxxxxxx.qvw

5/13/2013 06:10:57.3079572 Information Closing the document.

5/13/2013 06:10:57.9943748 Information Closed the QlikView Engine successfully. ProcessID=10464

5/13/2013 06:10:57.9943748 Information Start document distribution.

5/13/2013 06:10:57.9943748 Information Opening source document

5/13/2013 06:10:57.9943748 Information Opening document: "xxxx.qvw"

5/13/2013 06:10:57.9943748 Information Allocating new QlikView Engine. Current usagecount=1 of 4

5/13/2013 06:10:57.9943748 Information Max retries:5

5/13/2013 06:10:57.9943748 Information Attempt:01

5/13/2013 06:10:58.7275936 Information Allocated QlikView Engine successfully. Current usagecount=1 of 4, Ticket=1463

5/13/2013 06:10:58.7275936 Information Loading document "E:\xxxxxxx.qvw" (101.27 Mb)

5/13/2013 06:10:59.7416196 Information Loading. LoadTime=00:00:01.0140260

5/13/2013 06:11:01.7696716 Information Loading. LoadTime=00:00:03.0420780

5/13/2013 06:11:03.2049084 Information Physical FileSize=101.27 Mb. Memory Allocation Delta for this file=404.30 Mb. Available Physical Memory Before Open=5534.43 Mb. Available Physical Memory After Open=6620.16 Mb. Total Physical Memory=36853.80 Mb.

5/13/2013 06:11:03.2049084 Information Attempted to load the document with data.

5/13/2013 06:11:03.2049084 Information The document was loaded successfully.

5/13/2013 06:11:03.4545148 Information Reduce skipped, nothing is selected.

5/13/2013 06:11:03.4545148 Information Document was opened successfully

5/13/2013 06:11:03.4545148 Information Determined 2 static recipients spread over 1 Distribution Resources.

5/13/2013 06:11:03.7353220 Information Number of rule combinations was calculated successfully. Rounds=1

5/13/2013 06:11:03.7353220 Information Applying rules

5/13/2013 06:11:03.7353220 Information Commencing ClearSelections. FieldName=CustomerName

5/13/2013 06:11:03.7665228 Information Commencing ClearSelections. FieldName=CustomerName

5/13/2013 06:11:03.7665228 Information Adding selections for field CustomerName. Values="xxxxxx"

5/13/2013 06:11:03.8133240 Information Adding selections for field CustomerName. Values="xxxxxx"

5/13/2013 06:11:03.8289244 Information Applied rules:CustomerName="xxxxxxxx", CustomerName="xxxxxxxx"

5/13/2013 06:11:03.8289244 Information Rules resulted in distribution.

5/13/2013 06:11:03.8289244 Information ROUND: 1 of 1. WarningCount=0

5/13/2013 06:11:03.8289244 Information Building filename

5/13/2013 06:11:03.8289244 Information Destination name: xxxxxx.qvw

5/13/2013 06:11:03.8289244 Information Set script

5/13/2013 06:11:03.8289244 Information Set script

5/13/2013 06:11:03.8601252 Information Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear

5/13/2013 06:11:03.8601252 Information Applying DDD recipients

5/13/2013 06:11:03.8757256 Information Dynamic Distribution for field sAMAccountName returned 4possible recipients

5/13/2013 06:11:03.8913260 Information Searching using "SAMAccountName" using parameter "sAMAccountName" returned 4 results.

5/13/2013 06:11:03.8913260 Information Offer resources

5/13/2013 06:11:03.9225268 Information Commencing ReduceData

5/13/2013 06:11:06.2937876 Information Completed ReduceData

5/13/2013 06:11:06.2937876 Information Memory Allocation Delta for this file=107.21 Mb. Available Physical Memory Before Reduce=6613.46 Mb. Available Physical Memory After Reduce=6499.30 Mb. Total Physical Memory=6499.30 Mb.

5/13/2013 06:11:07.2766128 Information Distributing

5/13/2013 06:11:07.2766128 Information Distributing using resource "xxxx Registry REDUCE / Reload / Distribute_QVS_1".

5/13/2013 06:11:07.2766128 Information Trying to distribute. QVS=qvp://xxxx/

5/13/2013 06:11:07.2766128 Information Connecting to QlikView Server. Address=xxxxx

5/13/2013 06:11:07.2922132 Information Successfully connected to QlikView Server. Address=xxxxx

5/13/2013 06:11:07.3078136 Information Creating/Updating file: qvp://xxxxx/xxxx/xxxxx.qvw

5/13/2013 06:11:07.3078136 Information <request monitor="Performance"/>

5/13/2013 06:11:07.3078136 Information <?xml version="1.0" encoding="UTF-8" ?><Performance><ExeType>RLS64</ExeType><ExeVersion>11.00.11282.0409.10</ExeVersion><Timestamp>2013-05-13

5/13/2013 06:11:07.3078136 Information <Global method="FileUpload"><xxxxx/xxxxxxx.qvw</Path></Global>

5/13/2013 06:11:07.3078136 Information <Global><_retval_>0</_retval_></Global>

5/13/2013 06:11:07.3390144 Information <Global method="FileWrite"><h>0</h><Pos>0</Pos><Buffer /></Global>

5/13/2013 06:11:07.5730204 Information ExecuteWithAttachments returned no data in buffer.

5/13/2013 06:11:07.5730204 Information <Global></Global>

5/13/2013 06:11:07.5730204 Information <Global method="FileWrite"><h>0</h><Pos>5242880</Pos><Buffer /></Global>

5/13/2013 06:11:07.6354220 Information ExecuteWithAttachments returned no data in buffer.

5/13/2013 06:11:07.6354220 Information <Global></Global>

5/13/2013 06:11:07.6354220 Information <Global method="FileWrite"><h>0</h><Pos>6624000</Pos><Buffer /></Global>

5/13/2013 06:11:07.6354220 Information ExecuteWithAttachments returned no data in buffer.

5/13/2013 06:11:07.6354220 Information <Global></Global>

5/13/2013 06:11:07.6354220 Information <Global method="FileCloseWithMetaData"><h>0</h><Data><Category>Default</Category><Description></Description><LastUpdate>41407.4243865741</LastUpdate><NextUpdate>41408.4236111111</NextUpdate><Clients>5</Clients><RestrictDownload>false</RestrictDownload><AccessList><MetaServiceAccessData><Anonymous>false</Anonymous>

<User>phsnet\User1</User><Allow>0</Allow></MetaServiceAccessData><MetaServiceAccessData><Anonymous>false</Anonymous>

<User>phsnet\QVAdministrators</User><Allow>0</Allow></MetaServiceAccessData><MetaServiceAccessData><Anonymous>false</Anonymous>

<User>phsnet\User2</User><Allow>0</Allow></MetaServiceAccessData><MetaServiceAccessData><Anonymous>false</Anonymous>

<User>phsnet\User3</User><Allow>0</Allow></MetaServiceAccessData><MetaServiceAccessData><Anonymous>false</Anonymous>

<User>phsnet\User4</User><Allow>0</Allow></MetaServiceAccessData></AccessList><AjaxUrl></AjaxUrl><EventDriven>false</EventDriven><MaxOpenSessions>-1</MaxOpenSessions><SessionTimeout>0</SessionTimeout><DocumentTimeoutMinutes>0</DocumentTimeoutMinutes><EnableSessionCollaboration>false</EnableSessionCollaboration><LoadGranularityMode>0</LoadGranularityMode><DocumentLoadInfo><DocumentLoadInfo><Mode>0</Mode><ServerId>PHQV</ServerId></DocumentLoadInfo></DocumentLoadInfo><EnableServerObjectsCreation>0</EnableServerObjectsCreation><ServerObjectsUsers /><EnableAuditLog>true</EnableAuditLog><RestrictExport>0</RestrictExport><SourceName>xxxxx.qvw</SourceName></Data><Part>39</Part><AjaxFolder></AjaxFolder></Global>

5/13/2013 06:11:07.7446248 Information <Global></Global>

5/13/2013 06:11:07.7446248 Information Performance data (CopyFile😞 Connecting to QVS. (0), DMSAccessRules=5 (0), Uploading file: xxxxxxxx.qvw (0), Write complete. (6624000 bytes processed) (328)

5/13/2013 06:11:07.7446248 Information QVS Distribution completed with success.

5/13/2013 06:11:07.7446248 Information Distribution finished successfully.

5/13/2013 06:11:07.7446248 Information Deleting temporary files.

5/13/2013 06:11:07.7602252 Information Closing the document.

5/13/2013 06:11:08.4310424 Information Closed the QlikView Engine successfully. ProcessID=9080

5/13/2013 06:11:08.4310424 Information Document distribution done.

5/13/2013 06:11:08.4310424 Information Task Execute Duration=00:01:08.0177440

5/13/2013 06:11:08.4310424 Information The task "xxxxx REDUCE / Reload / Distribute" finished successfully

5/13/2013 06:11:08.4310424 Information TaskResult.status=Finished

5/13/2013 06:11:08.4310424 Information Notifying all triggers of new state:Finished

5/13/2013 06:11:08.4310424 Information Notifying all triggers of new state:Finished - completed

5/13/2013 06:11:08.4310424 Information Saving Task Result

[Bill_Britt]

Hi,

What I am seeing is publisher only finds two users.

5/13/2013 06:11:03.4545148 Information Determined 2 static recipients spread over 1 Distribution Resources.

Bill

[#5]

Bill,

Thanks for the quick response.

I did see that as well. 

I did also see the section

5/13/2013 06:11:03.8757256 Information Dynamic Distribution for field sAMAccountName returned 4possible recipients

and a bit later in the log the ="FileCloseWithMetaData section listing my 4 users as specified in the table within my data model that is set as the Loop Field in Document "field containing recipient info" field.

I'm wondering if the 2 static are from the task configuration in the Manually tab, and the 4 are from the Loop Field in Document.  I'm wondering if he combination is causing some issue.  I don't really believe we want the static distribution.  We really want the distribution to be driven from the table in the data model.  I've asked my administrator to remove the Manually section configuration and rerun the task.

Eric