Solved

SCCM 2007 data corruption

Posted on 2013-05-23
7
394 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 23

Expert Comment

by:Nagendra Pratap Singh
Comment Utility
Restore from backup.

For root cause, ask a DBA.
0
 
LVL 31

Expert Comment

by:merowinger
Comment Utility
MS Support.
Probably you have to reinstall....
0
 
LVL 1

Author Comment

by:SrikantRajeev
Comment Utility
DBA mentioned cause is possible missing or invalid keys for the index row matching.
But what caused this? Root cause?
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 31

Expert Comment

by:merowinger
Comment Utility
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
Comment Utility
Any one .....
0
 
LVL 23

Accepted Solution

by:
Nagendra Pratap Singh earned 500 total points
Comment Utility
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
Comment Utility
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
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 view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now