EasyQlik Community

QSDA Pro Connection to QS Enterprise

Have been playing with version 0.3.1-Alpha and have been able to connect to local QS Desktop and analyze apps there but want to connect to QS Enterprise to analyze apps for fields used in community sheets. I’ve tried connections Certificate, NTLM and Windows, using ports 80, 443, 4243. I entered the fully qualified name of the server, the hub HTTPS address and the app link and no luck connecting. Not sure what I’m missing here!

Are you still having issues or did you get it working?

Yes, connected to QS Enterprise but hitting a timeout on the two apps I analyzed. Playing with it and some settings now.

I imagine you are trying to resolve using the Timeout setting. In the next build I’ll have a bookmark option that you can use to select a bookmark and therefore do the object calculations with a smaller dataset.

Yes - on our smallest app that is 15MB I get the Server Error that the request was cancelled due to the configured HttpClient Timeout of 100 seconds elapsing. Suggestions or possibly better to run on Server vs. from my laptop to the Enterprise Hub?

It shouldn’t make a difference where QSDA is run from. Did you get that error during the analysis? Did you change the Timeout setting (not the same as the Http timeout) on the Analysis options? Can you send me the qsda-YYYY-MM-DD.log? It’s in
\Users\userid\AppData\Local\EasyQlik\QSDA\log

Yes, I changed the timeout in the QSDA from 90 to 120 and will change our QMC Proxy timeout from 100 to 120. I was able to get one app to successfully process and it picked up Private Sheets! :grinning:
For the app that was in error, the site is not allowing me to upload the log file. Error below on one app that failed. I could not find the Object ID sited via the QMC:

2021-03-17 10:56:07.7193 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:de87ffe3-da04-4558-a185-86df1db6d08d) in GetVizObjects; Error processing object: de87ffe3-da04-4558-a185-86df1db6d08d (qlik-date-picker): Object ‘de87ffe3-da04-4558-a185-86df1db6d08d’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:11.7651 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:eab31c20-1c78-43f8-b382-e377eff37563) in GetVizObjects; Error processing object: eab31c20-1c78-43f8-b382-e377eff37563 (qlik-date-picker): Object ‘eab31c20-1c78-43f8-b382-e377eff37563’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:15.6948 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:3aaea00a-5daf-4181-8a3a-f0cbcac9b9bc) in GetVizObjects; Error processing object: 3aaea00a-5daf-4181-8a3a-f0cbcac9b9bc (qlik-date-picker): Object ‘3aaea00a-5daf-4181-8a3a-f0cbcac9b9bc’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:19.5088 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:b136746e-ac90-46c3-aff8-01a99472701e) in GetVizObjects; Error processing object: b136746e-ac90-46c3-aff8-01a99472701e (qlik-date-picker): Object ‘b136746e-ac90-46c3-aff8-01a99472701e’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:19.8362 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:4e0fa898-671c-4553-b249-8bc3d58f8554) in GetVizObjects; Error processing object: 4e0fa898-671c-4553-b249-8bc3d58f8554 (qlik-date-picker): Object ‘4e0fa898-671c-4553-b249-8bc3d58f8554’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:20.9251 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:9afc0fef-b187-4eb3-81a6-5ee14431d26f) in GetVizObjects; Error processing object: 9afc0fef-b187-4eb3-81a6-5ee14431d26f (qlik-date-picker): Object ‘9afc0fef-b187-4eb3-81a6-5ee14431d26f’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:33.0619 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:e059e853-8caf-49a7-88cb-205b1706b069) in GetVizObjects; Error processing object: e059e853-8caf-49a7-88cb-205b1706b069 (qlik-date-picker): Object ‘e059e853-8caf-49a7-88cb-205b1706b069’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:39.9792 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:41ec146b-2904-4db2-9e0d-1145289b7b0a) in GetVizObjects; Error processing object: 41ec146b-2904-4db2-9e0d-1145289b7b0a (qlik-date-picker): Object ‘41ec146b-2904-4db2-9e0d-1145289b7b0a’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:43.3475 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:6dbb7ef6-0c40-4cdb-ac0d-1013aad38863) in GetVizObjects; Error processing object: 6dbb7ef6-0c40-4cdb-ac0d-1013aad38863 (qlik-date-picker): Object ‘6dbb7ef6-0c40-4cdb-ac0d-1013aad38863’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:43.9342 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:873f0fc4-9403-496e-b733-f9f8eb85472b) in GetVizObjects; Error processing object: 873f0fc4-9403-496e-b733-f9f8eb85472b (qlik-date-picker): Object ‘873f0fc4-9403-496e-b733-f9f8eb85472b’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:44.3336 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:b36318ff-88cd-4f62-a988-08cf9573c5cd) in GetVizObjects; Error processing object: b36318ff-88cd-4f62-a988-08cf9573c5cd (qlik-date-picker): Object ‘b36318ff-88cd-4f62-a988-08cf9573c5cd’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:44.6636 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:08776f8c-24ae-4e58-b5f2-3d40555664dc) in GetVizObjects; Error processing object: 08776f8c-24ae-4e58-b5f2-3d40555664dc (qlik-date-picker): Object ‘08776f8c-24ae-4e58-b5f2-3d40555664dc’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:46.0488 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:a90ae8ce-fb85-46cb-a322-f8ca1c22884a) in GetVizObjects; Error processing object: a90ae8ce-fb85-46cb-a322-f8ca1c22884a (qlik-date-picker): Object ‘a90ae8ce-fb85-46cb-a322-f8ca1c22884a’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:46.9181 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:509e38e2-290f-4b1f-8cab-da1c846707db) in GetVizObjects; Error processing object: 509e38e2-290f-4b1f-8cab-da1c846707db (qlik-date-picker): Object ‘509e38e2-290f-4b1f-8cab-da1c846707db’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:56:47.0856 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:f666c05b-a44d-4d1c-b870-1a263c99ebe3) in GetVizObjects; Error processing object: f666c05b-a44d-4d1c-b870-1a263c99ebe3 (qlik-date-picker): Object ‘f666c05b-a44d-4d1c-b870-1a263c99ebe3’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 10:57:11.8736 Qsda.MetaCollector.GetVizObjects Error CollectorError: Viz: qlik-date-picker / ??? (Sheet:) (Id:d0b71267-f0be-4b57-9dae-61a9a7d2dfcf) in GetVizObjects; Error processing object: d0b71267-f0be-4b57-9dae-61a9a7d2dfcf (qlik-date-picker): Object ‘d0b71267-f0be-4b57-9dae-61a9a7d2dfcf’ claims to extend nonexsistent object ‘c142892d-c383-4437-ae21-ec760c642b68’.;
2021-03-17 11:01:46.9362 Qsda.MetaCollector+.MoveNext Error Error in Collection process: Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object.
at StackTraceGetter(Object )
at System.Text.Json.JsonPropertyInfo1.GetMemberAndWriteJson(Object obj, WriteStack& state, Utf8JsonWriter writer) at System.Text.Json.Serialization.Converters.ObjectDefaultConverter1.OnTryWrite(Utf8JsonWriter writer, T value, JsonSerializerOptions options, WriteStack& state)
at System.Text.Json.Serialization.JsonConverter1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state) at System.Text.Json.Serialization.Converters.ListOfTConverter2.OnWriteResume(Utf8JsonWriter writer, TCollection value, JsonSerializerOptions options, WriteStack& state)
at System.Text.Json.Serialization.Converters.IEnumerableDefaultConverter2.OnTryWrite(Utf8JsonWriter writer, TCollection value, JsonSerializerOptions options, WriteStack& state) at System.Text.Json.Serialization.JsonConverter1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
at System.Text.Json.JsonPropertyInfo1.GetMemberAndWriteJson(Object obj, WriteStack& state, Utf8JsonWriter writer) at System.Text.Json.Serialization.Converters.ObjectDefaultConverter1.OnTryWrite(Utf8JsonWriter writer, T value, JsonSerializerOptions options, WriteStack& state)
at System.Text.Json.Serialization.JsonConverter1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state) at System.Text.Json.Serialization.JsonConverter1.WriteCore(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
at System.Text.Json.Serialization.JsonConverter`1.WriteCoreAsObject(Utf8JsonWriter writer, Object value, JsonSerializerOptions options, WriteStack& state)
at System.Text.Json.JsonSerializer.WriteCore[TValue](JsonConverter jsonConverter, Utf8JsonWriter writer, TValue& value, JsonSerializerOptions options, WriteStack& state)
at System.Text.Json.JsonSerializer.WriteCore[TValue](Utf8JsonWriter writer, TValue& value, Type inputType, JsonSerializerOptions options)
at System.Text.Json.JsonSerializer.Serialize[TValue](TValue& value, Type inputType, JsonSerializerOptions options)
at System.Text.Json.JsonSerializer.Serialize[TValue](TValue value, JsonSerializerOptions options)
at Qsda.Shared.Persistence.CollectionFileRepository.(Object , String )
at Qsda.Shared.Persistence.CollectionFileRepository..MoveNext()

Good to hear you got Private Sheets!

I’ve updated the site settings here to allow *.log files. Can you try to upload the log again? If it’s really large, you can delete (or rename) the existing log and recreate the problem so it has only the problem app in the log.

Files Added - anything initial thoughts for me to look at from my side to help troubleshoot? Excited about this and to help out!

errorlog.19.log (100.7 KB) errorlog.20.log (179.1 KB) qsda-errorlog.log (122.9 KB)

There should be a more detailed log of the form qsda-YYYY-MM-DD.log. Can you find that and upload it?

File from this morning attached. Other logs were too large to upload. Lesson learned that when the errors occur to stop the user interface in the control panel to stop the logs from writing. Please let me know if there’s anything else or something you want me to look at.qsda-2021-03-19.log (3.4 MB)

Still looking at this one but you may want to try the 0.3.2 build in the meantime. I fixed several issues, but I need to recreate your situation to see if I plugged the holes.

Hi Rob - I tried the 3.2 version and selected None for Bookmarks. It didn’t give the HTTP Proxy error but stopped with an error. The log it wrote analyzing the one app is almost 10MB and there’s a limit on the upload. Let me know if I can zip it or if there is a portion of the log you want me to trim out.

Hi Jerry, you can try zipping it if that will make it smaller enough. Otherwise, you can start by uploading the error log and tehn I can give you some feedback as to what portion of the log I need.

Zip File was small enough but the extension isn’t allowed in the uploads - I broke the log into three parts, let me know if this works.

qsda-2021-03-22.log (2.9 MB) qsda-2021-03-22_part2.txt (3.0 MB) qsda-2021-03-22_part3.log (3.7 MB)

Thanks. I’ve added zip to the allowable extensions for the future. I’ll take a look at these in the meantime.

Hi Jerry,
We’re getting closer. Please try this 0.3.3 build https://easyqlik.com/dmgr/?file=Qsda_Pro_Setup_033.zip. I expect a lot of soft errors but hopefully will run to completion.

Hi Rob - great news (and a little bad news).

Running the 3.3. build on prem on one of our Qlik Servers, I was able to get a completion and analysis!

Running the 3.3 build remote from my laptop on the same as app as above over VPN generated the Proxy Timeout error again.

Both logs attached in ZIP files and named as such

qsda-2021-03-23_proxyerror.zip (278.4 KB) qsda-2021-03-23_complete.zip (327.4 KB)

Rob - on a larger app hit the HTTP error running it from the on prem server. Log attached.qsda-2021-03-23_withError.zip (587.1 KB)

I am also trying to connect to QS Enterprise, though without any success. We dont have a certificate set up and is not set up as a secure connection. I have tried a number of different ways to connect, could anyone provide any pointers for a successful connection to QS Enterprise, default port/connection type to use etc?