Jump to content

FM Server and Enter FInd Mode / Perform Find Mode--script fails


This topic is 622 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We're running FM Server 19.5.1.43 with a hosted file that I set up to run as a scheduled script that would send e-mails to people notifying them that their certificate or license needs renewing. However, it fails every time it runs. As a troubleshooting step, I disabled all the script steps, created a new one with a Perform Find on  CertExpiration__lxd field (with * as the operator), and attempted to run the script again from the server. It failed again.

According to the Help documentation, Perform Find should execute without problems but upon looking at Enter Find Mode in Help, it's only partially supported by the server; it doesn't say why it's only partially supported nor any alternatives to use because it's not fully executable.

Is there a kernel of knowledge or workarounds I can use? TIA for your help!

Screen Shot 2022-07-15 at 10.27.37 AM.png

Link to comment
Share on other sites

Here ya go:

 

2022-07-15 11:10:23.967 -0500    Information    146    fmp19    Schedule "Cert_License_Expiration_Notice" run now by "esu7".
2022-07-15 11:10:23.967 -0500    Information    689    fmp19    Schedule "Cert_License_Expiration_Notice" has started FileMaker script "E-mail Notification that Certificate/License is up for Renewal".
2022-07-15 11:10:24.138 -0500    Information    645    fmp19    Schedule "Cert_License_Expiration_Notice" scripting error (103) at "ESU7CRM : E-mail Notification that Certificate/License is up for Renewal : 25 : Perform Find".
2022-07-15 11:10:24.154 -0500    Information    645    fmp19    Schedule "Cert_License_Expiration_Notice" scripting error (101) at "ESU7CRM : E-mail Notification that Certificate/License is up for Renewal : 45 : Go to Record/Request/Page".
2022-07-15 11:10:24.170 -0500    Information    644    fmp19    Schedule "Cert_License_Expiration_Notice" completed; last scripting error (101).
2022-07-15 11:10:24.170 -0500    Information    126    fmp19    Schedule "Cert_License_Expiration_Notice" scheduled for 07/16/2022 06:00 AM.

Link to comment
Share on other sites

One quick one to reduce errors is on line 44 (above go to record next )  add this step, it will remove the 101 errors. 

Exit Loop If ( Get(RecordNumber) = Get(FoundCount )  ) 

Error 103 is Relationship Missing you need to go to the correct context so you need to add Go To Layout

You may try to delete the Enter Find Mode and Perform Find steps, save the script and re add these and try again.

 

 

Link to comment
Share on other sites

This topic is 622 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.