topic Re: error when distribute the document on named users in qlik publisher in QlikView

error when distribute the document on named users in qlik publisher

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Am getting this error when distribute the document on named users in qlik publisher ,please can any one help me on this.

Here named users are odbc user i have loaded into the server.

The task "Reload and Distribute of Applications\LLO Section Action.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.DistributeToResourcesFailedException: Distribute to resource failed. ---> System.Exception: l_FileSystemPluginHelper exception ---> QDSMain.Exceptions.DscOffLineException: Failed to AddNamedUsers || at QDSMain.Support.DSCHelper.AddNamedUsers(ILogBucket logBucket, XmlDocument xml, List`1 namedUsers, FileSystemPluginHelper fileSystemPluginHelper) || at QDSMain.Support.DSCHelper.GetFileSystemSecurity(ILogBucket logBucket, FileSystemPluginHelper fileSystemPluginHelper, List`1 recipients) || at QDSMain.QlikViewServerDistributionResource.CreateSettingsBlock(ILogBucket i_LogBucket, FileSystemPluginHelper i_FileSystemPluginHelper, String i_SourceDocumentName, DateTime i_LastUpdate, DateTime i_NextUpdate, Boolean i_EventDriven, String i_Category, eDistributionFileType i_TotalDistributionFileTypeMask, FilePackageContainer i_FilePackageContainer) || at QDSMain.QlikViewServerDistributionResource.Distribute(ILogBucket i_LogBucket, DistributionRequest i_DistributionRequest) || --- End of inner exception stack trace --- || at QDSMain.QlikViewServerDistributionResource.Distribute(ILogBucket i_LogBucket, DistributionRequest i_DistributionRequest) || at QDSMain.DistributeTask.DistributeStreamToResources(Int32 round, Distribution distribution, Dictionary`2 offeredDistributionList, String fullNtfsPathToFile, UnifiedHubSettings unifiedHubSettings) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.DistributeStreamToResources(Int32 round, Distribution distribution, Dictionary`2 offeredDistributionList, String fullNtfsPathToFile, UnifiedHubSettings unifiedHubSettings) || at QDSMain.DistributeTask.DistributionExecution(String fileName, Document qvbDocument, DistributionRequest distributionRequest, IExecutingTaskResult executingTaskResult, String repeatVariableName, String currentRepeatVariableValue) || at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, IExecutingTaskResult executingTaskResult, String repeatVariableName, String currentRepeatVariableValue) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)

rwunderlich techvarun stalwar1 swuehl kenphamvn

Re: error when distribute the document on named users in qlik publisher

sumit_ranjan_pa — Tue, 03 Oct 2017 08:35:31 GMT

HI Narasimha,

It will be best if you create a ticket with the Qlik Support team. The exceptions are generic in nature and seems the distribution is running into trouble.

You can try restating the services but i wonder if that will help.

Thanks.

Re: error when distribute the document on named users in qlik publisher

techvarun — Tue, 03 Oct 2017 09:20:17 GMT

Hi Narasimha,

Are you using a qlikview service account with full control to the folder which contains the qvw?

The account which is running the QlikView services has the control to access the folder?

The issue seems like access issue. Please check the QV services

Re: error when distribute the document on named users in qlik publisher

Peter_Cammaert — Tue, 03 Oct 2017 09:46:46 GMT

Are you using your own user list in a distribution where permissions are managed by NTFS?

Re: error when distribute the document on named users in qlik publisher

Anonymous — Tue, 03 Oct 2017 09:49:54 GMT

hi sumit,

i tried with restarting directory service and distribution services both but not worked for me.is there any another services to restart.

Re: error when distribute the document on named users in qlik publisher

Anonymous — Tue, 03 Oct 2017 09:55:41 GMT

hi peter,

am imported users from odbc connection, so it is importing db table users using directory service connectors

Re: error when distribute the document on named users in qlik publisher

techvarun — Tue, 03 Oct 2017 09:56:48 GMT

Restarting the service will not solve the issue.

Check the login details of the services.
Check the username which is running the service has access to all the folders where qvw place.

Thanks,

Varun

Re: error when distribute the document on named users in qlik publisher

Peter_Cammaert — Tue, 03 Oct 2017 09:57:25 GMT

I read that. But that's not what I asked. What is the QlikView server security set at? NTFS or DMS?

Re: error when distribute the document on named users in qlik publisher

Anonymous — Tue, 03 Oct 2017 09:58:38 GMT

ohh kk its dms

Re: error when distribute the document on named users in qlik publisher

Peter_Cammaert — Tue, 03 Oct 2017 10:03:08 GMT

Did you define a single DSC (Configurable ODBC) or are there others?

Re: error when distribute the document on named users in qlik publisher

Anonymous — Tue, 03 Oct 2017 10:32:00 GMT

ya i have 2 odbc connections in that the 2nd odbc connection having which am adding users to distribute document and another thing is when i use 1st odbc connection users to distribute document is working fine but when i use 2nd odbc connection it is getting failed.

Re: error when distribute the document on named users in qlik publisher

Peter_Cammaert — Tue, 03 Oct 2017 10:39:16 GMT

And in the Distribute tab, you are able to add users from the 2nd ODBC directory, but when QDS tries to distribute, you get these errors?

Re: error when distribute the document on named users in qlik publisher

Anonymous — Tue, 03 Oct 2017 10:52:20 GMT

yes right this is what is happening extactly

Re: error when distribute the document on named users in qlik publisher

Anonymous — Tue, 03 Oct 2017 11:01:30 GMT

both services folder and qvw folder having only administrator account as common and remaining are different accounts.there is no service account is assigned to service folder.so can you tell me the which account to add which folder.

Re: error when distribute the document on named users in qlik publisher

Peter_Cammaert — Tue, 03 Oct 2017 12:37:55 GMT

What are the labels of those directories? Look in Configurable ODBC->Your directory entry->Settings->Directory Label.

Re: error when distribute the document on named users in qlik publisher

Peter_Cammaert — Tue, 03 Oct 2017 12:40:17 GMT

And also this: do the users that you listed in the Distribute tab still exist in the correct Configurable DSC directory? QlikView will fail with a message like the one you posted if for example a domain has disappeared or users have been wiped from AD without clearing their entries in the Distribution list.

Re: error when distribute the document on named users in qlik publisher

Anonymous — Tue, 03 Oct 2017 13:15:14 GMT

The directory label names are SQL,TSQL in this TSQL users are not distributing for document