Migration from an older version has failed, please manually execute the script available here and reconnect the Performance Warehouse afterwards.

This is the script it gave me

CREATE TABLE AGING_TIMESTAMPS ( MEASURE_ID INTEGER NOT NULL, LOWTIMESTAMP BIGINT, MIDTIMESTAMP BIGINT, CONSTRAINT PK_AGING_TIMESTAMPS PRIMARY KEY (measure_id));

CREATE TABLE blmeasurements ( measure_id INTEGER, timestamp bigint, obscount bigint, bltype TINYINT, uppervalue double precision, lowervalue double precision, actualvalue double precision, expectedvalue double precision, CONSTRAINT PK_blmeasurements PRIMARY KEY CLUSTERED ( measure_id ASC, timestamp ASC, bltype ASC ));

CREATE TABLE blconfiguration ( measure_id INTEGER NOT NULL, resetTs bigint NOT NULL, alerting VARCHAR(1) NOT NULL, max50 double precision NOT NULL, max90 double precision NOT NULL, maxError double precision NOT NULL, minDuration INTEGER NOT NULL, PRIMARY KEY(measure_id));

create index i_dynamic_measure_appid_ts on dynamic_measure (application_id, timestamp);

ALTER TABLE dynamic_measure ADD is_migrated tinyint default 0;

sp_rename dynamic_measure , dynamic_measure_old ;

sp_rename N'dynamic_measure_old.idxdmconftime' , N'idxdmconftimeold' , N'INDEX' ;

sp_rename N'dynamic_measure_old.dyn_measure_measuretype' , N'dyn_measure_measuretypeold' , N'INDEX' ;

sp_rename N'dynamic_measure_old.IDX1_DYNAMIC_MEASURE' , N'IDX1_DYNAMIC_MEASUREOLD' , N'INDEX' ;

sp_rename N'dynamic_measure_old.uk_dynamic_measure' , N'uk_dynamic_measureold' , N'INDEX' ;

sp_rename N'dynamic_measure_old.i_dynamic_measure_appid_ts' , N'i_dynamic_measure_appid_tsold' , N'INDEX' ;

CREATE TABLE dynamic_measure ( id INTEGER PRIMARY KEY, system_id INTEGER, name VARCHAR(500), conf_id INTEGER, src_id INTEGER, metric_id INTEGER, metric_group_id INTEGER, measuretype TINYINT, collectorid VARCHAR(500), timestamp bigint, is_dynamic INTEGER, is_deleted TINYINT DEFAULT 0, application_id INTEGER NOT NULL, TAG_HASH bigint, TAG_DATA VARCHAR(MAX));

CREATE INDEX idxdmconftime ON dynamic_measure (conf_id,timestamp);

CREATE INDEX dyn_measure_measuretype ON dynamic_measure (measuretype);

CREATE INDEX IDX1_DYNAMIC_MEASURE ON DYNAMIC_MEASURE (TAG_HASH);

create unique index uk_dynamic_measure on DYNAMIC_MEASURE (system_id, measuretype, collectorid, src_id, is_dynamic, metric_group_id, metric_id, conf_id, is_deleted, application_id, name, TAG_HASH);

create index i_dynamic_measure_appid_ts on dynamic_measure (application_id, timestamp);

CREATE TABLE dtserver ( serverid INTEGER, servername VARCHAR(100), lastalive bigint);

UPDATE version SET MANUAL=1;

COMMIT;

It's odd having a commit without a begin right?

sql server 2012 btw 

Hi Matt,

try to insert execute before the sp_rename.....  :

like this:

execute sp_rename dynamic_measure , dynamic_measure_old ;

execute sp_rename N'dynamic_measure_old.idxdmconftime' , N'idxdmconftimeold' , N'INDEX';

execute sp_rename N'dynamic_measure_old.dyn_measure_measuretype' , N'dyn_measure_measuretypeold' , N'INDEX';

execute sp_rename N'dynamic_measure_old.IDX1_DYNAMIC_MEASURE' , N'IDX1_DYNAMIC_MEASUREOLD' , N'INDEX';

execute sp_rename N'dynamic_measure_old.uk_dynamic_measure' , N'uk_dynamic_measureold' , N'INDEX';

execute sp_rename N'dynamic_measure_old.i_dynamic_measure_appid_ts' , N'i_dynamic_measure_appid_tsold' , N'INDEX';

Regards,

Alois

Thank you, I was able to get it to work in some capacity. Since the original script had run partially (there was no begin trans to that commit on the end) some of the tables were already created and the one rename had already happened. Once I got it working fully, I attempted to connect to the warehouse but it failed on the duplicate key row in dynamic_measure on the index uk_dynamic_measure. I deleted that index and was able to connect. Probably not the best solution here as I'm sure that index is needed but I wanted to get this connected. 

Hi Matt,

please check if you can see the historical data in charts.

Regards,

Alois

I cannot. How can I fix this?

Thank you. 

Hi Matt,

1. Disconnect the pwh
2. check if all index are created for the dynamic_measure_old and dynamic_measure table. If not, create it.
3. truncate the dynamic_measure table
4. update the dynamic_measure_old with: update dynamic_measure_old set is_migrated=0;
5. delete measures where dynatrace got no new for the last month with:
   delete from dynamic_measure_old where timestamp < 1424736000000
6. update the version table to the old version(have to be lower than 6.1)
7. connect the pwh
8. dynatrace now checks the version table and migrate all data with is_migrated=0 from the dynamic_measure_old to the dynamic_measure table.
   This could run very long(hours), it depends on the size of the dynamic_measure_old table
9. Do not disconnect the Pwh during this migration.
10. "Performance Warehouse Migration finished successfully" in the serverlog shows the end of the migration
    
    Any Questions?
    Regards,
    Alois

Yes. I ran counts on my old measure vs new and its 

15959 for new  

592677 for old 

This also proves that migration didn't happen correctly does it not?

I can do step 5 but I don't understand it. We're deleting measures older than one month ago? 

Thank you for the detailed instructions. 

Hi Matt,

Yes, the counts shows us that the migration did not happened correct.

Explanation to Step 5:

This deletes only measures which got no new measures since a month.
There is one cause why we do that:
We know a bug in former dynatrace versions which produces false data in the dynamic_measure table. This data cannot be migrated. 
But it could be that your PWh have not such false data.

So, you can try the steps above without step 5. 

If you have problems please open a support ticket and refer to me.

Regards,

Alois

Thank you. I'll run that later today.