Solved

Filemaker random crash when sending email

Posted on 2013-06-11
6
1,784 Views
Last Modified: 2013-06-26
Hi experts. We're experiencing an intermittent issue with Filemaker.

We have FM server 11 and Filemaker 11 on our clients (5 clients)

I have written a script that sends an email (using Outlook), but the script occasionally causes FM to crash. This happens once "Send" is pushed in Outlook. It happens in FM 11 and 10 and Outlook 2010 and 2013. Here is the script:

Insert Calculated Result [Select; Mail::Sent On; Get ( CurrentDate ) &““ & Get ( CurrentTime)]
Commit Records/Requests [No dialog]
Set Field [Global Fields::G_SupportEmailTo; Mail::To]
Set Field [Global Fields::G_SupportEmailDate; Mail::cSent On Date]
Set Field [Global Fields::G_SupportEmailTime; Mail::cSent On Time]
If[IsEmpty ( Mail::To )]
Show Custom Dialog [“Send Support Email”; “There is no email address for this contact, so the email will be created to support@***.com...”]
Send Mail [Send via E-mail Client; To: “support@***.com.au”; CC: Mail::Cc; BCC: Mail::Bcc; Subject: Mail::Subject; Message: Mail::Body]
Insert Calculated Result [Select; Mail::Sent On; Get ( CurrentDate ) & “: “ & Get ( CurrentTime )]
Close Window [Current Window]
Adjust Window [Maximize]
Exit Script []
End If
Show Custom Dialog [“Send Job-related Email”; “An email will be sent to “& Mail::To & “ regarding this job. Make sure you change the FROM address...”]
Send Mail [Send via E-mail Client; To: Mail::To; CC: Mail::Cc; BCC: Mail::Bcc; Subject: Mail::Subject; Message: Mail::Body]
// If [Get(LastError)]
// Show Custom Dialog [“Message”; ‘There was an error addressing the email. Please check that your email software is installed correc.,.”]
// End If
Close Window [Current Window]
Adjust Window [Maximize]
Insert Calculated Result [Support: :Support Response; ¶ & ¶ & Global Fields::G_SupportEmailDate & “, “ & Global Fields: :G_SupportEmailTime & “ - “& Get(AccountName) &“ (Remote)”& l & “- Sent email to “ & ...
Exit Script []

(I've just starred out the email address in case bots come looking).

As I said, the issue occurs when we click "Send" in Outlook. Normally, the "send email" window in FM should close and data should be added to the Support::Support Response field.

However, when this issue occurs, the window does not close and an hourglass appears indefinitely in FM. If we click anywhere in FM, we get a Window saying: "This action cannot be completed because the other program is busy..."We can click "Switch To" or "Retry", but both crash FM.

When FM crashes, We get this in the event logs:

Log Name:      Application
Source:        Application Error
Date:          11/06/2013 4:49:15 PM
Event ID:      1000
Task Category: (100)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      PC01231
Description:
Faulting application name: FileMaker Pro Advanced.exe, version: 11.0.2.220, time stamp: 0x4c12006f
Faulting module name: FMOLE.dll, version: 11.0.2.220, time stamp: 0x4c11f959
Exception code: 0xc0000409
Fault offset: 0x0000c76d
Faulting process id: 0x11f8
Faulting application start time: 0x01ce66497b1c9189
Faulting application path: C:\Program Files (x86)\FileMaker\FileMaker Pro 11 Advanced\FileMaker Pro Advanced.exe
Faulting module path: C:\Program Files (x86)\FileMaker\FileMaker Pro 11 Advanced\FMOLE.dll
Report Id: 0745b525-d263-11e2-be8b-5453ed1e15f8
Faulting package full name:
Faulting package-relative application ID:
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Application Error" />
    <EventID Qualifiers="0">1000</EventID>
    <Level>2</Level>
    <Task>100</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-06-11T06:49:15.000000000Z" />
    <EventRecordID>9367</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Luke_Vaio.AltitudeIT.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>FileMaker Pro Advanced.exe</Data>
    <Data>11.0.2.220</Data>
    <Data>4c12006f</Data>
    <Data>FMOLE.dll</Data>
    <Data>11.0.2.220</Data>
    <Data>4c11f959</Data>
    <Data>c0000409</Data>
    <Data>0000c76d</Data>
    <Data>11f8</Data>
    <Data>01ce66497b1c9189</Data>
    <Data>C:\Program Files (x86)\FileMaker\FileMaker Pro 11 Advanced\FileMaker Pro Advanced.exe</Data>
    <Data>C:\Program Files (x86)\FileMaker\FileMaker Pro 11 Advanced\FMOLE.dll</Data>
    <Data>0745b525-d263-11e2-be8b-5453ed1e15f8</Data>
    <Data>
    </Data>
    <Data>
    </Data>
  </EventData>
</Event>

So basically, it looks like FMOLE.dll is crashing. But because this is so intermittent, it's difficult to troubleshoot. It might happen 1 time out of 10 or 20 for one person, and every second time for another. Some users seem to have the issue more than others.

Does anyone have any idea what might be causing this to happen?

Any advice or assistance would be appreciated.
0
Comment
Question by:lukerussell
  • 4
  • 2
6 Comments
 
LVL 24

Expert Comment

by:Will Loving
ID: 39238499
Although the forum post below refers to FMP 9, it might be helpful.

http://fmforums.com/forum/topic/60795-send-mail-script-step-crashes-fm9/

I'm not familiar with this issue but as an alternative you might consider trying using SMTP within FileMaker instead, which avoids the interaction with Outlook entirely. You can set it to BCC yourself if you want a copy of the email.

A small note on your script: I suggest you use the Set Field( ) script step instead of Insert Calculated Result( ). Set Field() can do exactly what Insert Calculated Result does, but removes the requirement to have the cursor in the field or even have the field on the layout. You simply have to be on a layout (including a blank one) based on the table you are trying to set the field value in (or that is related to the that table).

Also, you can use Get( CurrentTimeStamp ) or Get( CurrentHostTimeStamp ) to capture both the date and time together rather than concatenating the fields.
0
 
LVL 1

Author Comment

by:lukerussell
ID: 39239803
Thanks for the reply. I'd actually prefer to use the SMTP function, but we need our signatures in the email - which include a logo (thus the email needs to be HTML). As far as I can see, the smtp function in FM can only to text email. Is this right?
0
 
LVL 1

Author Comment

by:lukerussell
ID: 39239807
Hmmm. I wonder if this suggestion in your link will work:

My workaround of this problem is:
- create a new button
- use the function Openurl
- write this instruction:

"mailto: mail@example.com?subject=Test&body="&"test sending mail " & fieldname & "%0A this text is write on a new line..."
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39240007
You are correct about the FM Pro's capabilities regarding HTML emails, whether send  using the local client or SMTP.

As a developer, I've use the SMTPit Pro plugin for several years. It provides far more flexibility than the built-in options in FM, including HTML emails, multiple attachments, the ability to send Container field contents, etc.

http://www.cnsplug-ins.com/Plug-ins/smtpit_Pro
0
 
LVL 1

Author Comment

by:lukerussell
ID: 39252095
That looks good! I'll have a look at SMTPit Pro. Might solve a few other issues too...
0
 
LVL 1

Author Comment

by:lukerussell
ID: 39280384
SMTPit Pro looks like it will do the trick. Thanks willmcn.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now