Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to Fix Inconsistent Metadata Errors


How to Fix Inconsistent Metadata Errors

Author
Message
fastorro
fastorro
SSC-Enthusiastic
SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)

Group: General Forum Members
Points: 174 Visits: 1
I was woking in a reply of my real BBDD.

Thank's...

i have find the solution running instcat.SQL
from install dir.



dgm
dgm
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 44
A new twist......
2 servers running SQL7 SP3 and getting this error from a single table. I've manually check the ordinal numbers - they are identical and sequential... there should be no problem? There is, it still gives Msg 7353...

I have no explanation, I got round it by locally copying the data I needed into a new table and then querying that.


dgm
crutherfurd
crutherfurd
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 1
I can't thank you enough!!! You saved our production run from being late! I ran this on SQL Server 7 sp 4 and it worked like a charm.



ken_opp
ken_opp
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 6
Excellent solution. Took me 2 hours to find this article and then 5 more minutes to fix my problem.



ken_opp
ken_opp
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 6
At first I thought this worked, but further testing revealed that is corrupted the table. I have two 7.0 SP3 servers and after running sp_fixColOrder, I was able to read my table remotely. However, when I do a simple table join, I got this error:

Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails.

Now this error message (like most) did not make any sense because I'm doing a simple select and join (no update) yet getting an error indicating that an "insert fails".

Next I tried an sp_help on my table on received many errors. Here are a few:

Cannot insert the value NULL into column 'index_keys', table 'tempdb.dbo.#spindtab_

Cannot insert the value NULL into column 'cnst_type', table 'tempdb.dbo.#spcnsttab

I am sure it is the sp_fixColOrder that caused the error, because I recreated the database from a backup and ran my "join query" before and after running sp_fixColOrder.

Perhaps the problem is caused by my indexes, default constraints, and/or an identity column.



ken_opp
ken_opp
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 6
Again, two 7.0 SP3 databases both with MDAC 2.7.

After removing all indexes, constraints, and even SQL statistics I still got errors when I ran sp_fixColOrder.

So my final solution was to rename the table (sp_rename obj, obj_new), create a new table from scratch, and run an "insert into obj select * from obj_old".



Antares686
Antares686
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: Moderators
Points: 8752 Visits: 780
Sorry Ken I have been out with a new baby and not doing much of anything. I have found did run across a reason why my solution will not fix all cases but forgot where I put my notes. I would avoid it at this point and consider going to SP4 which fixed all the test issues I could create. I am still out so responses will be slim.



Frank Kalis
Frank Kalis
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6207 Visits: 289
Hi James,
quote:

Sorry Ken I have been out with a new baby and not doing much of anything.

is this some tricky sort of slang or does it mean what it reads

Just asking, before I congrat you to something completely different and make even more a fool out of me.

Cheers,
Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Antares686
Antares686
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: Moderators
Points: 8752 Visits: 780
Thanks, it means what it means. Sleepless nights, lots of crying, dirty diapers and feeding all the time. But I can't complain I am just the father, mom has it worse than me.



Frank Kalis
Frank Kalis
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6207 Visits: 289
Hey, let me explicitely say:

Congratulations to your newborn baby

I hope all are well ?!?

In case this is your first child, it might help you, that in max three years you'll laugh over your situation now. Somehow it turns into something sentimental glorified

Take care!

Cheers,
Frank


Here's a sproc written for me by David Burrows


DROP Dirty_Nappy
GO
SELECT Clean_Nappy FROM Nappy_Pile WHERE COUNT(Clean_Nappy) > 0
INSERT Baby INTO Clean_Nappy
GRANT ALL Smiles to Baby
GO


Edited by - Frank Kalis on 08/25/2003 04:31:32 AM

Edited by - Frank Kalis on 08/25/2003 04:32:11 AM

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search