Technical FAQs

Ask a Question

Devices are not logging the most recent data in PME 7.2.x or PME 8.x software

Real-time data from the devices are shown in Diagrams. However, new data is not being logged into the database.

An error “failed to insert records because 'Insertion rolled back - Could not allocate space for object 'dbo.[DATATABLELOG]'.'IX_[DATATABLELOG]_ID' in database 'ION_Data' because the 'PRIMARY' filegroup is full” is shown in the system log with Source as “LOGINSERTER.[SERVERNAME].”

Product Line
Power Monitoring Expert 7.2.x, Power Monitoring Expert 8.x
SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Data logging in PME software

This error is caused by the database reaching its maximum allocated disk space. Each database is allocated an initial size and allowed to grow according to the pre-set auto growth settings to a specified maximum size.


Required to create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting auto growth on for existing files in the filegroup.
1. Launch SQL Server Management Studio and connect to the SQL server instance.
2. Expand Databases, System Databases and right-click on ION_Data and select properties from the drop-down menu.
3. Navigate to the filegroups page and ensure that “PRIMARY” is selected as the default filegroup.
4. Select the Files page and review the initial size of the database files that belongs to the “PRIMARY” filegroup.

5. To Setup autogrowth and maximum settings, click on the “…” icon under the Autogrowth /Maxsize column and input a value for File Growth in percentage which is generally between “10%-20%”. Ensure that for Maximum file size, either a sufficient value is entered for “Limited to (MB)” or “Unlimited” is selected.

Was this helpful?
What can we do to improve the information ?