Issue
During PME installation or upgrade, the installer fails on the Verify Databases step with "An error has occurred during the ION_Data database deployment."
The Installation Log contains the following error:
""END OF POST-DEPLOYMENT STAGE" was NOT found in C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Database\Diagnostic\ION_Data_Upgrade.log"
The ION_Data_Install.log or ION_Data_Upgrade.log contains the following error:
Could not allocate a new page for database 'ION_Data' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The statement has been terminated.
Product Line
Power Monitoring Expert 8.2, 9.0
Environment
PME Installation or PME Upgrade
SQL Server Express
Cause
SQL Server is the express edition and Database size is greater than 10 GB
Resolution
If ION_Data database is larger than 10 GB, the database will need to be trimmed to less than 10 GB or detached for the installer to create a new, blank ION_Data.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
3. If ION_Data database is larger than 10 GB, the database will need to be trimmed to less than 10 GB or detached for the installer to create a new, blank ION_Data. Instructions on manually trimming the database are available in FA210471 . Instructions on how to create a fresh ION_DATA database are available in Video: How to create a new ION_Data database in PM.
During PME installation or upgrade, the installer fails on the Verify Databases step with "An error has occurred during the ION_Data database deployment."
The Installation Log contains the following error:
""END OF POST-DEPLOYMENT STAGE" was NOT found in C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Database\Diagnostic\ION_Data_Upgrade.log"
The ION_Data_Install.log or ION_Data_Upgrade.log contains the following error:
Could not allocate a new page for database 'ION_Data' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The statement has been terminated.
Product Line
Power Monitoring Expert 8.2, 9.0
Environment
PME Installation or PME Upgrade
SQL Server Express
Cause
SQL Server is the express edition and Database size is greater than 10 GB
Resolution
If ION_Data database is larger than 10 GB, the database will need to be trimmed to less than 10 GB or detached for the installer to create a new, blank ION_Data.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
- First, Identify the version of SQL being used:
i. Open SQL Server Management Studio and connect to the appropriate instance
ii. Select New Query
iii. Copy the following query into the window and press Execute
select serverproperty('edition')
go
go
iv. The SQL version will be returned.
- If Express Edition is being used, determine if the ION_Data database is larger than 10 GB:
- Right-click on the ION_Data database
- Select Properties
- Under the General page, locate the Size
3. If ION_Data database is larger than 10 GB, the database will need to be trimmed to less than 10 GB or detached for the installer to create a new, blank ION_Data. Instructions on manually trimming the database are available in FA210471 . Instructions on how to create a fresh ION_DATA database are available in Video: How to create a new ION_Data database in PM.
Released for:Schneider Electric South Africa
