topic Re: Wait(0), Wait() vs. Wait(n) in Discussions

Wait(0), Wait() vs. Wait(n)

DaveLee — Wed, 02 May 2018 18:32:40 GMT

I have a script that does many thing including creating a matrix from a datatable of ~17,500x40. The entire scrpit works fine when I run in in sections but fails to create the matrix when I run it as a whole. The issue appears to be at the step where m = dt << Get As Matrix();. I've inserted wait(0), wait() and even wait(30) but nothing seems to fix the issue. Any suggestions? Sorry I can't think of a way to share the code.

Thanks!

Re: Wait(0), Wait() vs. Wait(n)

uday_guntupalli — Wed, 02 May 2018 19:02:52 GMT

@DaveLee,
When you say, it fails to create a matrix - is it generating an error ?

May be ensure that the table is current might also help ?

Re: Wait(0), Wait() vs. Wait(n)

DaveLee — Wed, 02 May 2018 19:11:42 GMT

Yes, I explicitly call the table. For example, the data table is named 'dt', I create the matrix by the following m = dt << Get As Matrix();.

Re: Wait(0), Wait() vs. Wait(n)

uday_guntupalli — Wed, 02 May 2018 19:13:33 GMT

@DaveLee,
Can you share the error ? Also - a sample of your data to see if this is reproducible ?

Re: Wait(0), Wait() vs. Wait(n)

DaveLee — Wed, 02 May 2018 19:15:01 GMT

Sorry. I didn't answer your question. I do not get an error message but I've put in some checks to print to the log and stop seeing these after the matrix creation step.

Re: Wait(0), Wait() vs. Wait(n)

Craige_Hales — Wed, 02 May 2018 22:38:41 GMT

If there are formula columns that need to be evaluated, adding dt<<RunFormulas; before accessing the data might help.

Re: Wait(0), Wait() vs. Wait(n)

DaveLee — Thu, 03 May 2018 11:19:35 GMT

Thanks Craige, but the last step that finctions is just looping through a directory and cretaing a master file based on certain criteria. I know that data table is created. The very next step is "Get As Matrix' which does not happen.

Re: Wait(0), Wait() vs. Wait(n)

Mark_Bailey — Thu, 03 May 2018 13:03:22 GMT

It might be time to select Help > Books > Scripting Guide and review the section about formulas and formula management.

I advise against using formulas to populate data columns with a script unless it is necessary for the values to automatically update after the script is finished.

Re: Wait(0), Wait() vs. Wait(n)

Mark_Bailey — Thu, 03 May 2018 13:05:58 GMT

What do you mean by "looping through a directory and creating a master file?" What are the specific entities and actions involved?

Re: Wait(0), Wait() vs. Wait(n)

Craige_Hales — Thu, 03 May 2018 13:12:34 GMT

and... is JMP still running (can you submit JSL, use menus, change windows?) or is JMP in a loop (check task manager) or did JMP crash?