Error Message

• System error in the EventViewer

• The iNTERFACEWARE Iguana service terminated with service-specific error 2147484928 (0x80000500).

Issue

• A case of the crash happening while trying to resize a string buffer and write it to memory. In the past this has been associated with the system running low or out of memory.

Solution

• Restart Iguana

• Customer cleaned database from 2.5 million patients to about 100 thousand patients. This indicates a memory error was triggered due to low memory on the system.

Error Message

• In the ServiceErrorLog.txt file:

  • [2023-06-15 12:24:22] [ERROR] Open file 'C:\Program Files\iNTERFACEWARE\Iguana_2\Iguana_6_1_2\web_docs\templates\log_entries.cs' failed. Too many open files.

Issue

• Too many file, database or web service connections are open at one time.

Solution

1. Inspect the code to ensure that it closes connections immediately it has finished using them.

2. Check that the code opens the minimum number of connections required:

   1. If you are processing a large number of files you can open one or a group of several at a time rather than all of them. Then you can close the first group before processing the next group.

   2. You might set an upper limit on connections and not open more when the limit is reached. Then when the number of connections drops you can open more.

3. In particular you need to ensure that persistent connections are kept to a minimum:

   Persistent connections (particularly to databases) can be very efficient – and it is possible reduce the number of connections by using a small number of persistent connections. The key thing with persistent connections is to ensure that the number cannot keep increasing.

   1. Persistent connections to resources that you are re-using all the time make good sense – they are particularly useful for databases

   2. This page explains about persistent database connections: https://help.interfaceware.com/v6/database-connection

   3. Make sure that you are not continuing to open extra or duplicate persistent connections unintentionally (i.e., logic error that opens multiple database connections).

4. Check that the code does not allow the number of connections to continually increase:

   This is basically checking for “connection leaks” in the the same way as you would check code for memory or other resource leaks – this is particularly important for long running programs as any “leak” will eventually reach the system limit.

   1. Make sure connections are closed as soon as possible.

   2. Set limits on the maximum number of connections.

5. In the unlikely situation where you actually need more files open than the limits allow you can split the processing between several Iguana servers.