Improve company productivity with a Business Account.Sign Up

x
?
Solved

SCCM 2007 data corruption

Posted on 2013-05-23
7
Medium Priority
?
428 Views
Last Modified: 2013-07-22
During my daily check on the SCCM database, I ran into the error....
Data row of table 'ResPolicyMap' does not have a matching index row in the index 'ResPolicyMap_PADBID_MachineID_idx'.

Please let me know what data is stored in the ResPolicyMap table?
What are the reasons this issue could have occured?

To resolve the issue...
1. Changed database option to single user mode.
2. executed command DBCC CHECKDB('SMS_CNH', REPAIR_REBUILD)
3. executed command DBCC CHECKDB('SMS_CNH')

*** More importantly I need to understand the root casue why this happend in the first place?
0
Comment
Question by:SrikantRajeev
  • 3
  • 2
  • 2
7 Comments
 
LVL 25

Expert Comment

by:Nagendra Pratap Singh
ID: 39193287
Restore from backup.

For root cause, ask a DBA.
0
 
LVL 31

Expert Comment

by:merowinger
ID: 39193517
MS Support.
Probably you have to reinstall....
0
 
LVL 1

Author Comment

by:SrikantRajeev
ID: 39193816
DBA mentioned cause is possible missing or invalid keys for the index row matching.
But what caused this? Root cause?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
LVL 31

Expert Comment

by:merowinger
ID: 39193919
I had a similar problem after our SAN where our SQL Database was located on had a crash.
From this time one we had mayor problems within our database.
Backup was too old....too pitty
0
 
LVL 1

Author Comment

by:SrikantRajeev
ID: 39273774
Any one .....
0
 
LVL 25

Accepted Solution

by:
Nagendra Pratap Singh earned 2000 total points
ID: 39273783
root cause can be found if you work in environment daily. For outsiders like us it is hard.

Just follow the best practises for all parts/servers/san etc.
0
 
LVL 1

Author Closing Comment

by:SrikantRajeev
ID: 39346904
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question