• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home
  • Public Forums
  • Application Monitoring & UEM
  • AppMon & UEM Open Q&A
avatar image
Question by matt S. · Mar 21, 2015 at 04:19 AM ·

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

Msg 102, Level 15, State 1, Line 11
Incorrect syntax near 'sp_rename'.

 

Any thoughts?

 

Thanks 

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

11 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by matt S. · Apr 04, 2015 at 06:13 AM

I ran this migration without step 5 and got a duplicate key violation from the index uk_dynamic_measure. I then ran the steps again this time including step 5 and it ran very quickly. The counts for current vs old is 13k : 11k so it seems pretty close. 

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by matt S. · Apr 01, 2015 at 02:42 AM

Thank you. I'll run that later today. 

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Alois M. · Mar 25, 2015 at 11:34 PM

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

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by matt S. · Mar 25, 2015 at 11:03 PM

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. 

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Alois M. · Mar 24, 2015 at 05:51 PM

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
Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by matt S. · Mar 24, 2015 at 01:45 AM

I cannot. How can I fix this?

 

Thank you. 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Alois M. · Mar 24, 2015 at 01:34 AM

Hi Matt,

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

 

Regards,

Alois

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by matt S. · Mar 24, 2015 at 01:30 AM

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. 

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Alois M. · Mar 23, 2015 at 04:23 PM

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

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by matt S. · Mar 21, 2015 at 04:21 AM

sql server 2012 btw 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

  • 1
  • 2
  • ›

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A