Issue
The 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
SQL Server
Environment
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
Cause
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.
Resolution
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.
The 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
SQL Server
Environment
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
Cause
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.
Resolution
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.
Released for:Schneider Electric Canada
