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

[#1]

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!

[#2]

@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 ? 

[#3]

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();. 

[#4]

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

[#5]

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.

[#6]

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

[#7]

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.  

[#8]

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.

[#9]

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

[#10]

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?