Need help understanding publisher error log

[#1]

Hi,

Can any one please help me understand what this publisher error log mean. We get this error when trying to run multiple (3-6 depending on the source file size) reduction jobs together. We are running QV 9 SR3 on windows 2003 server with 64 gig ram and 16 cpu.

(2010-04-08 12:37:05) Information: Loading. LoadTime=00:00:31.3904241

(2010-04-08 12:37:18) Error: The sourcedocument failed to open.. Exception=System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

(2010-04-08 12:37:18) Error: at QlikView.ApplicationClass.OpenDoc(String _DocName, String _UserName, String _Password, String _Serial)

(2010-04-08 12:37:18) Error: at QVBWrapper.Document.Load(ILogBucket i_LogBucket)

(2010-04-08 12:37:18) Error: The document failed to open.

(2010-04-08 12:37:18) Error: Could not request the QlikView Engine process to quit.. Exception=System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

(2010-04-08 12:37:18) Error: at QlikView.ApplicationClass.Quit(Int32 _ExitCode)

(2010-04-08 12:37:18) Error: at QVBWrapper.Document.NiceCloseThread(ILogBucket i_LogBucket)

(2010-04-08 12:37:18) Information: Closed the QlikView Engine successfully. ProcessID=12212

(2010-04-08 12:37:18) Information: Round: 74 (0), Opening document (0), Initializing Checkout (0), Loading document (312), Initializing load (312), Checking read (312), Creating QlikView Engine (312), Checking Size (422), Load (422)

(2010-04-08 12:37:18) Error: Document could not be opened

(2010-04-08 12:37:18) Information: Document could not be opened (0)

(2010-04-08 12:37:18) Information: Closed the QlikView Engine successfully. ProcessID=12212

(2010-04-08 12:37:18) Information: Initializing (0), Finished (0)

(2010-04-08 12:37:18) Error: Could not open the document.

(2010-04-08 12:37:18) Error: Could not open the document. DocumentName=D:\QlikView Storage\Private Data\Source Documents\In Production\DM_Enhanced\Forest_Enhanced_work_SF_4.qvw

(2010-04-08 12:37:18) Information: Deleting temp files (0), Next round! (0)

(2010-04-08 12:37:18) Information: Initializing (0), Finished (0)

(2010-04-08 12:37:19) Error: The task "Territory Reduce - SF04 (Territory Reduce Job - SF 04)" failed. ErrorCount=6

Thanks,

Tarique

[#2]

I have this same exact error.

I am troubleshooting now. Did you have any solutions to this?

[vgutkovsky]

I would recommend contacting Support (support@qlik.com). I'm not positive, but I think this might have to do with the number of Engines that QDS can allocate at once. In theory, this should be equal to the number of cores on the machine, but I think I heard somewhere that there might be an internal QV limit that is less than this.

Good luck,

[#4]

E-mailed support. They will move my case to second level support. Will post response. This will be good for others to see as well.

Thanks again Vlad.

[Bill_Britt]

The QVB limit is 10. This is not a QV limit but an OS limit on the number of Comms objects.

[#6]

Well we did not hit 10 cores...

It is set to 4 within HyperV (our virtual environment) and within QDS.

I am still working with QV support. Currently we are thinking it may be permission related with the OLE DB/ODBC DB connectors. I will post when I have more information.

[#7]

I do not have an explanation as to why this is happening but I do have a solution. At least one that removed the error count =5 from the log file.

I created a new ODBC data source connector within QV and made it apply to the 'this machine only'. UAC needed to be turned off in order for me to apply the to the machine. I then used the SQL driver rather than the SQL Native Client 10.0 client.

We connect to two SQL DB one is at SQL 2000 then other at 2005. I looked up an error code I was getting in my log on M$ site and found the below support message. The below states this issue was addressed with SQL 2000 SP3. The error code I was getting was a call made to our 05 DB, one would this would be fixed in SQL 2005... maybe not.

http://support.microsoft.com/kb/313352

I am currently receiving 'errorcounte=3' now, I am still checking my settings but this may be my new issue...

As I mentioned before I am unsure why using the ODBC connector makes a difference. I will post again if I actually get the publisher task to reload automatically.

[#8]

I ended up using the 'OLE DB Provider for SQL Server' -32bit version.

For whatever reason the developer can use the 'SQL Native Client' or 'SQL Server' -64 or -32 bit but the publisher can only use what your DB you are pulling it from uses.

32-bit SQL driver to a 32-bit SQL driver. Have fun to anyone who needs to connect to a 32-bit or 64-bit driver...

[#9]

Has anyone confirmed with QlikTech about this limit?

How can the limit be increased?

[#10]

I am getting the following error when the Publisher tries to reload a job.

Error    The sourcedocument failed to open.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.

   at QlikView.ApplicationClass.SetUserPreferences(IUserPreferences _Preferences)

   at QVBWrapper.Document.Load(ILogBucket i_LogBucket)

10/27/2011 08:25:01.1548335    Error    The document failed to open.

Can anyone help?  This does not happen all the time, the document reloads fine afterwards.