Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

??FileMaker Invalid Page Fault??

ldebondt
in Calculation Engine (Define Fields)

Featured Replies

I am getting the following error when trying to do a calculation in a field. Can anybody explain what this means?

FILEMAKER PRO caused an invalid page fault in

module FMFC10.DLL at 017f:006ed28e.

Registers:

EAX=00000070 CS=017f EIP=006ed28e EFLGS=00010202

EBX=5f401901 SS=0187 ESP=009ab9c8 EBP=009aba3c

ECX=00fee9f4 DS=0187 ESI=00fec2f0 FS=67f7

EDX=00fec2f0 ES=0187 EDI=bff555a7 GS=0000

Bytes at CS:EIP:

3b 50 04 74 09 8b 00 85 c0 75 f5 c2 04 00 50 ff

Stack dump:

006fccfe 00fec2f0 bff555a7 00fec2f0 00fec2f0 00fec2f0 009abab0 007051ce 00000001 006fcca2 00fec2f0 5f4019fa 006fcd5b 00000001 5f4056c7 00fec2f0

The calculation is a Case/If Statement:

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B25 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B22 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B20 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B18 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B16 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B14 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B12 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B10 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B07 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B05 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B03 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "") +

Case(Benefit = "Non-Benefit" , "" ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation <2 , (7 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=2 and VacationCalculation <5 , (8 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=5 and VacationCalculation <10 , (9 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=10 and VacationCalculation <15 , (10 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=15 and VacationCalculation <20 , (12 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=20 and VacationCalculation <25, (14 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=25 and VacationCalculation <30 , (16 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >=30 and VacationCalculation <35 , (18 * FTE) ,

If(not IsEmpty(B01 Time Sheet) and VacationCalculation >35 , (20 * FTE) , "")

Could it be that this is just to busy for FileMaker to handle in one field???

I started to answer this by suggesting that you replace the "and" in your calculation with the "&" and see what happens. However, as I look at the error message, I realize I have never seen this one before (I'm on a Mac though) so I thought maybe beyond changing the "and" out, I should know more about what the other fields are involved, as to what they contain (you might be mixing numbers, and text or something) and, I should probably know what the end result from this calculation is suppose be.

So, if the changing the calculation doesn't work, let me know.

BTW, I don't think the calculation is "to busy,", for one thing, I do have longer calculations then this that work.

HTH

Lee ooo.gif

A page fault error is an operating system memory error, not a FileMaker error, per se. Are you running out of RAM on your system. Try this with only FM running.

-bd

  • Author

Restructured as a Case statement and works fine.

Create an account or sign in to comment

https://fmforums.com/topic/13926-filemaker-invalid-page-fault/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.