Tuesday, August 20, 2019

#1 2019-07-17 09:59:33 pm

bwill
Member
Registered: 2019-07-17
Posts: 4

Error “Internal Table Overflow” when executing a script

Hi,

I'm communicating between my app and Filemaker with AppleScript. A couple of users have reported the above error message in Filemaker.

My app does an AppleScript which tells Filemaker to execute a Filemaker script. Because this is done async the Filemaker script ends with sending an horribly simple AppleScript back to my app:

"tell application id \"com.mothsoftware.mailarchiverx\"¶
ignoring application responses¶
«event M" & Right ("0000000" & Mail::RecID; 7 ) & "»¶
end ignoring¶
end tell"

As result of the error the AppleEvent isn't sent and my app goes into timeout. I had Goggled a bit the error message. But the only references I found were for huge scripts.

Does anyone have an idea how I can fix my AppleScript so that I don't get the error message anymore.

Regards

Beatrix Willius

Offline

 

#2 2019-07-17 10:49:57 pm

KniazidisR
Member
Registered: 2019-03-03
Posts: 425

Re: Error “Internal Table Overflow” when executing a script

The most likely reason for generating such an error is that the user has not installed some scripting addition necessary for the script to work correctly

Last edited by KniazidisR (2019-07-17 10:55:23 pm)


macOS Mojave -- version 10.14.4
Safari -- version 12.1

Offline

 

#3 2019-07-17 10:53:38 pm

bwill
Member
Registered: 2019-07-17
Posts: 4

Re: Error “Internal Table Overflow” when executing a script

Scratching head... Which scripting addition should be necessary for sending a raw AppleEvent? The error usually happens after having processed a couple of thousand emails and not at the beginning.

Regards

Beatrix Willius

Offline

 

#4 2019-07-17 11:55:09 pm

Shane Stanley
Member
From:: Australia
Registered: 2002-12-07
Posts: 5825

Re: Error “Internal Table Overflow” when executing a script

Internal table overflow generally means a script is too complex. It's often caused by scripts that are too long, but it can also be caused by things like too much nesting or too much recursion.

I'm pretty sure FileMaker uses a single instance of AppleScript to run all scripts, so it's possible your script is just tipping things over the edge. Probably the best suggestion is for users to quit and relaunch FileMaker, and see if it goes away.


Shane Stanley <sstanley@myriad-com.com.au>
www.macosxautomation.com/applescript/apps/
latenightsw.com

Offline

 

#5 2019-07-18 12:06:45 am

KniazidisR
Member
Registered: 2019-03-03
Posts: 425

Re: Error “Internal Table Overflow” when executing a script

Now I see, with scripting addition I was wrong. But...
Logically, if you send this event repeatedly, without waiting for a response from the Mail ArchiverX, and Mail ArchiverX does not have time to process them, then this events accumulate in the queue and overflows the memory. You can add the necessary delay immediate after the event sending to solve this problem

Applescript:

tell application id "com.mothsoftware.mailarchiverx"
ignoring application responses
«event M" & Right ("0000000" & Mail::RecID; 7 ) & "»
delay 0.5
end ignoring
end tell

Last edited by KniazidisR (2019-07-18 12:16:49 am)


macOS Mojave -- version 10.14.4
Safari -- version 12.1

Offline

 

#6 2019-07-18 12:09:45 am

Shane Stanley
Member
From:: Australia
Registered: 2002-12-07
Posts: 5825

Re: Error “Internal Table Overflow” when executing a script

KniazidisR wrote:

Logically, if you send this event repeatedly, without waiting for a response from the addressee, and this addressee does not have time to process them, then this events accumulate in the queue and overflows the memory.



I missed the ignoring application responses in the original code -- your explanation could well be on the money.


Shane Stanley <sstanley@myriad-com.com.au>
www.macosxautomation.com/applescript/apps/
latenightsw.com

Offline

 

#7 2019-07-18 12:20:14 am

bwill
Member
Registered: 2019-07-17
Posts: 4

Re: Error “Internal Table Overflow” when executing a script

Thanks, that makes sense. Doing the async processing is a bit annoying. When my app gets the AppleEvent the next email is processed. I don't really like the idea of a delay because speed is important. But I'll try a smaller delay.

Regards

Beatrix Willius

Offline

 

#8 2019-07-18 02:17:48 pm

danwan
Member
Registered: 2008-03-21
Posts: 209

Re: Error “Internal Table Overflow” when executing a script

Beatrix
I'd rather lose some time with a proper delay than attempting close Filemaker, restart the machine, perform a checkup with DiskUitility, rebuilt the directory with DiskWarrior and get the very same error at more or less 4000 mails.
In any case, when the mails to archive are several, nothing else can be done with the Mac. So minutes, or half hours, or even hour more will be welcome if the FMP database would collect whatever is needed soundly

Danwan

Model: MacBook PRO
Browser: Safari 537.36
Operating System: macOS 10.14


Filed under: table, Internal, overflow

Offline

 

#9 2019-07-18 04:47:10 pm

kerflooey
Member
Registered: 2011-07-07
Posts: 164

Re: Error “Internal Table Overflow” when executing a script

Hi. If plugins are an option, I've never had any timing problems using Applescript and SMTPit Pro with Filemaker Pro for bulk emailing. https://www.cnsplug-ins.com/Plug-ins/SMTPit_Pro

Offline

 

#10 2019-07-18 09:49:44 pm

bwill
Member
Registered: 2019-07-17
Posts: 4

Re: Error “Internal Table Overflow” when executing a script

@danwan: yeah, you are right.

@kerflooey: plugins aren't an option. My solution handles mailbox selection, LaunchAgents and much more which Filemaker can't do or the interface would be very poor.

Regards

Beatrix Willius

Offline

 

Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)