topic Re: Sense Script Load Analyzer - Connection monitor_apps_REST_app not found in App Development

Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

dana — Wed, 18 Sep 2024 08:20:40 GMT

Hi People,

I have installed the app Sense-Script-Load-Analyzer.qvf,

and changed the app owner - as requested.

When loading, I get the error message:

Connection monitor_apps_REST_app not found.

Any idea how I an resolve this?

Are there any alternatives for this tool?

Thanks!

Edit: the specific issue was resolved, as @rwunderlich suggested, but after overcoming the connection issue, another issue came up.

Re: Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

rwunderlich — Sun, 15 Sep 2024 15:17:18 GMT

Where did you install this app from?

-Rob

Re: Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

dana — Sun, 15 Sep 2024 15:45:36 GMT

Hi,

Downloaded it from here:

https://qlikviewcookbook.com/recipes/download-info/script-log-analyzer/

Re: Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

rwunderlich — Mon, 16 Sep 2024 15:37:32 GMT

I didn't recognize that even though it's from my site 🙂

You need to define the monitor_apps_REST_app connection. I believe it should be there by default in your Qlik Sense server. Is this on-prem or Cloud? If on-prem, check the QMC for the connection and make sure you have security access to it.

-Rob

Re: Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

dana — Mon, 16 Sep 2024 16:49:35 GMT

Hi @rwunderlich,

We proceed 🙂

Now I'm getting this error:

Thank you!

Re: Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

rwunderlich — Wed, 18 Sep 2024 17:37:39 GMT

Probably means no log files were loaded. Take a look at the script log and see if it is finding any log files.

-Rob

Re: Sense Script Load Analyzer - Connection monitor_apps_REST_app not found

dana — Thu, 19 Sep 2024 05:50:37 GMT

Hi Rob,

I checked, and the log files are loaded. For example:

20240916T194731.770+0300 2187 Qvc.ListFilesTable:
20240916T194731.770+0300 2188 LOAD
20240916T194731.770+0300 2189 'lib://ArchivedLogsFolder/mg-sense/Script/f7731e81-a639-4b6e-95ad-eecd7752e326.20240916T190825.254+0300.CAA7B853CF2C02285EA7.log' as [File Path]
20240916T194731.770+0300 2190 AutoGenerate 1
20240916T194731.770+0300 1 fields found: File Path,
20240916T194731.770+0300 1,983 lines fetched

The issue seems to be here:

20240916T194731.790+0300 3975 temp:
20240916T194731.790+0300 3976 NoConcatenate Load *
20240916T194731.790+0300 3977 Resident [Qvc.ListFilesTable]
20240916T194731.790+0300 3978 where
20240916T194731.790+0300 3979 Exists(App,SubField(SubField([File Path],'/',-1),'.',1))
20240916T194731.790+0300 3980 and SubField(SubField([File Path],'/',-1),'.',1) <> '62c37e1f-0c24-4cc7-b5b9-e2633b9b36f2'
20240916T194731.790+0300 1 fields found: File Path,
20240916T194731.794+0300 0 lines fetched

The relevant script is:

temp:
NoConcatenate Load *
Resident [Qvc.ListFilesTable]
where
Exists(App,SubField(SubField([File Path],'/',-1),'.',1))
and SubField(SubField([File Path],'/',-1),'.',1) <> '$(myID)' // not processing myself
;

Thank you!