Stephen Douglas

I just found this additional FMSA uninstall guide which lists additional info I did not have at time of upgrade, maybe if Id followed this I would be OK specifically IIS stuff etc. Any thoughts. in installing FileMaker Server 9 and FileMaker Server 9 Advanced. If you run into any issues with the installation or configuration please refer to the information listed below for additional assistance: Before Installing FileMaker Server 9 or FileMaker Server 9 Advanced 1. Read Chapter 1 of the FileMaker Server 9 Getting Started Guide. 2. Remove FileMaker Server 8 or FileMaker Server 8 Advanced using the 8.0 uninstaller. 3. Open the FileMaker Server install folder and make sure no other folders remain except Data (which has your databases) and xslttemplate- files. If any folders like Admin/Conf or web-server-support remain, clean them manually before you begin the installation. The Windows operating system might prevent you from deleting files, when some processes are using it or if the files are open. If this happens, reboot your machine and then delete the files. Reboot before next installation: Also, as a rule of thumb you should reboot the machine after an uninstall and before the next installation. FileMaker Pro: Make sure FileMaker Pro is not running when you install FileMaker Server 9, there are port conflict issues. If you installed FileMaker Server 9 while FileMaker Pro was running it is necessary to uninstall FileMaker Server 9 and reboot your computer before reinstalling. Check IIS and Apache for any left over configurations: ● On IIS, Open Default web site and make sure fmi-test and Jakarta are removed. ● On Windows Server 2003, check under Web Service Extensions and make sure PHP and FMI Web Publishing are removed. Right click on Default Web Sites > properties

System as above post On another note Im seeing other strange behaviour. When I installed v9 I turned on e-mail warning system - get mails of errors etc to see what happened. I now constantly get messages like the following FileMaker Server 9.0.1.132 on LON-FEP-ADMIN1 reported the following event: 2007-09-12 10:09:23.355 +0000 Warning 661 LON-FEP-ADMIN1 Client "Louise Clear" authentication failed on database "StaffAVEDA.fp7" using "Louise Clear [fmapp]". The client is not seeing any problems, they are logging in and using the system as normail, yet Im getting mailed these authentication issues! Im using FM accounts and security, not AD or OD. Some older databases just have a password, some have a username and password but all are giving this error! Has this been happening since year dot but I have not known or is it a new issue in v9 - Any help would be great!

I can report much the same thing. Win 2003. lasts a day dies at night. Very strange. I get the following error on reboot: Event Type: Information Event Source: Application Error Event Category: (100) Event ID: 1004 Date: 9/12/2007 Time: 9:05:51 AM User: N/A Computer: LON-FEP-ADMIN1 Description: Reporting queued error: faulting application fmswpc.exe, version 9.0.1.74, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0004afb2. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 41 70 70 6c 69 63 61 74 Applicat 0008: 69 6f 6e 20 46 61 69 6c ion Fail 0010: 75 72 65 20 20 66 6d 73 ure fms 0018: 77 70 63 2e 65 78 65 20 wpc.exe 0020: 39 2e 30 2e 31 2e 37 34 9.0.1.74 0028: 20 69 6e 20 6e 74 64 6c in ntdl 0030: 6c 2e 64 6c 6c 20 35 2e l.dll 5. 0038: 32 2e 33 37 39 30 2e 33 2.3790.3 0040: 39 35 39 20 61 74 20 6f 959 at o 0048: 66 66 73 65 74 20 30 30 ffset 00 0050: 30 34 61 66 62 32 04afb2 I get this message in sys event log Event Type: Error Event Source: Application Error Event Category: (100) Event ID: 1000 Date: 9/11/2007 Time: 3:41:11 AM User: N/A Computer: LON-FEP-ADMIN1 Description: Faulting application fmserver.exe, version 9.0.1.84, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0004afb2. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 41 70 70 6c 69 63 61 74 Applicat 0008: 69 6f 6e 20 46 61 69 6c ion Fail 0010: 75 72 65 20 20 66 6d 73 ure fms 0018: 65 72 76 65 72 2e 65 78 erver.ex 0020: 65 20 39 2e 30 2e 31 2e e 9.0.1. 0028: 38 34 20 69 6e 20 6e 74 84 in nt 0030: 64 6c 6c 2e 64 6c 6c 20 dll.dll 0038: 35 2e 32 2e 33 37 39 30 5.2.3790 0040: 2e 33 39 35 39 20 61 74 .3959 at 0048: 20 6f 66 66 73 65 74 20 offset 0050: 30 30 30 34 61 66 62 32 0004afb2 I get this e-mail from system FileMaker Server 9.0.1.132 on LON-FEP-ADMIN1 reported the following event: Wed Sep 12 08:52:29 BST 2007 FMS ERROR wpe1 Some problems were detected in the WPE COMPONENT: COMPONENT IS NOT RESPONDING. I have turned off firewall but no effect. My server also runs microsoft SQL and IIS but apart from that is only hosting FM. Im baffled, the error on startup also concerns me as a simple reboot may not fix the issue - sometimes i have to start the service from the admin panel manually. Any ideas?

I can report much the same thing. Win 2003. lasts a day dies at night. Very strange. I get the following error on reboot: Event Type: Information Event Source: Application Error Event Category: (100) Event ID: 1004 Date: 9/12/2007 Time: 9:05:51 AM User: N/A Computer: LON-FEP-ADMIN1 Description: Reporting queued error: faulting application fmswpc.exe, version 9.0.1.74, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0004afb2. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 41 70 70 6c 69 63 61 74 Applicat 0008: 69 6f 6e 20 46 61 69 6c ion Fail 0010: 75 72 65 20 20 66 6d 73 ure fms 0018: 77 70 63 2e 65 78 65 20 wpc.exe 0020: 39 2e 30 2e 31 2e 37 34 9.0.1.74 0028: 20 69 6e 20 6e 74 64 6c in ntdl 0030: 6c 2e 64 6c 6c 20 35 2e l.dll 5. 0038: 32 2e 33 37 39 30 2e 33 2.3790.3 0040: 39 35 39 20 61 74 20 6f 959 at o 0048: 66 66 73 65 74 20 30 30 ffset 00 0050: 30 34 61 66 62 32 04afb2 I get this message in sys event log Event Type: Error Event Source: Application Error Event Category: (100) Event ID: 1000 Date: 9/11/2007 Time: 3:41:11 AM User: N/A Computer: LON-FEP-ADMIN1 Description: Faulting application fmserver.exe, version 9.0.1.84, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0004afb2. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 41 70 70 6c 69 63 61 74 Applicat 0008: 69 6f 6e 20 46 61 69 6c ion Fail 0010: 75 72 65 20 20 66 6d 73 ure fms 0018: 65 72 76 65 72 2e 65 78 erver.ex 0020: 65 20 39 2e 30 2e 31 2e e 9.0.1. 0028: 38 34 20 69 6e 20 6e 74 84 in nt 0030: 64 6c 6c 2e 64 6c 6c 20 dll.dll 0038: 35 2e 32 2e 33 37 39 30 5.2.3790 0040: 2e 33 39 35 39 20 61 74 .3959 at 0048: 20 6f 66 66 73 65 74 20 offset 0050: 30 30 30 34 61 66 62 32 0004afb2 I get this e-mail from system FileMaker Server 9.0.1.132 on LON-FEP-ADMIN1 reported the following event: Wed Sep 12 08:52:29 BST 2007 FMS ERROR wpe1 Some problems were detected in the WPE COMPONENT: COMPONENT IS NOT RESPONDING. I have turned off firewall but no effect. My server also runs microsoft SQL and IIS but apart from that is only hosting FM. Im baffled, the error on startup also concerns me as a simple reboot may not fix the issue - sometimes i have to start the service from the admin panel manually. Any ideas?

I have a table with many cells and id like to freeze some of them vertically as you can in excel, does anyone have any ideas as to how this is possible?

Cheers Phil, Ill check it out

Hi all, I have a basic question ut Im struggling to find an answer. I want to duplicate a record for data entry speed but I want to make sure certain fields are left blank i.e. I have a ticketing system linked to financial system, I want to duplicate an old ticket for a new similar job but dont want to duplicate its billed status - defined by an invoiced checkbox? in otherwords all the details are identical except this checkbox is defaulted to unticked.

Thanks for that - I solved it by adding a calculation field to the Info layout with following formula! One of yours from another forum I thik - u r a very clever lady! Case( invoiced > 0 ; TextColor ( "INVOICED" ; RGB ( 255 ; 0 ; 0 ) ) )

Hi, Im completely new here and struggling with what should be a simple thing. I have a database with 2 layouts - 1 info 2 financial. When I tick an Invoiced check box (in layout 2) I want to display a graphic on layout 1 which says invoiced in big red letters - any Ideas?