myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Inventory Problems Invalid object name System_Data

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Inventory Problems Invalid object name System_Data Page: [1]
Login
Message << Older Topic   Newer Topic >>
Inventory Problems Invalid object name System_Data - 3/11/2008 5:03:24 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		I knew things were going too good for too long with my SMS systems.
I was right,
Today I checked the "All Status  Messages" under Status message queries to find that appearantly there are some issues with the SQL server. I am getting litterally TONS of these failures.

"ANY" helpful hints would be appreciated.

Below is the message that is diplayed:

Error Milestone GRD 3/11/2008 2:43:38 PM Server250 SMS_INVENTORY_DATA_LOADER 620 Microsoft SQL Server reported SQL message 208, severity 16: [42S02][208][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'System_DATA'. : pSystem_DATA   

Please refer to your SMS documentation, SQL documentation, or the Microsoft Knowledge Base for further troubleshooting information.
Post #: 1
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 9:31:57 AM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Found this in the dataldr.log file on the server.  Anybody got any clues here?

CDiscoverySource::VerifyClientPublicKeys - Public key does not exist for client GUID:865ADE45-09B1-4934-B364-B715C59478DE. SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
Modifying inventory data in the database now.  Executing 5 stored procedure calls. SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
ERROR - attempt to update non-existent row. Resync will be requested for commands: SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
0 -  exec pWorkstationStatus_DATA 1,108713,"03/11/2008 17:12:24",1,"3/11/2008 17:10",1033 SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
1 -  exec pServices_DATA 1,108713,"03/11/2008 17:12:24",1,"Windows Installer","MSIServer","C:\WINDOWS\system32\msiexec.exe /V","Share Process",0,"Manual","LocalSystem","Stopped","OK" SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
2 -  exec pLogical_Disk_DATA 1,108713,"03/11/2008 17:12:24",1,NULL,0,"Local Fixed Disk","D:",3,"NTFS",52673,"D:",NULL,56313,"REDSGIMWKF6C7EB","DATA","70AADAD3" SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
3 -  exec pSystem_DATA 1,108713,"03/11/2008 17:12:24",1,"nase.ds.army.mil","REDSGIMWKF6C7EB","GUID:865ADE45-09B1-4934-B364-B715C59478DE","Workstation","X86-based PC" SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
4 -  exec pLogical_Disk_DATA 1,108713,"03/11/2008 17:12:24",1,NULL,0,"Local Fixed Disk","C:",3,"NTFS",12247,"C:",NULL,20002,"REDSGIMWKF6C7EB",NULL,"E08CC331" SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
Remote client hardware inventory resync generated for client GUID:865ADE45-09B1-4934-B364-B715C59478DE; update/insert result = 1 SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
Send resync command to local site for machine GUID:865ADE45-09B1-4934-B364-B715C59478DE. SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
STATMSG: ID=2722 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=REDSTONE250 SITE=GRD PID=2284 TID=7136 GMTDATE=Tue Mar 11 22:12:24.607 2008 ISTR0="REDSGIMWKF6C7EB" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
Cannot process MIF X1cmuk6g1.MIF, moving it to D:\SMS\inboxes\auth\dataldr.box\BADMIFS\15glftgn.MIF SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
STATMSG: ID=2703 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_INVENTORY_DATA_LOADER" SYS=REDSTONE250 SITE=GRD PID=2284 TID=7136 GMTDATE=Tue Mar 11 22:12:24.623 2008 ISTR0="X1cmuk6g1.MIF" ISTR1="D:\SMS\inboxes\auth\dataldr.box\BADMIFS\15glftgn.MIF" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
Finished processing file X1cmuk6g1.MIF SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)
Processing file 11m7dm9x.MIF SMS_INVENTORY_DATA_LOADER 3/11/2008 5:12:24 PM 7136 (0x1BE0)

(in reply to sphillips237)
Post #: 2
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 3:36:32 PM   
bmason505

 

Posts: 1984
Score: 104
Joined: 1/23/2003
From: Minneapolis, MN
Status: offline 		Well I don't think you lost your entire system data table.  Sounds more like you should mofcomp your clients again and make sure all servers are using the same sms_def.mof.

Or maybe more obvious - are machines being deleted in the database?  Anyone doing delete specials from the console?  Are your SQL tasks deleting clients that aren't really dead?  Do you have heartbeat discovery enabled?


_____________________________

Brian Mason
MCSA\MCSE\MS MVP - SCCM
Wells Fargo
http://www.miscusergroup.org/

(in reply to sphillips237)
Post #: 3
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 3:57:32 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Brian, Thanks so much for your reply !!!
 
I have confirmed that pServices_DATA, pLogical_Disk_DATA, pSystem_DATA and pSystem_DATA are all inded still in the database as stored procedures.
 
I have 6,500 PC's spread out accross 5 child sites and 1 central.  This has been a slow process putting all this together by myself.... I've wondered how long I could get my with not having the same mof on the central server 
 
Not sure what Mof Comping my clients is??
 
I have to be honest here, only this server in question, has the modified mof. All the other servers are running the standard mof.  This Mof has been running fine for over a year.
 
Yes I've been deleting duplicates out of the SMS from the console. And I've been doing special deletes from the console to take all the duplicates found in my dup. query collection.  Is that a bad thing??
SQL tasks deleting clients that aren't dead - Well not that I know of .................
 
Heartbeat discovery is enabled.
 
I really appreciate the help here I've been trying to figure out how to cross the boss with a call to Microsoft he don't want to pay for.


(in reply to bmason505)
Post #: 4
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 4:34:45 PM   
bmason505

 

Posts: 1984
Score: 104
Joined: 1/23/2003
From: Minneapolis, MN
Status: offline 		Usually, you want the same mof everywhere as a rule; but all rules have exceptions.  Why does this one server have a modified mof, does it have clients, have those clients run mofcomp against this changed mof?  And in this case, I don't mean turning on or off reporting, but more like new classes being added in the mof.

Delete specials are OK, if the clients you're deleting are really dead.

In the SMS console under site maintenance\tasks, there are things that can delete clients.  They should meet up with your heartbeat or health tool.  For example if you set delete aged discovery to weekly but had heartbeat set to only two weeks, you'd kill all your clients off before they could remind SMS that they are alive.  I'd go over all those settings.


_____________________________

Brian Mason
MCSA\MCSE\MS MVP - SCCM
Wells Fargo
http://www.miscusergroup.org/

(in reply to sphillips237)
Post #: 5
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 4:59:11 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Thanks Brian,
 
I have good intentions to get the MOF on all servers but have been so busy and really sometimes the last thing I want to do is tempt fate  HA!
 
The one child server has the modified MOF because just 9 months ago all these clients were on this ONE MAIN server. So all the tweaking was done on that server.
Since then team that was here left and I have the job, so I've been adding servers trying to get the heiarchy setup. Honestly Things have been going
pretty good until yesterday this started.....
 
All the child sites including this one in question have clients. The central server doesn't have clients.
I know that the this server has an advertisement that is mof.vbs that runs against all the clients. If that what you meant by mofcomp'd
 
About 2 months ago i moved all the site maintence task up from 30 days to 20. I would think if that were the problem I would have already seen it.
 
My bad mif folder has about 600 bad mifs in there should I delete those.


(in reply to bmason505)
Post #: 6
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 5:26:43 PM   
bmason505

 

Posts: 1984
Score: 104
Joined: 1/23/2003
From: Minneapolis, MN
Status: offline 		Getting the mof on all the servers shouldn't take long (simple copy paste to each SMS\inboxes\clifiles.src\hinv folder) depending on how many you have.  What could take longer is getting those clients on the same page.  So what are the changes made?  That's probably the key question here, because you might not have to mofcomp the clients at all.  Also, if you took this sms_def.mof, copied it to your PC, and from a cmd line typed mofcomp sms_def.mof, does it throw up errors?

And if you had lots of laptops that were offline for a long time, they could get killed if they didn't pop back on the network within 20 days.


_____________________________

Brian Mason
MCSA\MCSE\MS MVP - SCCM
Wells Fargo
http://www.miscusergroup.org/

(in reply to sphillips237)
Post #: 7
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 6:06:59 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		I copied the mof down and comp'd it on my pc it ran w/o an issue.
I opend the mof in notepad and there are changes that are noted by the previous admins here.

It seems like to me as if for some readon data can't get written to those 5 stored procedures in the data base.
As if they are corrupt ?!?!?

here is what's in the dataldr.log

Processing Inventory for Machine: PC NAME  Generated: 03/12/2008 16:52:27 SMS_INVENTORY_DATA_LOADER 3/12/2008 4:52:58 PM 10684 (0x29BC)
File successfully parsed.  Processing item PC NAME (GUID = GUID:B7D0F99D-A9E3-44ED-BBE5-058D8EA03600) SMS_INVENTORY_DATA_LOADER 3/12/2008 4:52:58 PM 10684 (0x29BC)
CDiscoverySource::VerifyClientPublicKeys - Public key does not exist for client GUID:B7D0F99D-A9E3-44ED-BBE5-058D8EA03600. SMS_INVENTORY_DATA_LOADER 3/12/2008 4:52:58 PM 10684 (0x29BC)
Pragma delete found in inventory group MICROSOFT|HW_DEVICES|1.0.  Deleting group... SMS_INVENTORY_DATA_LOADER 3/12/2008 4:52:58 PM 10684 (0x29BC)

Modifying inventory data in the database now.  Executing 5 stored procedure calls. SMS_INVENTORY_DATA_LOADER 3/12/2008 4:52:58 PM 10684 (0x29BC)
***  exec pWorkstationStatus_DATA 1,103442,"03/12/2008 16:52:58",1,"3/12/2008 16:52",1033;

~ exec dHW_Devices_DATA 3,103442,"03/12/2008 16:52:58",1,"Microsoft Kernel Wave Audio Mixer","SW\{B7EAFDC0-A680-11D0-96D8-00AA0051E51D}\{9B365890-165F-11D0-A195-0020AFD156E4}","Microsoft Kernel Wave Audio Mixer","OK";

~ exec pLogical_Disk_DATA 1,103442,"03/12/2008 16:52:58",1,NULL,0,"Local Fixed Disk","C:",3,"NTFS",2803,"C:",NULL,19006,"PCNAME",NULL,"E08CC331";~ exec pLogical_Disk_DATA 1,103442,"03/12/2008 16:52:58",1,NULL,0,"Local Fixed Disk","D:",3,"NTFS",28679,"D:",NULL,38217,"PC NAME","DATA","6486C7AA";

~ exec pSystem_DATA 1,103442,"03/12/2008 16:52:58",1,"DOMAN.army.mil","PCNAME","GUID:B7D0F99D-A9E3-44ED-BBE5-058D8EA03600","Workstation","X86-based PC" SMS_INVENTORY_DATA_LOADER 3/12/2008 4:52:58 PM 10684 (0x29BC)
*** [42S02][208][Microsoft][ODBC SQL Server Driver][SQL Server]

Invalid object name 'System_DATA'. : pSystem_DATA 
SMS_INVENTORY_DATA_LOADER 3/12/2008 4:52:58 PM 10684 (0x29BC)

< Message edited by sphillips237 -- 3/13/2008 7:46:40 AM >

(in reply to bmason505)
Post #: 8
RE: Inventory Problems Invalid object name System_Data - 3/12/2008 9:44:17 PM   
bmason505

 

Posts: 1984
Score: 104
Joined: 1/23/2003
From: Minneapolis, MN
Status: offline 		I have a hard time believing that the client which sent that log up really has a name of PCNAME.  Sounds too generic, doesn't it?  Sounds dupe GUID related.  Like you're running SMS during imaging, the client is sending up data with its generic name before being renamed, and causing these entries.

<Might want to edit your article and change the AD name to hide your domain name>


_____________________________

Brian Mason
MCSA\MCSE\MS MVP - SCCM
Wells Fargo
http://www.miscusergroup.org/

(in reply to sphillips237)
Post #: 9
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 7:49:05 AM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		the PCNAME was an attempt to sanitize the log file but looks like I failed at that by leaving the domain name on there

(in reply to bmason505)
Post #: 10
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 11:13:57 AM   
bmason505

 

Posts: 1984
Score: 104
Joined: 1/23/2003
From: Minneapolis, MN
Status: offline 		OK, let's discount my 1st assumption.  Maybe you better rule out DB errors and run a dbcc checkdb on the SMS DB.

_____________________________

Brian Mason
MCSA\MCSE\MS MVP - SCCM
Wells Fargo
http://www.miscusergroup.org/

(in reply to sphillips237)
Post #: 11
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 1:34:19 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Well, I'm a big fan of looking at the actual problem that the log says and ruling that out first.

Open up SQL Management Studio and go to the tables and just make sure the SYSTEM_DATA table exists

DATABASES
  + <SMSDB>
      + TABLES
          + dbo.SYSTEM_DATA

First of all does that exist?  If not, you have MAJOR problems.  If it DOES exist, then we may just have permissions issues or something else wierd. So let's just rule this out first.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to bmason505)
Post #: 12
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 2:04:31 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		HEY JOHN,

Nice to talk to you again!

Well I did as you stated above...........

System_data does not show up in my tables.

It does show up in the Stored Procedures........
What could have happened to my table?
Somehow I get the feeling that my day is going to get longer.

BTW: Don't know if this matters, but, none of my tables show up as dbo.System_data. Is the dbo supposed to be in front of all the tables? It's not that way on my other servers?

Thanks so much for your help


(in reply to jnelson993)
Post #: 13
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 2:37:26 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Uh oh...yeah, that's not the same.  the dSystem_Data and pSystem_Data objects are stored procedures that work with the dbo.SYSTEM_DATA table...if that thing isn't there under tables I can't imagine what someone there has done.

So you don't see the dbo. in front of all the tables?  Do you at least see a ton of OTHER tables in the list or is the list really small?

Thumbnail Image

You know, did someone do some security changes lately?  If you removed BUILTIN\Administrators from SYSSADMIN or something, you could see behavior like this.




Attachment (1)

< Message edited by jnelson993 -- 3/13/2008 2:42:10 PM >

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to sphillips237)
Post #: 14
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 2:54:28 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Maybe the view is different in SQL Server Enterprise Manager. But I don't see dbo in front of the table see my pic.

Well I never know what is going to happen with my servers. The server group is allway patching/changing servers so I couldn't tell you if they have changed permissions but I will got take a look see.

Is there a way I can restore that table w/o doing a full database restore?




Thumbnail Image


Attachment (1)

(in reply to jnelson993)
Post #: 15
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 3:16:39 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Yeah, it's just a little different in SQL Server Management Studio.  They put the DBO in front of the table name. 

I can't be sure, but.if I were to guess, I'd say it looks like someone has been doing something with permissions...

Theoretically you could attach a copy of the DB, export a table to a file, then import it into the current SMS DB, but if that table's missing, what else is missing?  And there's no way of knowing all the other things that it is supposed to tie to that you need to make sure is in sync too.  If it's not permissions and the table is physically gone, then I think it'd be best to assume it's a bust and go through the full disaster recovery procedures on that server.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to sphillips237)
Post #: 16
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 3:28:56 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		This is not good John.

Just so I can get this straight how could permission changes cause a table to dissappear?


(in reply to jnelson993)
Post #: 17
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 3:43:03 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		It's not actually gone if it's permissions.

Let's give this as an example.  Some well-meaning DBA guy logs into the SQL server and goes to SECURITY -> LOGINS and says, 'Hey, BUILTIN\Administrators has SYSADMIN rights, that means everyone who can administer the server also has full access to every DB within SQL.  That's a security problem, I better remove that'.  So they remove BUILTIN\Administrators.  And possibly SYSTEM too.  Chances are that's how YOU got full rights to the SMS DB in the first place, unless you explicitly made a SQL login that tied to a security group.  That could also be where SMS got it's rights if it's using SYSTEM.  Now that Admins is gone, you aren't a SYSADMIN on the box, so you're problably getting permissions under some other more limited user that exists.  This user may only have rights to see some of the tables/views/procs etc.  And if SMS's rights were removed, that's why IT thinks the table isn't there too.

So, if you have access to the SA account and password, then login to SQL Management Studio or whatever you've got there.  If it's just permissions, you'll be able to see it all while logged in as SA, then you can set the permissions back so you and SMS can access everything properly, if it's STILL missing as SA, then it's Miller Time.



_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to sphillips237)
Post #: 18
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 4:10:43 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Oh, one more option Brian just reminded me of...if SYSTEM still has rights to the SMS DB, you can start a CMD prompt at SYSTEM and run SQL management studio from there.  You'll be logged in as system which SHOULD have full rights to the DB unless they really did a number on your security.

http://myitforum.com/cs2/blogs/jnelson/archive/2008/02/15/112673.aspx


_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to jnelson993)
Post #: 19
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 4:21:21 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Miller Time? May just skip that and go right for the Jack tonite

Getting better by the moment............

was able to get the sql maintenance folks to let me have the sa long enough to view....

That table is still missing with the SA account......

Can't I just restore from SMS database backup from last week?

Again, thanks  for your time

(in reply to jnelson993)
Post #: 20
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 4:30:41 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Duuuuuude.  That sucks.  Well, since it's hosed, try:
   DBCC CHECKDB 'DBNAME' REPAIR_ALLOW_DATA_LOSS (I think that's the syntax...check it)
Just in case.  Maybe you'll get lucky and it'll find some data somewhere.
 
Like I said, you COULD restore from the latest SMS backup, but if this table is missing, what else is missing?  You might get it to limp along ACTING like it's working, but things are all hosed behind the scenes.  Are you replicating up/down to other servers or is this standalone?  I'd be inclined to pull out the disaster recovery plan, but you're set on it, you can certainly TRY to restore from an old backup.  Attach to the backup DB, export the table, import the table to the production db.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to sphillips237)
Post #: 21
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 4:45:49 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		I am replicating this data up to the central server.
Would this table not be on the central server DB?


When you say "Disaster Recovery" what exactly do you mean?
I thought restoring from the back up is disaster recovery?

Thanks

(in reply to jnelson993)
Post #: 22
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 6:28:36 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		By disaster recovery I meant the whole big site restore procedure.  I was under the impression that you just wanted to try to restore that one table.  I'd recommend against that, but if you're talking about the big one, then sorry, I misunderstood.
Hmm, was there anything on this server that isn't already on the parent? Custom inventory items, custom packages, custom collections, etc? My thought is you can delete the child site and tell the primary to create another one and everything will replicate back down again.  Then you don't need to restore anything really.  I'm just thinking out loud here, I haven't fully thought that out.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to sphillips237)
Post #: 23
RE: Inventory Problems Invalid object name System_Data - 3/13/2008 6:46:40 PM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Yeah, Brian and I were just talking on the side.  We're thinking your best bet is going to be to wipe out the site, create a new one and use a GPO to force the clients to use it unless you had 500 custom objects or something...even then, a restore from a week old backup? Yuck.  Maybe you can export any custom objects to MOF files before you kick it in the teeth.  I'd say it might be a straight tequila night for you.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to jnelson993)
Post #: 24
RE: Inventory Problems Invalid object name System_Data - 3/16/2008 11:18:39 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Ok, at work on Monday I'm going to start on this good, bad, or ugly.

See what you all think of these steps. I am trying to be as minimaly invasive as possible.
There is approx 4 years worth of collections, queried or otherwise. Probably several hundred
advertisements, packages, custom reports. ITMU and the reporting that goes with it. You name it and it's probably on this server.......Like I said it's the orginal server. It would probably take me another year to get this server back to where it was........
Any and ALL comments appreciated.

1st - to run the checkdb without the repair on

2nd - depending that results of 1 do a checkdb with repair.

3rd - if that doesn't work try to import the table from the sql back up or maybe the central server.( Not sure how to do that yet)

4th - And if that doesn't work do a complete restore from a week old back up....

Thanks for all the help folks


(in reply to jnelson993)
Post #: 25
RE: Inventory Problems Invalid object name System_Data - 3/17/2008 10:29:10 AM   
jnelson993


Posts: 805
Score: 113
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		I'd vote against #3.  If you import the table from the central server, you'll find the resourceIDs from that DB are different from the resourceIDs in this DB.  If you import from a week old backup, it'll be out of sync...some records in it  would be orphaned because of machines that have been removed, and there may be other tables that are joined to SYSTEM_DATA that are missing or out of sync too.  There's just no way of knowing how SMS will behave with stuff so out of whack and in an unknown state (unless you helped designed SMS and knew what the ramifications would be...that would be nice)

BTW, is there a reason your backups are weekly instead of nightly?  There's a lot that can happen in a week...

Wait...I just thought of something.  If someone deleted the system_data table, or corruption wiped it out, your backups may also reflect that.  Not too long ago, a company I was contracting for had corruption in a mainframe DB application.  They have backups and a secondary hot-copy site.  Their backups and copy were so good that the corruption was copied to the hot-copy site within 750ms.  It took a couple extra hours to get an emergency tape couriered from Iron Mountain so they could restore from that point and roll the transaction logs forward from there.  My point is, if that table has been missing for a while, you may have to go to a really old tape to find it uncorrupted/undeleted.  At that point, what good is the backup and can you really rely on what you are restoring?

You might want to work with MS support to export all of the custom stuff that's not hosed, have the primary create a new site, and restore the custom stuff.

I'm just sayin. 

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to sphillips237)
Post #: 26
RE: Inventory Problems Invalid object name System_Data - 3/17/2008 11:04:37 AM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Yea, I got a call into MS this morning to see how they can help me get this straightened out...........

I put a lot of thought about what may have happened this weekend and feel in retrospect that someone
deleted that object. I'm not pointing fingers at anybody though. So that's really beside the point.

Once all is figured out I'll reply back to this post to let all our forum friends learn by my situation.

Thanks again!

(in reply to jnelson993)
Post #: 27
RE: Inventory Problems Invalid object name System_Data - 7/1/2008 4:42:07 PM   
sphillips237

 

Posts: 79
Score: 0
Joined: 9/10/2007
Status: offline 		Sorry, I'm a little late with this follow up-

The call to MS got me up and going as they just recreated the table in the database as I watched it start filling up with data.

Thanks MS. :)


(in reply to sphillips237)
Post #: 28
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Inventory Problems Invalid object name System_Data Page: [1]
Jump to: