Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
An new version, 1.2, of the Qlik Sense Document Analyzer is available for download:
Qlikview Cookbook: QS Document Analyzer http://qlikviewcookbook.com/recipes/download-info/qs-document-analyzer/
Updates for V1.2:
-Rob
Bug reported to me today. Listboxes and Filterpanes are not associating with Fields. I'll repost here as soon as a fix is available.
-Rob
Bug fixed. An updated v1.2.1 is available on the download site.
-Rob
Rob, thanks for the tool and your contributions. I am getting the following error:
The error occurred here:
AppInfo:
Load
*,
Hash128(AnalysisComputerName, AppName, date(AnalysisDatetime, 'YYYYMMDD_hhmmss')) & '_' as %KeyDocument
Here is the information from the StackTrace.txt file the error message says to look at:
System.TimeoutException: Method "OpenApp" timed out
at Qlik.Engine.Communication.QlikConnection.AwaitResponseTask
at Qlik.Engine.Hub.OpenApp(String docName, String userName, String password, String serial, Boolean noData)
at Qlik.Engine.LocationExtensions.App(ILocation location, IAppIdentifier appIdentifier, ISession session, Nullable`1 noVersionCheck, Boolean noData)
at . ()
at . .MoveNext()
at QlikView.Qvx.QvxLibrary.QvxConnection.WriteTableItemsToStream(QvxDataTable table, Stream pipeStream)
at QlikView.Qvx.QvxLibrary.QvxConnection.InternalExecute(DataPipe dataPipe, QvxDataTable table, Action`1 onError, Action clearMExecuteError)
Any ideas how I can resolve this?
Hi Michael,
Does it timeout for just this one app or small apps as well?
-Rob
Just this one app, which is quite large. Other/"smaller" apps work fine.
Thanks Rob!
Having the same issue here. Is there a setting we can tweak so it doesn't timeout?
My app is about 1GB in size on disc and desperately need to optimize but would like to know where to start 🙂
Thank you in advance.
Michael's problem turned out to be caused by Section Access, not a true timeout. Does your app have section access?
-Rob
Yes group, my issue was Section Access.
Rob, I have been able to run a few of our apps through DA. One found 304 unused fields, out of a possible 358. Is there a panel that lists the DROP FIELDS command like the Qlik View version? If so, which tab is it on? If not we can export the list and create the command ourselves, just wanted to check with you first. Thank you!
No, it doesn't have section access. For now i ended up partially loading the data until it was about 20% or 200MB of original size. Then doc analyzer worked and i was able to find unused fields. Offcourse calculation times etc. are a bit skewed now... 🙂