HDS Failed to start - Migration 11.1 to 11.2.5001

17 Posts
4 Users
0 Likes
86 Views
(@m.nau@ypsys.com)
Posts: 0
New Member Guest
 

In the document it's good.
But when you use the script in the Bin you have to change those parts as you mentionned :

DECLARE @NeedsIndexRebuild BOOLEAN;
Or boolean does not exist in SQL.
New need to write this :
DECLARE @NeedsIndexRebuild BIT;

After replace IF @NeedsIndexRebuild = TRUE by IF @NeedsIndexRebuild = 1

But in the UpdateLogTable.sql, at the line 46 a "SET" is missing.
That's why I put the corrected file with all corrections.

Manu

 
Posted : 24/11/2016 2:24 pm
(@j.becker@pcvue.de)
Posts: 0
New Member Guest
 

Hello,

in the next version there will be only one script, something like "UpgradeDatabase.sql" checking and upgrading all tables (log and trend) in a Database.

If you need it before, you should ask Dev or Ref.

 
Posted : 29/11/2016 5:03 pm