CPU usages gets high and QlikView server freezes.

[Rajiv-Dharia]

Hi All,

Need help with a QlikView application, As soon as i launch the final application system freezes and need to restart the QlikView production server. Below is the error from the error logs.

Failed to read from C:\ProgramData\QlikTech\DistributionService\LoadBalancer.xml. Exception=System.Xml.XmlException: '.', hexadecimal value 0x00, is an invalid character. Line 1, position 1. || at System.Xml.XmlTextReaderImpl.Throw(Exception e) || at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Char[] data, Int32 length, Int32 invCharPos) || at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() || at System.Xml.XmlTextReaderImpl.ParseDocumentContent() || at System.Xml.XmlReader.MoveToContent() || at QDSMain.Clustering.ClusterFileHandler.Read(Action`1 readXML)

Thanks

Rajiv Dharia

[RafaelBarrios]

Hi @Rajiv-Dharia 

what do you mean with " launch the final application"

you mean reloading or opening.

In Qlikview this happens when the App is to big and it consumes all your RAM capacity

how big is your app in disk space ?

What is your server Ram capacity?

Best,

[Chip_Matejowsky]

Hi @Rajiv-Dharia,

I'm moving this thread from the Qlik Sense > App Development forum to the QlikView > Administration forum so that it reaches it's intended audience.

RE: the error you are referring to, see Qlik Knowledgebase article CPU and Memory settings to prevent overload in QlikView Distribution Service (QDS) .

I don't believe, however, that this error is pertinent to the issue per the symptoms you described.  Are you attempting to open a QVW from the AccessPoint or from QlikView Desktop?  Or, are you referring to reloading a QVW with fresh data?  Can you provide further details on your issue?   

If the issue occurs when attempting to open a QVW from the AccessPoint, suggest that you review the QlikView Server Events log, checking the timestamp the issue occurred with the user ID that was used when issue occurred.

Best Regards

[Rajiv-Dharia]

Hi,

I have a QlikView server 'Production server' and 'Development server'. Problem is happening when I am opening the final application from the Production server, as soon as I open the application it freezes and crashes the server. Below is the screen shot of the application with the size.

[cid:image001.png@01D8EDE6.FEFAA610]

This application also not accessible from Access point as it continue to load and it is not opening. Below is the error in the event log.

[cid:image002.png@01D8EDE6.FEFAA610]

Using the Binary load this application loads the data from below file which is in the Development server and it opens there without any problem though
[cid:image003.png@01D8EDE6.FEFAA610]

[Chip_Matejowsky]

Hi Rajiv-Dharia,

I'm afraid the images you posted in your previous post didn't come through. Can you post them again along with with QVS Events log and provide the name of the QVW that won't load along with timestamp of when you attempted to open it?  Thanks!

Best Regards

[Rajiv-Dharia]

Hi,

I have a QlikView server 'Production server' and 'Development server'. Problem is happening when I am opening the final application from the Production server, as soon as I open the application it freezes and crashes the server. Below is the screen shot of the application with the size.

[cid:image001.png@01D8EE12.70DA3400]

This application also not accessible from Access point as it continue to load and it is not opening. Below is the error in the event log.

[cid:image002.png@01D8EE12.70DA3400]

Using the Binary load this application loads the data from below file which is in the Development server and it opens there without any problem though
[cid:image003.png@01D8EE12.70DA3400]

[RafaelBarrios]

hi @Chip_Matejowsky 

the screenshoots are not visible

Best,

[Chip_Matejowsky]

Hi @Rajiv-Dharia,

We're still unable to see the screen captures. Also, can you post the QVS Events log as I previously asked? Thanks!

Best Regards

[Rajiv-Dharia]

Hi,
Below is the error code from Event Viewer. As soon as we launch the application CPU spikes and it crashes the server some time. On Quick Access this application is not loading at all.
The description for Event ID 300 from source QlikViewServer cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:
[cid:image002.png@01D8EEDB.828A7470]

[cid:image001.png@01D8EED9.49C5BFC0]

[Chip_Matejowsky]

Hi @Rajiv-Dharia,

There are still no screen captures attached to your response. When replying to posts, there is a camera icon across the top of the message box that you can click to upload image files.

What do you mean by "Quick Access"? Are you referring to the QlikView AccessPoint?

It seems you provided just a snippet from the Windows Event Viewer Application logs, not the actual QlikView Server Events log that was requested. The Windows Event Viewer logs can be beneficial in troubleshooting, but are secondary to the actual QlikView Server logs. If you're unsure where to locate the QlikView Server logs, see Qlik Knowledgebase article How To Collect QlikView Server Log Files, and refer to the below section:

Service: QVS (QlikView Server)
Default Location: C:\ProgramData\QlikTech\QlikViewServer

Customized locations:  If you have changed the location from default, identify the correct path from the QlikView Management Console > System > Setup > QVS@node > Logging > Log Folder. Alternatively, review the settings.ini stored in C:\ProgramData\QlikTech\QlikViewServer\settings.ini for the value configured in  ServerLogFolder=

So please upload the screen captures and provide the QVS logs and provide the name of the QVW and the timestamp of when you attempted to open it. Thanks!

Best Regards