Red Gate forums :: View topic - SqlCompare stucks at 'Populate ObjectText'
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SqlCompare stucks at 'Populate ObjectText'

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SeriousM



Joined: 27 Sep 2010
Posts: 11

PostPosted: Tue Feb 26, 2013 5:55 pm    Post subject: SqlCompare stucks at 'Populate ObjectText' Reply with quote

Hi,

when i compare a sql 2008 r2 database with a windows azure database the comparer stucks at "Reading object context".
WHen i look into the log where is the step "Populate ObjectText" where it hangs.

I used the version: 10.2.6.114 because it can handle the renaming operations in azure better.

Here is a screenshot:
http://pbrd.co/V5wQz7

And here the log:
Code:
17:38:28.819|Info   |Logging             |1  |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
17:38:37.389|Info   |SQL Compare Engine  |9  |Register live database start: Innov8.temp.innov8.head.3b9f7a94a5ebdd6a1442bae899c1f44aaaa56d16
17:38:37.431|Info   |SQL Compare Engine  |9  |Populate Live Start, popoptions: DatabaseCollation, DecryptPost2kEncryptedObjects
17:38:37.431|Info   |SQL Compare Engine  |9  |Populate Live Start, options: ForceColumnOrder, IgnoreFillFactor, IgnorePermissions, IgnoreWhiteSpace, CaseSensitiveObjectDefinition, IgnoreFullTextIndexing, IgnoreComments, IgnoreFileGroups, DoNotOutputCommentHeader, IgnoreUsers, IgnoreUserProperties, IgnoreWithElementOrder, IgnoreDatabaseAndServerName, DecryptPost2kEncryptedObjects
17:38:37.463|Info   |SQL Compare Engine  |9  |Populate major version: SqlServer2008
17:38:37.466|Info   |SQL Compare Engine  |9  |Populate got casing: True
17:38:37.466|Info   |SQL Compare Engine  |9  |Populate Case Sensitive: True
17:38:37.470|Info   |SQL Compare Engine  |9  |Populate FulltextCatalogs start.
17:38:37.473|Info   |SQL Compare Engine  |9  |Populate Fulltext Stoplists start.
17:38:37.475|Info   |SQL Compare Engine  |9  |Populate Fulltext Stopwords start.
17:38:37.477|Info   |SQL Compare Engine  |9  |Populate ObjectNames start.
17:38:37.496|Info   |SQL Compare Engine  |9  |Populate Users start.
17:38:37.505|Info   |SQL Compare Engine  |9  |Populate Tables start.
17:38:37.527|Info   |SQL Compare Engine  |9  |Populate Functions start.
17:38:37.531|Info   |SQL Compare Engine  |9  |Populate Defaults start.
17:38:37.533|Info   |SQL Compare Engine  |9  |Populate Rules start.
17:38:37.535|Info   |SQL Compare Engine  |9  |Populate UDTs start.
17:38:37.538|Info   |SQL Compare Engine  |9  |Populate Table UDTs start.
17:38:37.540|Info   |SQL Compare Engine  |9  |Populate Views start.
17:38:37.546|Info   |SQL Compare Engine  |9  |Populate View Cols start.
17:38:37.552|Info   |SQL Compare Engine  |9  |Populate Procs start.
17:38:37.556|Info   |SQL Compare Engine  |9  |Populate ObjectText start.
17:38:37.613|Info   |SQL Compare Engine  |9  |Populate 2k8 Dependencies start.
17:38:37.620|Info   |SQL Compare Engine  |9  |Populate Table Cols start.
17:38:37.651|Info   |SQL Compare Engine  |9  |Populate Indexes start.
17:38:37.703|Info   |SQL Compare Engine  |9  |Populate Statistics start.
17:38:37.707|Info   |SQL Compare Engine  |9  |Populate ForeignKeys start.
17:38:37.720|Info   |SQL Compare Engine  |9  |Populate Constraints start.
17:38:37.723|Info   |SQL Compare Engine  |9  |Populate Triggers start.
17:38:37.729|Info   |SQL Compare Engine  |9  |Populate UDT Deps start.
17:38:37.732|Info   |SQL Compare Engine  |9  |Populate Roles start.
17:38:37.735|Info   |SQL Compare Engine  |9  |Populate Role Membership start.
17:38:37.738|Info   |SQL Compare Engine  |9  |Populate Schemas start.
17:38:37.741|Info   |SQL Compare Engine  |9  |Populate Assembly Files start.
17:38:37.743|Info   |SQL Compare Engine  |9  |Populate Synonyms start.
17:38:37.745|Info   |SQL Compare Engine  |9  |Populate MessageTypes start.
17:38:37.753|Info   |SQL Compare Engine  |9  |Populate Contracts start.
17:38:37.756|Info   |SQL Compare Engine  |9  |Populate Messages start.
17:38:37.759|Info   |SQL Compare Engine  |9  |Populate Queues start.
17:38:37.764|Info   |SQL Compare Engine  |9  |Populate Services start.
17:38:37.768|Info   |SQL Compare Engine  |9  |Populate Service Bindings start.
17:38:37.770|Info   |SQL Compare Engine  |9  |Populate Contracts start.
17:38:37.772|Info   |SQL Compare Engine  |9  |Populate Routes start.
17:38:37.776|Info   |SQL Compare Engine  |9  |Populate Parameters start.
17:38:37.780|Info   |SQL Compare Engine  |9  |Populate Event Notifications start.
17:38:37.783|Info   |SQL Compare Engine  |9  |Populate DDL Triggers start.
17:38:37.787|Info   |SQL Compare Engine  |9  |Populate XML Schema Collections start.
17:38:37.790|Info   |SQL Compare Engine  |9  |Populate Certs start.
17:38:37.792|Info   |SQL Compare Engine  |9  |Populate SKeys start.
17:38:37.794|Info   |SQL Compare Engine  |9  |Populate AKeys start.
17:38:37.796|Info   |SQL Compare Engine  |9  |Populate Extended Properties start.
17:38:38.122|Info   |SQL Compare Engine  |9  |Populate Permissions  start.
17:38:38.635|Info   |SQL Compare Engine  |9  |Populate DB Settings start.
17:38:38.639|Info   |SQL Compare Engine  |9  |Populate Clean Dangling Objects.
17:38:38.642|Info   |SQL Compare Engine  |9  |Populate Cleanse Dependencies.
17:38:38.648|Info   |SQL Compare Engine  |9  |Register live database finished: Innov8.temp.innov8.head.3b9f7a94a5ebdd6a1442bae899c1f44aaaa56d16
17:38:38.683|Info   |SQL Compare Engine  |9  |Register live database start: innov8.head
17:38:38.687|Info   |SQL Compare Engine  |9  |Populate Live Start, popoptions: DatabaseCollation, DecryptPost2kEncryptedObjects
17:38:38.687|Info   |SQL Compare Engine  |9  |Populate Live Start, options: ForceColumnOrder, IgnoreFillFactor, IgnorePermissions, IgnoreWhiteSpace, CaseSensitiveObjectDefinition, IgnoreFullTextIndexing, IgnoreComments, IgnoreFileGroups, DoNotOutputCommentHeader, IgnoreUsers, IgnoreUserProperties, IgnoreWithElementOrder, IgnoreDatabaseAndServerName, DecryptPost2kEncryptedObjects
17:38:39.045|Warn   |SQL Compare Engine  |9  |Could not run DBCC DBINFO - cannot decrypt text objects.
17:38:39.072|Info   |SQL Compare Engine  |9  |Populate major version: SqlServer2008
17:38:39.100|Info   |SQL Compare Engine  |9  |Populate got casing: True
17:38:39.100|Info   |SQL Compare Engine  |9  |Populate Case Sensitive: True
17:38:39.132|Info   |SQL Compare Engine  |9  |Populate ObjectNames start.
17:38:39.190|Info   |SQL Compare Engine  |9  |Populate Users start.
17:38:39.573|Info   |SQL Compare Engine  |9  |Populate Tables start.
17:38:39.606|Info   |SQL Compare Engine  |9  |Populate Functions start.
17:38:39.637|Info   |SQL Compare Engine  |9  |Populate Defaults start.
17:38:39.665|Info   |SQL Compare Engine  |9  |Populate Rules start.
17:38:39.697|Info   |SQL Compare Engine  |9  |Populate UDTs start.
17:38:39.726|Info   |SQL Compare Engine  |9  |Populate Table UDTs start.
17:38:39.754|Info   |SQL Compare Engine  |9  |Populate Views start.
17:38:39.786|Info   |SQL Compare Engine  |9  |Populate View Cols start.
17:38:39.818|Info   |SQL Compare Engine  |9  |Populate Procs start.
17:38:39.848|Info   |SQL Compare Engine  |9  |Populate ObjectText start.

========== HERE STOPS THE EXECUTION, THE WHEEL JUST KEEPS TURNING ==========


I ask you to help me asap because the current version is not usable and the old one (10.0) is not able to do the things i need.

thank you for your help!
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Thu Feb 28, 2013 10:33 pm    Post subject: Reply with quote

Your log contains the following entry:

17:38:39.045|Warn |SQL Compare Engine |9 |Could not run DBCC DBINFO - cannot decrypt text objects.

This likely indicates a permissions issue.

Is the account you are using to perform the comparison a member of the sysadmin server role?
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
SeriousM



Joined: 27 Sep 2010
Posts: 11

PostPosted: Fri Mar 01, 2013 1:38 pm    Post subject: Reply with quote

Hi,

it turned out that a reboot was required after the update 10.0 to 10.2.6.114.

Problem solved, thanks!

Cheers
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group