DataLogger Out of memory error

[EA_11204094]

"PostgreSQL database is running out of memory even though the total database size is only 500MB and the server has 1TB of RAM. I'm writing 800 values per minute into the database using a data logger. How can I resolve this issue?"

"It gives two different errors. The errors are as follows. I am using Kepserver version V6.6.350.0."

[ntripathi · Accepted solution]

Greetings @EA_11204094 

I trust you’re having a great day. 

I noticed your recent post about encountering an error related to opening a recordset on the log group ‘xxx’. The specific error message states: “Unable to open recordset on log group ‘xxx’. Reason: Out of memory while reading tuples.”

To address this issue, follow these steps:

1. Check the “Use Declare/Fetch” Option:

   • Navigate to your DSN (Data Source Name) configuration.
   • Look for an option related to “Declare/Fetch” or “Use Declare/Fetch.”
   • Ensure that this option is enabled. If it’s currently disabled, enable it.
   • Save your changes.

        2. Restart the Application or Service:

• After making the configuration change, restart the application or service that uses this DSN.
• This step ensures that the new settings take effect.

[EA_11204094]

Thank you for the solution. Thanks to you my problem is solved