AnsweredAssumed Answered

PSoS Record Locking . (I think)

Question asked by sam.gedert on May 8, 2018
Latest reply on May 8, 2018 by Jason Wood

Morning FileMakers,

 

I'm using 360Works CloudMail plugin to send out email blasts from my system. Takes a lot of configuring, but I love it.

 

I have a schedule set on my server to run every 15 minutes to look for email campaigns that have been queued to be sent.


This works well almost all of the time.  The issue, I believe, is that if someone happens to be in the record when the schedule runs, I'm getting a series of errors and the email doesn't go out.  Error log below.

 

 

Is there a way to lock a record or kick someone out of it before this process runs?

 

 

Tue May 08 09:38:02 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" completed; last scripting error (301).

Tue May 08 09:38:02 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scheduled for 05/08/2018 09:39 AM.

Tue May 08 09:38:02 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (101) at "KS_CORN : CM - Send to found set (Mail Merge) : 62 : Go to Record/Request/Page".

Tue May 08 09:38:02 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (-1) at "KS_CORN : CM - TinyMCE - StartUp : 3 : Set Web Viewer".

Tue May 08 09:38:02 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (301) at "KS_CORN : CM - Send to found set (Mail Merge) : 72 : Set Field".

Tue May 08 09:38:02 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (301) at "KS_CORN : CM - Send to found set (Mail Merge) : 73 : Set Field".

Tue May 08 09:38:00 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (103) at "KS_CORN : CM - Find Email universe - Send : 85 : Set Field".

Tue May 08 09:38:00 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (3) at "KS_CORN : CM - Find Email universe - Send : 4 : Freeze Window".

Tue May 08 09:38:00 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (401) at "KS_CORN : CM - Find Email universe - Send : 59 : Perform Find".

Tue May 08 09:38:00 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (101) at "KS_CORN : CM - Find Email universe - Send : 60 : Go to Record/Request/Page".

Tue May 08 09:38:00 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" scripting error (301) at "KS_CORN : CM - Scheduled Send : 26 : Set Field".

Tue May 08 09:38:00 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" running.

Tue May 08 09:38:00 EDT 2018 Server Events Information Schedule "KS Corn - Scheduled Send" has started FileMaker script "CM - Scheduled Send".

Outcomes