Qlik Sense Document Analyzer V1.5

Version 1.5 of the Qlik Sense Document Analyzer (QSDA) tool is now available for download here.

If you are not familiar with QSDA, it’s a free application profiling tool for Qlik Sense that can help you identify items such as unused fields, poorly performing expressions and data model problems.

Here are the significant changes in V1.5:

The Installer allows editing of all install paths and installation will create a log file in the User’s temp directory.

The  Summary ribbon at top of each sheet provides for sheet navigation by clicking a cell.

 

Improved error handling in the connector. Certain types of errors, such as a chart calculation timeout, will not terminate the script. Error count is reported on Summary sheet and detailed error messages can be viewed on the “Extract Log” sheet.

Items that should be considered incomplete due to analysis errors will highlighted in yellow.  This highlighting is a work-in-progress as I discover new possible errors.

Field widths (Symbol width) are no longer estimated! Field sizes are obtained directly from the engine.  Due to this change, this version will report different values for field sizes than previous releases, generally +/- 10%.

The connector edit dialog has been improved.  Error messages now appear properly in their own window and a progress bar displays when the list of applications is fetching.

If you have general usage questions on QSDA, please use the comments section here or Qlik Community.

If you have a bug to report, use the issue tracker.

The only installation supported by the installer is QS Desktop. You can use QS Desktop to analyze applications on a server.  It is possible to manually install on a server by uploading the application (qvf), the qsda-ribbon extension and the connector directory if you have the need and want to give it a shot.  I do plan to create a supported server installer in the future.

Have fun!

-Rob

Share

30 thoughts on “Qlik Sense Document Analyzer V1.5”

  1. Thanks for this Rob – great resource-again
    one question – the ribbon extension that is used qsda-ribbon
    It’s very neat – I take it this was installed with the exe file?

    I see the extension in my pc and the qvf file but not in QS as a useable extension in other apps?

  2. The ribbon extension is installed as a normal extension but hidden from the Custom Charts > Extensions list. I wanted to discourage people from using it for their own apps as I did not want to support compatibility between releases of DA. If there is interest I’ll create an open source version of the extension.

  3. It would be great to run it in batch across our whole server environment so we can identify problem apps?

    1. There is some work being done on batch analysis of multiple apps. Will post more as info becomes available.

  4. Hi Rob, first of all thank you for this great tool.

    We recently changed our default virtual proxy (No prefix) from NTLM to SAML authentication to take advantage of SSO using google business accounts.

    The NTLM authentication is still available using server_name/domain , and I tried to use that in the server string on appmeta connection but QSDA doesn’t seem to like this.

    Is there an alternative config so the tool works using the right Virtual Proxy?

    1. It should connect to the virtual proxy if you specify the proxy as part of the server like: “my.server/prox”. What error message are you getting?

      1. Hi, I’m getting

        ERROR: Cannot connect to Qlik Sense
        Connection failed after 4 attempts. Error message:
        GeneralCommunicationException with communication error WebSocketConnectionNotAccepted and http error code 500.

        In case it helps, if I run a data load anyway, it logs the following in stacktrace.txt (The txt is a bit too big to paste here)
        https://pastebin.com/MEqYDtg2

        1. Yes, the load won’t work because it uses the same connection methods that the connection editor does. I’m going to give you a qualified “don’t know” answer to this problem. You might try connecting to the same proxy in another browser tab and then try editing the connection in a another tab in the same window. More robust server connection and diagnosis is on the roadmap for the next update.

          1. No luck so far Flo.

            I’m just exporting the Apps and loading them into QS Desktop, which makes the usage of the QSDA a bit more difficult.

            We’ll try again in the next version if either the “server”+SSO or the NTLM “server/prox” logins work with QSDA

            Regards

  5. Oh, I’m getting the error using QS Desktop

    I’d try to test it directly from the Server but I don’t know how to install the custom connector there

    Cheers

  6. Hi Rob,

    We’re trying to get the Document Analyzer installed on a server, but are having trouble with MetaData Connector. It is installed in the C:\Program Files\Common Files\Qlik\Custom Data with the other connectors, but the appmeta data connection is still showing the ‘Unknown connection type: …’ error. If you could provide any clarification on manually installing these files to the server, it would be greatly appreciated.

        1. Hi Rob,
          We too have successfully imported the App and the Extension, and copied over the sub-folder for the connector, but get that same error of unknown connector type.

          Any further help you can offer would be greatly appreciated.

          1. Hi Mark,
            Which folder did you copy the connector to? Does the connector show up if you make a new connection?

          2. Rob – I copied the connector to \\[Server]\CustomData\, where I see other connectors.

            If I try to create a new connection, ‘appmeta’ does not show up as an option.

  7. Hi Rob, thanks for this great tool!
    Just wondering if you have plans to release a QSDA Comparison tool for regression testing?

    1. Sorry, just came across with your RUNNING QS REGRESSION TEST IN BATCH post. I guess that this approach using QSST is the substitution for what I was asking about.

      1. I do have a QDSA compare tool in the works. But as you discovered, QSST or NodeGraph is probably a better tool for regression testing,

  8. When I run my app through DA 1.5 it gives me error. I am not able to create a bug in Issue tracker. Error message attached below. Please advise, I can send the qvf if required
    QVX_UNKNOWN_ERROR: Object reference not set to an instance of an object.. Stack trace written to C:\ProgramData\QlikTech\Custom Data\QsAppMetadataConnector\Log\StackTrace.txt: SQL SELECT ObjectId, MasterDimensionLibraryId, DimensionName, DimensionLabel, ObjectDimensions_Error, ObjectDimensionPosition FROM ObjectDimensions

  9. I have installed QSDA on my desktop and it seems to work fine. However, I can’t get the connection setup to work against our server. I did not install anything on the server. I can edit the appmeta connector and choose Enterprise for environment. Then put in the server name and get the following error WebSocketConnectionNotAccepted. I have tried the IP Address and various other forms to no avail. We have a multi-node environment and I am pointing to the central node. Any suggestions?

    1. The server connection is made using NTLM. Is your server proxy set up to use windows authentication?

      1. Yes, it is. I tried adding specific ports as well. The server is on AWS, not sure if that makes a difference. The format I tried is as follows: https://servername.com/c1/, the same address does work in my browser URL. The C1 portion is the prefix to send through proxy and load balancer. I have tried with and without that bit.

Leave a Reply

Your email address will not be published. Required fields are marked *