Issue
When attempting to upgrade ION_Data from a ION Enterprise 6.0 or older to Power Monitoring Expert 8.x the upgrade fails with the following error message.
*** Could not deploy package.
Warning SQL72015: The column [dbo].[PQ_Events].[CollectorName] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[EndDataLogId] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[EventLogID] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[IsOrphan] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[StartDataLogId] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[StartTimeStampUtc] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[SubType] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[TimestampUtc] on table [dbo].[PQ_Events] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
Warning SQL72015: The type for column Type in table [dbo].[PQ_Events] is currently NVARCHAR (100) NOT NULL but is being changed to NVARCHAR (12) NOT NULL. Data loss could occur.
Warning SQL72015: The type for column WorstPhase in table [dbo].[PQ_Events] is currently NVARCHAR (10) NULL but is being changed to NVARCHAR (3) NULL. Data loss could occur.
Warning SQL72030: If this deployment is executed, changes to [dbo].[EventString] might introduce run-time errors in [dbo].[spPQ_GetNewPQEventsForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[EventString] might introduce run-time errors in [dbo].[spPQ_GetPQEventsToReprocessForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[PQ_Events] might introduce run-time errors in [dbo].[spPQ_SaveNormalisedEvent].
Warning SQL72030: If this deployment is executed, changes to [dbo].[PQ_Events] might introduce run-time errors in [dbo].[spPQ_GetPQEventsToReprocessForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[Source] might introduce run-time errors in [dbo].[spPQ_GetPQEventsToReprocessForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[udf_SplitStringListToTable] might introduce run-time errors in [dbo].[udfPQ_GetPQDataLogEntryWithinThreshold].
Error SQL72014: .Net SqlClient Data Provider: Msg 802, Level 17, State 9, Line 1 There is insufficient memory available in the buffer pool.
Error SQL72045: Script execution error. The executed script:
CREATE UNIQUE CLUSTERED INDEX [CIX_DataLog2_SourceID_QuantityID_TimestampUTC]
ON [dbo].[DataLog2]([SourceID] ASC, [QuantityID] ASC, [TimestampUTC] ASC);
Product Line
Power Monitoring Expert 8.x
Environment
WIndows 7 / Microsoft Server 2008 / 2008 R2 / 2012 / 2012 R2
SQL Server 2005 / 2014
Cause
Some older versions of ION Enterprise use SQL 2005. Attempting to upgrade directly from SQL 2005 to SQL 2014 can cause this error message.
Resolution
*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.*
In order to upgrade successfully the SQL 2005 database will need to be moved into a SQL 2008 or 2008 R2 instance. From there the database can be moved to the PME system using SQL 2014 to be upgraded successfully.
When attempting to upgrade ION_Data from a ION Enterprise 6.0 or older to Power Monitoring Expert 8.x the upgrade fails with the following error message.
*** Could not deploy package.
Warning SQL72015: The column [dbo].[PQ_Events].[CollectorName] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[EndDataLogId] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[EventLogID] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[IsOrphan] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[StartDataLogId] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[StartTimeStampUtc] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[SubType] is being dropped, data loss could occur.
Warning SQL72015: The column [dbo].[PQ_Events].[TimestampUtc] on table [dbo].[PQ_Events] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
Warning SQL72015: The type for column Type in table [dbo].[PQ_Events] is currently NVARCHAR (100) NOT NULL but is being changed to NVARCHAR (12) NOT NULL. Data loss could occur.
Warning SQL72015: The type for column WorstPhase in table [dbo].[PQ_Events] is currently NVARCHAR (10) NULL but is being changed to NVARCHAR (3) NULL. Data loss could occur.
Warning SQL72030: If this deployment is executed, changes to [dbo].[EventString] might introduce run-time errors in [dbo].[spPQ_GetNewPQEventsForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[EventString] might introduce run-time errors in [dbo].[spPQ_GetPQEventsToReprocessForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[PQ_Events] might introduce run-time errors in [dbo].[spPQ_SaveNormalisedEvent].
Warning SQL72030: If this deployment is executed, changes to [dbo].[PQ_Events] might introduce run-time errors in [dbo].[spPQ_GetPQEventsToReprocessForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[Source] might introduce run-time errors in [dbo].[spPQ_GetPQEventsToReprocessForSource].
Warning SQL72030: If this deployment is executed, changes to [dbo].[udf_SplitStringListToTable] might introduce run-time errors in [dbo].[udfPQ_GetPQDataLogEntryWithinThreshold].
Error SQL72014: .Net SqlClient Data Provider: Msg 802, Level 17, State 9, Line 1 There is insufficient memory available in the buffer pool.
Error SQL72045: Script execution error. The executed script:
CREATE UNIQUE CLUSTERED INDEX [CIX_DataLog2_SourceID_QuantityID_TimestampUTC]
ON [dbo].[DataLog2]([SourceID] ASC, [QuantityID] ASC, [TimestampUTC] ASC);
Product Line
Power Monitoring Expert 8.x
Environment
WIndows 7 / Microsoft Server 2008 / 2008 R2 / 2012 / 2012 R2
SQL Server 2005 / 2014
Cause
Some older versions of ION Enterprise use SQL 2005. Attempting to upgrade directly from SQL 2005 to SQL 2014 can cause this error message.
Resolution
*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.*
In order to upgrade successfully the SQL 2005 database will need to be moved into a SQL 2008 or 2008 R2 instance. From there the database can be moved to the PME system using SQL 2014 to be upgraded successfully.
Released for:Schneider Electric New Zealand
