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

[Bill_Britt]

What does the document log show? It will fail if all the connectors are not in place.

[#3]

Correct me if I'm wrong but the document log file doesnt give you anything if you dont reload it right? i am only distributing it.

//BR
Patrik

[Bill_Britt]

It should show you where it failed at.

[#5]

It doesnt output a log without reloading the document, the only log that shows (without reload) is tasklog.log

[Bill_Britt]

Under the document properties do you have it setup to generate a log?

[#7]

I havn't talked to the support but I changed to "real" server since this was just a test and there it worked just fine.

So the problem was probably RAM(memory) related since this server has two times more the ram.

//BR
Patrik

[#8]

Hello Patrik,

I am facing the same issue. I am running more than 20 documents which completely(script,layout) same except one parameter.All run fine except two documnets. I am running all these documents in Server (which have publisher).

For these two documents i am getting same error. RAM shouldn't be the issue.

When i run these document manually it ask me for system permission. Once i provide permission it runs fine but these documnets are every time failing in publisher.

Any help is appreciated!!!

Thanks.

Pragya

[bm59]

Hi,

Same issue for me, any ideas to fix it?

Thx

[bm59]

Hi,

Same issue for me, any ideas to fix it?

Thx

[bm59]

Hi,

Same issue for me, any ideas to fix it?

Thx