Couldn't locate object with name 'sysclsobjs' in schema ID4

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Couldn't locate object with name 'sysclsobjs' in schema ID4

Postby studentstf » Fri May 18, 2012 8:35 am

I'm testing SQL Compare 10.1. I have two backups of a database about 17 GB each other, one was made on sql server 2005 before migration to sql server 2008 r2, and another after. When I try to compare these backups, Sql Compare 10.1 trial version stop working with error "Couldn't locate object with name 'sysclsobjs' in schema '' (ID 4)".
studentstf
 
Posts: 1
Joined: Fri May 18, 2012 8:27 am

Postby Brian Donahue » Mon May 21, 2012 4:32 pm

I can understand why you would get this error, since sysclsobjs is a system object and therefore should be in the "SYS" schema. I don't know how the database got into this state, though. It looks as if possibly someone made manual changes to the system catalog, but SQL Server is designed to prevent you from doing that.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Mon May 21, 2012 4:39 pm

Ah, scratch that - it looks like an error in creating a view in the temporary database created to hold information about objects in the backup. SQL Compare's backup reader creates a temporary table on the hard disk and uses that to store a mock-up of the sys schema.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Tue May 22, 2012 9:55 am

Hello,

Is this situation still occurring, or was it a one-off?
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu May 24, 2012 2:29 pm

I suppose you could delete all temoirary files (using the Windows Disk Cleanup Utility) and try again... if that doesn't work, try restoring the backup file to SQL Server... it may be corrupt.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests