Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Kieron

  • Rank
  • Birthday 08/12/1971

Profile Information

  • Gender
  1. RESOLVED: I decided to use JDBC connections instead. After the initial setup problem (where to put jar files and which xml file to change). The solution works fine. Phew. K
  2. The error from Mirth seems over complicated but here it is.... [2013-05-23 11:55:54,422] FATAL (org.mule.impl.DefaultComponentExceptionStrategy:84): The error is: General error Query: SELECT path.lab FROM path Parameters: [] java.sql.SQLException: General error Query: SELECT path.lab FROM path Parameters: [] at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:359) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:240) at com.webreach.mirth.connectors.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:258) at org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:108) at org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:118) at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Unknown Source) The exact same query works on FM8 Server. K
  3. I have a solution which has been running for years on filemaker 8 advanced server where I send HL7 messages to an from filemaker server using 'Mirth Connect' connecting to the filemaker server using the ODBC and running a very simple SQL and sending the result out using a LLP connection SELECT x FROM y This is all fine.. But, now I'm setting up FM 12 advanced server, and have all the up-to-date ODBC drivers which all connect fine, and have been tested using excel. The connections are being made to the fm server as I can see the connections in the logs (so I guess the ODBC connection is okay), but it will not run the simple SQL query above. Has something changed? I know they are different ODBC drivers, but has the SQL changed? Looking at all the documentation I can't see anything fundamentally different? Any suggestions? K
  4. I'm wondering whether anyone can help, I run a filemaker 8.0v4 advanced server on a G5 running 10.3.9, and the hard disk went pop. I thought I had all the disks to re-install the software, but I am missing the 'web publishing engine' installer (which was on a separate CD). I contacted filemaker and they were unable to supply the software, as it was obsolete. I was wondering whether anyone had access to this software? I have everything else running fine again, I just need can't install the WPE. Thank you in advance. Kieron
  5. Did you manage to resolve this issue? As I use some middleware called 'Mirth' (freeware) to enable import and export of HL7 messages into FM databases.
  6. I'll give it a go and post my results here. thx.
  7. I think this is the right forum for this query. I have both mac and pc's access a server, from a small FM database on each individual machine that when opened opens the 'proper' database on our server. When they 'log out' it should automatically go back to this local file. The problem I have is that I can't find a location on a mac where I can install a file that is the same place for all users i.e. for a PC it is easy filewin:/C:/Documents and Settings/All Users/Desktop/***.fp7 but for a mac it is filemac:/Macintosh HD/Applications/FileMaker Pro 8/***.fp7 but the problem is that people rename their hard disks! Can somebody help me?? Thanks, Kieron
  8. Thanks for your help on this one. It's wonders what you can do when pointed in the right direction. I have now included a 'closer' aswell that closes all open windows when user is required to relogin. Also includes a change password script that will change the password on all 'satelitte' databases in one hit. Thanks again. Kieron :wink2:
  9. Sounds like a plan! Thanks for your help. Kieron :
  10. Could you expand on this?? I do have a master relogin script that closes all the files and reopens the 'opener', which then prompts me for a username and password for the ''main database' Is it possible to carry a username and password into the re-login script to open the other 'satelitte databases' with the same details? Kieron
  11. That would be the obvious (easy) answer... but quite often one user may finish and the next may follow directly after them. This will make for a rather slow log in process, wouldn't it? Do you have any other suggestions? Thanks, Kieron
  12. I can't seem to find anyone else having this problem, so there may be an easy answer. ( I hope!) I manage a large system with approx 100 users, and they all have separate login accounts, but they may use the same machines to access the databases. I have a 'opener' file on each machine to open the ,main database' on our server which the the user can then move between other 'satelite databases'. The problem is though, that I have recently discovered that although a 'log out' script closes all the remote server files and reopens the 'opener' file on each local machine. When you relogin as a different user, to the 'main database', any access to the satelite datbases still uses the login details of the first person to open the database. Can anyone help? Thanks, Kieron
  13. I don't know if this will help, but I had a problem with 'out of memory' running an extended script that exports records as individual files. To fix it I changed the memory option in the application preferences to 'every 10 minutes or when necessary' Seemed to solve my problem, not totally sure it will help with printing, but probably worth a go! Kieron
  14. Has anyone had any problems with dictionaries on FM8 or 7? Every time I open the application I have to re-select the dictionary. Thanks, Kieron
  15. Managed to sort it. open the microsoft dictionary 'dic' file in word. Saved as tab separated text. Then imported that file into the filemaker dictionary.
  • Create New...

Important Information

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