Jump to content

Ron Cates

  • Content Count

  • Joined

  • Last visited

  • Days Won


Ron Cates last won the day on September 6 2012

Ron Cates had the most liked content!

Community Reputation

8 Neutral

About Ron Cates

  • Rank
  • Birthday 04/07/1969

Profile Information

  • Gender
  • Location
    Bowling Green KY

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. The user in question has knocked off for the day, so I guess we'll see what happens tomorrow. Thanks
  2. In a way yes. The table the layout is based on is a join table for sales leads. The join table joins the lead record to a set record. The leads are assigned to sets in groups of 100 and those sets are then assigned to a sales person. When assigning the set it actually puts the users ID in the set record and loops through all the lead assignment records and puts the user ID in each one. So the records are all assigned to a user. The find script runs the search and up until earlier today it would produce a found set and then do another find request to constrain the found set to only those with the user 's ID. Earlier today I restructured the script again to include the users ID in each record request of the find to begin with. Thus eliminating the need for a constrain. I had wanted to have the find constrain conditionally based on the users permission levels. In other words a manager would get all results, where a sales person would only get their own records. Either way I don't know if eliminating the constrain find will help but I'm trying anything I can. Now I have to wait for the user to report if it happens again. In the end though I can't imagine that the user ID could have anything to do with things but who knows at this point.
  3. I am at my wits end with this one. This has been occurring for select users for a couple months. We have two locations running the same file. Each with it's own copy of the file on it's own server. This is happening a couple times a day for one out of 20 users at one location and once in a great while for one user out of 12 at the other location. I have a layout with a scripted find over multiple tables. The user enters the find criteria into a global field and fires the script by clicking a button or hitting enter. When the search executes it appears to find the record being searched for and then FileMaker freezes up and closes without any kind of dialog. When the database is reopened the record in question is gone. Initially the script was using quick find to do the search. I read some threads that mentioned quick find crashing and closing filemaker so I thought it might be the culprit. I rewrote the find script using multiple find requests instead. Even with the new completely rewritten script it continues to happen. In all we have over 30 users across two locations that use this layout all day everyday and yet it is only happening to one person regularly. The other instances have been isolated and maybe occurred like once a month. The script has been completely rewritten and in both instances of the script there is absolutely no delete command anywhere. The user in question does not have permission to delete records in that table at all The result when it does happen is always that FileMaker locks up and crashes, apparently obliterating the current record in the process. For the user who is experiencing it frequently we even tried switching out his workstation computer but it still continues to happen to him. I keep scaling back the find to search fewer and fewer fields but that is certainly not a solution. Both locations are running Filemaker Server 17 on windows Server 16. The clients are all Filemaker 17 on Windows 10. Even looking at my scripting and everything involved the fact that it is resulting in Filemaker crashing and the record being deleted is crazy. I'm stumped...
  4. Still baffled by this. Ran a recovery on the file, no corruption detected. I had hoped the process rebuilding the indexes might help. Put the recovered file on my development server and the results were the same. The relationships produce results when opened on my local machine but fail when hosted.
  5. Took the same file and put it on a development sever that I have set up and the results were the same as on the production server. The relationships did not return any results. So it appears that it is working on my local machine but not working when hosted on either server.
  6. I am working with a table of 1.5 million records. I am using relationships to isolate records from that table based on multikey fields that contain a list of the IDs that I want to access matched up with the primary key field of that table. There are multiple relationships to access and group the records needed based on a multitude of criteria but in short the problem is this. Those relationships were working until last night when I was working on the system and after a few changes all the relationships to that table based on the primary key field stopped showing any results. Even with the most basic relationship, Multikey field with a list of IDs linked to the primary key field of the target table and still results in no records found. I ran a backup and pulled the backup off the server and opened it on my local computer and the relationships all worked on the locally opened copy. I suspect an indexing problem but don't understand how the indexing works well enough to know how the same file would work locally but fail on the server?
  7. Sound like Go To Related Records to me.
  8. I purchased the plastic plugin yesterday on behalf of our company. I have successfully deployed and registered the plugin and have been able to integrate the scripting, table and fields from the demo file. So far it has gone very well and I am able to process credit cards with authorize.net successfully. Great product!! However I am having some issues with processing electronic check transactions. Using the same API credentials that I am successfully processing cards with I am receiving an error message "The merchant login ID or password is invalid or the account is inactive" Do I need different API credentials for authorize.net for check processing? Also, the Plastic demo is giving the same error with the API credentials it shipped with while the card processing demo works fine. Any help would be appreciated.
  9. Thanks. I'll give it a try. And I whole heartedly agree. Network issues are very difficult. In the last couple months since I have been providing remote access to this system I have gotten reports a variety of different experiences from different users in different locations. It's so hard to trouble shoot any issue when I can't reproduce what the user is reporting from my own location.
  10. User 2 reported this afternoon that she was able to open the interface file from the main file and it came up as it should. User 1 as of last night was still getting Table Missing on the Main file. Can't access the Sales interface file without having access to the main file so he get's no where. He will not be able to try again until tonight. Scratching my head..
  11. In this case the data file is the main file that is already open. The UI file is opened from the data file. The Main file is a self contained file that I have been working with for years. I recently developed and added the Sales file as a UI file that uses the main file as a Data file.
  12. Let me revise my response to bcoony. The UI file is opened from the main file by firing a script that then runs an external openning script in the UI file. Not sure if that makes a difference but it's not using an explicit open file command as the question asked. Do you think it would make a difference using an open file script step instead? rwoods I've double checked the External Data Sources and both files are connected to each other as External Data Sources using the relative paths ( file:CAMv1 and file:CAMv1_Sales ). The files do reside in the same folder on the same sever.
  13. The UI file is opened from within the main database using a script with an open file script step.
  14. I don't even know where to begin with this one. We have a quite large and complicated database developed continuously over the last 10 years. We are currently running Filemaker Server 16 on Windows Server 2008 R2 and all clients are using FMP 16, all on windows 10. Recently we have started working on allowing remote access to our system for employees on the road or working from home. Also recently added a separate interface file that uses the original file as a data source to provide a dedicated sales interface. Other than struggling with the performance over widely varying internet speeds the system has been up and running successfully. Until a few days ago... Here's what's happening. I am the developer and am located remotely. I do my development through team viewer but I can test the direct remote access. I am able to access the database remotely as well as open the separate interface file and all is well. User1 Accessing remotely opens the main database file and the fields all show "Table Missing". User2 Accesses the main database remotely and all is well but when she opens the sales interface file all fields in that file show "Table Missing". The system is operating normally for the 10 or so users at the local office. I have accessed User 2s computer remotely through team viewer and logged in to the database using my user name and password and I get the same result she does, so it's not based on the user account. So currently I'm looking at 3 different remote access locations all getting different results. We are all within the US and only a state or two away from the local office. I have rebooted the server this morning but no change. I don't even know where to begin. Any help would be appreciated...
  • Create New...

Important Information

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