topic QS Document Analyzer V1.2 is available in App Development

QS Document Analyzer V1.2 is available

rwunderlich — Wed, 04 Apr 2018 10:09:35 GMT

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:

Fixed errors when empty Variable or Measure.
Added ErrorLog table to data model. This table will record errors detected during the analysis process, e.g. Connector errors.
Improved DA data model.
The connector now extracts additional expressions such as Color By and Reference Lines.
New attribute “Expression Location” identifies where in the object an expression is used.
New attribute “Expression Table Count” attempts to identify multi-table expressions, which may be poor performers.
New MasterDimension attributes “Master Dimension Label Conflict” and “Master Dimension Def Conflict” attempt to highlight possibly ambiguity in Dimension definitions.
New expression attributes “Has Set Analysis” and “Uses Variable”.
Expression Function usage analysis.
Possible to define “initial selections” to be made by the connector before calculating objects.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QS Document Analyzer V1.2 is available

rwunderlich — Thu, 05 Apr 2018 11:59:06 GMT

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

Re: QS Document Analyzer V1.2 is available

rwunderlich — Thu, 05 Apr 2018 12:46:22 GMT

Bug fixed. An updated v1.2.1 is available on the download site.

-Rob

Re: QS Document Analyzer V1.2 is available

Tanalex — Thu, 05 Apr 2018 20:41:35 GMT

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(T task, String methodName, CancellationToken cancellationToken)

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?

Re: QS Document Analyzer V1.2 is available

rwunderlich — Fri, 06 Apr 2018 11:02:00 GMT

Hi Michael,

Does it timeout for just this one app or small apps as well?

-Rob

Re: QS Document Analyzer V1.2 is available

Tanalex — Fri, 06 Apr 2018 14:18:50 GMT

Just this one app, which is quite large. Other/"smaller" apps work fine.

Thanks Rob!

Re: QS Document Analyzer V1.2 is available

arjandenouden — Sun, 06 May 2018 04:08:17 GMT

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.

Re: QS Document Analyzer V1.2 is available

rwunderlich — Mon, 07 May 2018 14:28:33 GMT

Michael's problem turned out to be caused by Section Access, not a true timeout. Does your app have section access?

-Rob

Re: QS Document Analyzer V1.2 is available

Tanalex — Mon, 07 May 2018 21:23:09 GMT

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!

Re: QS Document Analyzer V1.2 is available

arjandenouden — Tue, 08 May 2018 04:05:49 GMT

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... 🙂

Re: QS Document Analyzer V1.2 is available

arjandenouden — Tue, 08 May 2018 04:06:53 GMT

Hi Michael,

I was looking for the list as well, but i just exported the table to excel and put comma's around it.

Re: QS Document Analyzer V1.2 is available

rwunderlich — Fri, 11 May 2018 14:46:43 GMT

I removed the DROP fields list because there was no easy way to copy it to clipboard with native QS. I'll add something back in a future update.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QS Document Analyzer V1.2 is available

rwunderlich — Fri, 11 May 2018 14:47:59 GMT

I've got a fix for the timeout in development. If you want to test it before it's released reach out to me at

Contact | Qlikview Cookbook

Re: QS Document Analyzer V1.2 is available

rwunderlich — Mon, 14 May 2018 15:24:27 GMT

For those of you who have been experiencing timeouts with QS Document Analyzer, a new update V1.2.2 is available for download. A configurable timeout property has been added. The default is 90 seconds.

-Rob

Re: QS Document Analyzer V1.2 is available

lightsection — Tue, 03 Jul 2018 15:20:53 GMT

I am getting a similar error. Is there a fix or workaround for this situation ?

The app I am trying to analyze is roughly around 800 Mb. And has a lot of sheets and measures. Any help is appreciated.

Re: QS Document Analyzer V1.2 is available

lightsection — Tue, 03 Jul 2018 17:29:54 GMT

Where can configure the timeout in the analyzer ? I couldn't find this setting anywhere.

Re: QS Document Analyzer V1.2 is available

arjandenouden — Wed, 04 Jul 2018 07:28:29 GMT

it is configured in C:\Program Files (x86)\Common Files\Qlik\Custom Data\QsAppMetadataConnector\QsAppMetadataConnector.exe.config

See page 4 of the manual

Re: QS Document Analyzer V1.2 is available

lightsection — Thu, 05 Jul 2018 14:02:48 GMT

Thanks, got it. I just tried changing the time out value, unfortunately it didn't solve the problem

Re: QS Document Analyzer V1.2 is available

rwunderlich — Thu, 19 Jul 2018 22:05:45 GMT

Does the app have Section Access?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com