2 Replies Latest reply: Dec 20, 2012 10:25 AM by donaldpayeur RSS

    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