Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Document Distribute Fails When Targetting Configurable ODBC Users

Hello All,

I have a server with 2 directory services: Custom and Configurable ODBC (using SQLite).

The directories seem to work properly since I can browse, search and pick users from both successfully.

I have a source document that I want to publish.

So I create a task for it and configure the 'distribute' tab to target a folder on the same server.

Whenever I distribute with a user from the Custom directory, the task runs fine and the user document gets created.

If however I put a user coming from my ODBC Directory in the task's distribute list, the task fails with this log and the user doc is not produced:

...

(2012-07-12 15:00:51) Information: Completed ReduceData

(2012-07-12 15:00:51) Information: Memory Allocation Delta for this file=0.27 Mb. Available Physical Memory Before Reduce=14511.69 Mb. Available Physical Memory After Reduce=14511.23 Mb. Total Physical Memory=14511.23 Mb.

(2012-07-12 15:00:51) Information: Distributing

(2012-07-12 15:00:51) Information: Distributing using resource "MyTask_Folder_1".

(2012-07-12 15:00:51) Error: Exception=QDSMain.Exceptions.NoRecipientsException: DSC returned no users or groups. May be configured incorrect?

(2012-07-12 15:00:51) Error:    at QDSMain.Support.DSCHelper.AddNamedUsers(ILogBucket logBucket, XmlDocument xml, List`1 namedUsers, FileSystemPluginHelper fileSystemPluginHelper)

(2012-07-12 15:00:51) Error: Could not fetch FileSystemSecurity. Exception=QDSMain.Exceptions.DscOffLineException: Failed to AddNamedUsers

(2012-07-12 15:00:51) Error:    at QDSMain.Support.DSCHelper.AddNamedUsers(ILogBucket logBucket, XmlDocument xml, List`1 namedUsers, FileSystemPluginHelper fileSystemPluginHelper)

(2012-07-12 15:00:51) Error:    at QDSMain.Support.DSCHelper.GetFileSystemSecurity(ILogBucket logBucket, FileSystemPluginHelper fileSystemPluginHelper, List`1 recipients)

(2012-07-12 15:00:51) Error:    at QDSMain.FolderDistributionResource.Distribute(ILogBucket i_LogBucket, DistributionRequest i_DistributionRequest)

(2012-07-12 15:00:51) Error: Distribution to resources failed with errors. Warnings: 0, Errors: 2

(2012-07-12 15:00:51) Information: Deleting temporary files.

(2012-07-12 15:00:51) Information: Closing the document.

(2012-07-12 15:00:51) Information: Closed the QlikView Engine successfully. ProcessID=4848

(2012-07-12 15:00:51) Error: The task "MyTask" failed. Exception:

(2012-07-12 15:00:51) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.LogBucketErrorException: Distribution to resources failed with errors. Warnings: 0, Errors: 2

(2012-07-12 15:00:51) Error:    at QDSMain.DistributeTask.RevertOneAndAlwaysOne(Document qvbDocument)

(2012-07-12 15:00:51) Error:    at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument)

(2012-07-12 15:00:51) Error:    at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

(2012-07-12 15:00:51) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-07-12 15:00:51) Error:    --- End of inner exception stack trace ---

(2012-07-12 15:00:51) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-07-12 15:00:51) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2012-07-12 15:00:51) Information: Task Execute Duration=00:00:02.1757813

(2012-07-12 15:00:51) Information: TaskResult.status=Finished

(2012-07-12 15:00:51) Information: Notifying all triggers of new state:FinishedWithErrors

(2012-07-12 15:00:51) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2012-07-12 15:00:51) Information: Saving Task Result

My SQLite database has no password and various ODBC tool connect to it just fine.

My SQLite db file is in a folder where 'everyone' has 'full access'.

My task targets the same folder for the published document.

It's like the management console can see my user data but the distribution components cannot.

Here my SQLite db schema:

     create table entities (entityid integer primary key not null, name varchar(256) not null, descr varchar(256) not null, email varchar(256) not null);

     create index entities_name_ndx on entities(name);

     create table groups (groupid integer not null, memberid integer not null);

Here's my ODBC Directory config:

config.png

I'm baffled.

Anyone has any idea why I can't distribute using a configurable ODBC user ?

thanks in advance

donald

2 Replies
Anonymous
Not applicable
Author

Hi, I've the same problem with odbc directory...have you solved it?

Thank you!

Not applicable
Author

We don’t use QlikView anymore but I kind of remember it had to do with the target of the deployment (file deployment vs server deployment) (?)…

Hope this helps.

Donald