Error: Document open call failed. The document might require username and password.

[#1]

Hi!

I've a problem, we are running a enviroment with Publisher 9 and Server 9 and its working flawlessly.

Now its time to upgrade (QV11) so we bought a new server for running the QVS and using another for the Distribution I've tried to distribute three Apps with the new enviroment and out of those two work.

The app that is failing is giving me "Error: Document open call failed. The document might require username and password." but when I look in the old enviroment there is no section access given the app.

Any suggestions what to do?

Here is the full log:

(2012-02-24 11:30:59) Information: Starting task 'Distribute of Sales Report Test.qvw'. Id:ea507847-a05f-43bf-aa17-c90d0cd7a389. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2012-02-24 11:30:59) Information: Entering Task Execution.

(2012-02-24 11:30:59) Information: ClusterID=1

(2012-02-24 11:30:59) Information: QDSID=0794f787-8484-bbe6-18bf-ec086f620236

(2012-02-24 11:30:59) Information: TaskID=ea507847-a05f-43bf-aa17-c90d0cd7a389

(2012-02-24 11:30:59) Information: MaxRunTime=1.00:00:00

(2012-02-24 11:30:59) Information: Max attempts:1

(2012-02-24 11:30:59) Information: Current Attempt=0

(2012-02-24 11:30:59) Information: Task Dependencies are OK

(2012-02-24 11:30:59) Information: Start document distribution.

(2012-02-24 11:30:59) Information: Opening source document

(2012-02-24 11:30:59) Information: Opening document: "Sales Report Test.qvw"

(2012-02-24 11:30:59) Information: Allocating new QlikView Engine. Current usagecount=1 of 4

(2012-02-24 11:30:59) Information: Max retries:5

(2012-02-24 11:30:59) Information: Attempt:01

(2012-02-24 11:30:59) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 4, Ticket=24

(2012-02-24 11:30:59) Information: Loading document "C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\Sales Report Test.qvw" (741.07 Mb)

(2012-02-24 11:31:00) Information: Loading. LoadTime=00:00:01.0000320

(2012-02-24 11:31:02) Information: Loading. LoadTime=00:00:03.0000960

(2012-02-24 11:31:06) Information: Loading. LoadTime=00:00:07.0002240

(2012-02-24 11:31:14) Information: Loading. LoadTime=00:00:15.0004800

(2012-02-24 11:31:27) Error: Document open call failed. The document might require username and password.

(2012-02-24 11:31:27) Information: Attempted to load the document with data.

(2012-02-24 11:31:27) Error: The document failed to open.

(2012-02-24 11:31:28) Information: Closed the QlikView Engine successfully. ProcessID=2400

(2012-02-24 11:31:28) Error: Document could not be opened

(2012-02-24 11:31:28) Information: Closed the QlikView Engine successfully. ProcessID=2400

(2012-02-24 11:31:28) Error: The task "Distribute of Sales Report Test.qvw" failed. Exception:

(2012-02-24 11:31:28) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> System.NullReferenceException: Object reference not set to an instance of an object.

(2012-02-24 11:31:28) Error:    at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument)

(2012-02-24 11:31:28) Error:    at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

(2012-02-24 11:31:28) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-02-24 11:31:28) Error:    --- End of inner exception stack trace ---

(2012-02-24 11:31:28) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-02-24 11:31:28) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2012-02-24 11:31:28) Information: Task Execute Duration=00:00:28.7977965

(2012-02-24 11:31:28) Information: TaskResult.status=Finished

(2012-02-24 11:31:28) Information: Notifying all triggers of new state:FinishedWithErrors

(2012-02-24 11:31:28) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2012-02-24 11:31:28) Information: Saving Task Result

//BR
Patrik

[#2]

Patrik,

Is this a random event?  Or does it occur every time the document is reloaded?

James

[#3]

Hi James!

It happends every time i try to distribute the document (The reload is disabled right now just for testing)

//BR
Patrik

[#4]

Patrik,

Does the document log tell you any more information?  The log you posted appears to be the task log.

My first thought is to check that the account running QVS and QDS has the authority to read/write in the source and target directories.

James

[#5]

James,

How do I see the document log?

The other documents that i've added is working fine so there shouldn't be a user problem nor?

//BR
Patrik

[#6]

Patrik,

You can turn on the document log using the document properties (desktop).

If the permission on this document is different, then you might experience this issue.

However, in reading through the task log, it appears that 15 seconds goes by before the error occurs...

(2012-02-24 11:30:59) Information: Loading document "C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\Sales Report Test.qvw" (741.07 Mb)

(2012-02-24 11:31:00) Information: Loading. LoadTime=00:00:01.0000320

(2012-02-24 11:31:02) Information: Loading. LoadTime=00:00:03.0000960

(2012-02-24 11:31:06) Information: Loading. LoadTime=00:00:07.0002240

(2012-02-24 11:31:14) Information: Loading. LoadTime=00:00:15.0004800

(2012-02-24 11:31:27) Error: Document open call failed. The document might require username and password.

Is this document running a macro? If so, the document log might be more informative...

Is the timeout (task trigger) set to 15 seconds? You might try the debug logging level for QDS (QMC/System/Setup/QDS/Settings for QDS/Logging Level)

James

[Bill_Britt]

Does this document have section access applied? If so the service account that the distribution service is running under has to be in section access as an admin.

[dwh1104]

Parallel Reload was introduced in QV10.  I would try to disable the Parallel Reload and see if that corrects your problem.

Thanks,

Dan

[#9]

Update: I redid the whole document with copy and paste to qv10 and then i tried it again without doing a reload.

This did work no problem, but when i reloaded the document (using desktop 10) and then putting it in the distribution folder again then it didnt work, same problem.

So something happends with the document after reload.

I haven't tried to reload it yet thru publisher since i haven't set up the odbc connections etc.

Any ideas?

EDIT:

I marked the document for reload also (without setting up the odbc connections etc) and then the log output said:

"

(2012-02-24 18:18:28) Information: Starting task 'Distribute of test.qvw'. Id:56a083e2-8f35-44b1-b4e8-b333986018c3. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2012-02-24 18:18:28) Information: Entering Task Execution.

(2012-02-24 18:18:28) Information: ClusterID=1

(2012-02-24 18:18:28) Information: QDSID=0794f787-8484-bbe6-18bf-ec086f620236

(2012-02-24 18:18:28) Information: TaskID=56a083e2-8f35-44b1-b4e8-b333986018c3

(2012-02-24 18:18:28) Information: MaxRunTime=1.00:00:00

(2012-02-24 18:18:28) Information: Max attempts:1

(2012-02-24 18:18:28) Information: Current Attempt=0

(2012-02-24 18:18:28) Information: Task Dependencies are OK

(2012-02-24 18:18:28) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2012-02-24 18:18:28) Information: Opening "C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\test.qvw"

(2012-02-24 18:18:28) Information: Allocating new QlikView Engine. Current usagecount=1 of 4

(2012-02-24 18:18:28) Information: Max retries:5

(2012-02-24 18:18:28) Information: Attempt:01

(2012-02-24 18:18:29) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 4, Ticket=60

(2012-02-24 18:18:29) Information: Loading document "C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\test.qvw" (741.61 Mb)

(2012-02-24 18:18:30) Information: Loading. LoadTime=00:00:01.0000384

(2012-02-24 18:18:32) Information: Loading. LoadTime=00:00:03.0001152

(2012-02-24 18:18:36) Information: Loading. LoadTime=00:00:07.0002688

(2012-02-24 18:18:39) Information: Physical FileSize=741.61 Mb. Memory Allocation Delta for this file=21.96 Mb. Available Physical Memory Before Open=2346.60 Mb. Available Physical Memory After Open=2320.48 Mb. Total Physical Memory=3325.87 Mb.

(2012-02-24 18:18:39) Information: Attempted to load the document without data.

(2012-02-24 18:18:39) Information: The document was loaded successfully.

(2012-02-24 18:18:39) Information: Document was opened successfully

(2012-02-24 18:18:39) Information: Starting reload

(2012-02-24 18:18:39) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2012-02-24 18:18:39) Information: The Source Document is being reloaded. DocumentPath=C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\test.qvw

(2012-02-24 18:18:40) Information: The Source Document reload complete. DocumentPath=C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\test.qvw

(2012-02-24 18:18:40) Information: Memory Allocation Delta for this file=0.13 Mb. Available Physical Memory Before Reload=2320.46 Mb. Available Physical Memory After Reload=2314.77 Mb. Total Physical Memory=2314.77 Mb.

(2012-02-24 18:18:40) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\test.qvw.

(2012-02-24 18:18:40) Information: Closing the document.

(2012-02-24 18:18:40) Information: Closed the QlikView Engine successfully. ProcessID=1884

(2012-02-24 18:18:40) Error: The task "Distribute of test.qvw" failed. Exception:

(2012-02-24 18:18:40) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\Documents and Settings\Administrator.GALLERIX-SK\Desktop\QV-Test\Inprod\test.qvw.

(2012-02-24 18:18:40) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2012-02-24 18:18:40) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2012-02-24 18:18:40) Error:    --- End of inner exception stack trace ---

(2012-02-24 18:18:40) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2012-02-24 18:18:40) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-02-24 18:18:40) Error:    --- End of inner exception stack trace ---

(2012-02-24 18:18:40) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2012-02-24 18:18:40) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2012-02-24 18:18:41) Information: Task Execute Duration=00:00:12.2660960

(2012-02-24 18:18:41) Information: TaskResult.status=Finished

(2012-02-24 18:18:41) Information: Notifying all triggers of new state:FinishedWithErrors

(2012-02-24 18:18:41) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2012-02-24 18:18:41) Information: Saving Task Result"

The interessting part is that now it says document opened successfully etc.

So maybe i should try to put in all the connections just to see how it will react.

//BR
Patrik

[dwh1104]

Patrik,

Have you contacted QlikTech Support?  It sounds like the suggestions that we have made are not working in your case.

Please follow up with any solution that they provide you.

Thanks,

Dan