topic Re: Running Queries Menu bug? in Discussions

Running Queries Menu bug?

Franck_R — Sat, 10 Jun 2023 20:41:21 GMT

Hi everyone,

I think there is a problem with the "running queries menu" because I want to use this menu to prevent users of my queries from launching them several times queries when they run background.
So I thought I would use the jsl command:
Main Menu ("Running Queries");

That works fine... once!

Yes, because the problem is that once you close this window (manually or in jsl) it never reappears until you restart JMP!

A short video to show the problem with manual launching these window, close then no window anymore:

(view in My Videos)

Is this a bug? Known? Does anyone have a solution or a reset command that I could add to my jsl scripts?

I'm running JMP 15.2.1

Thank you!

Franck

Re: Running Queries Menu bug?

Georg — Thu, 26 Nov 2020 20:12:58 GMT

running JMP Pro 15.1.0 on Windows

I did never try before, but now I get a crash ("JMP has performed an Access Violation and will shut down"), every time when I start view->running queries the second time.

Perhaps you want to check this entry About Control Background queries:

https://community.jmp.com/t5/Discussions/Run-several-database-queries-ODBC-in-background-and-combine-data/m-p/274960#M53349

Re: Running Queries Menu bug?

Franck_R — Fri, 27 Nov 2020 08:13:28 GMT

OK so it definitely looks like a bug thanks!

For the scripts I've seen proposals in jsl to control the end of a query when you want to combine two queries for example but for my part I include the second one in a function triggered by an OnRunComplete because it's usually a big query and a small quick one behind it.
So I found that for my need to avoid users triggering several big queries without being aware that this is the case each time they press the script button, this display of query runnings was simple and efficient... Too bad it doesn't work!

Re: Running Queries Menu bug?

Georg — Fri, 27 Nov 2020 11:31:20 GMT

@Franck_R wrote:
OK so it definitely looks like a bug thanks!

For the scripts I've seen proposals in jsl to control the end of a query when you want to combine two queries for example but for my part I include the second one in a function triggered by an OnRunComplete because it's usually a big query and a small quick one behind it.
So I found that for my need to avoid users triggering several big queries without being aware that this is the case each time they press the script button, this display of query runnings was simple and efficient... Too bad it doesn't work!

Perhaps you can run your "Long" query in another instance of JMP in foreground, such that it is visible in the operating System, it's not too complicated. If you do not wish to Control it in your script.

Re: Running Queries Menu bug?

Craige_Hales — Fri, 27 Nov 2020 21:47:45 GMT

Re: Running Queries Menu bug?

Franck_R — Mon, 30 Nov 2020 16:54:49 GMT

Are you suggesting to create a new JMP's session for every request launched ? It seems complicated to me to manage...

Re: Running Queries Menu bug?

Craige_Hales — Tue, 01 Dec 2020 15:31:59 GMT

You are right, probably not a good choice. I've reported the problem of not re-running to the tech support folks.

Re: Running Queries Menu bug?

Franck_R — Tue, 01 Dec 2020 15:41:47 GMT

This solution is very interesting, it's just that I prefer not to complicate my scripts if I can do without it.
Thank you for reporting this bug

Re: Running Queries Menu bug?

Georg — Tue, 01 Dec 2020 15:47:46 GMT

I agree of Course to report and fix that bug, no Question.

The choice of how to do the Job is mostly at the author of the script - no Problem. It depends also on circumstances not visible here. "User interface design" when designing a script is a very challenging task needing lots of ressources and never finished.

Re: Running Queries Menu bug?

Audrey_Shull — Thu, 08 Apr 2021 14:55:34 GMT

Greetings - thank you so much for reporting this issue to JMP Development. I can report that it has been fixed in our next release -> JMP 16.1 will be available in a few months.

Re: Running Queries Menu bug?

Franck_R — Tue, 27 Apr 2021 13:23:25 GMT

Great! Thanks!