If you are not managing devices (mobile devices) then this table should be empty. But there. And with all columns.
The DB on your SCCM Clone has missing columns in this table? Have you tried the site maintenance tasks? From: [email protected] [mailto:[email protected]] On Behalf Of Sean Pomeroy Sent: 03 September 2015 23:59 To: [email protected] Subject: Re: [mssms] Nasty SQL Errors when upgrading from R2 to R2 SP1 Nope. 2012 R2 RTM Also, no data was listed after executing the query. Just column headers. On Thu, Sep 3, 2015 at 5:57 PM Stephen Owen <[email protected]<mailto:[email protected]>> wrote: Sean, are you on cu5? When I applied r2sp1 in a lab, i have all of the columns. Haven't tried cu5 in a lab to see if they'd be present there. On Thu, Sep 3, 2015, 5:52 PM Sean Pomeroy <[email protected]<mailto:[email protected]>> wrote: When I select the table and return the first 1000 rows, this is the query. SELECT TOP 1000 [MachineID] ,[InstanceKey] ,[TimeKey] ,[RevisionID] ,[AgentID] ,[rowversion] ,[DeviceClientID00] ,[DeviceManufacturer00] ,[DeviceModel00] ,[DMVersion00] ,[FirmwareVersion00] ,[HardwareVersion00] ,[OEM00] ,[PlatformType00] ,[ProcessorArchitecture00] ,[ProcessorLevel00] ,[ProcessorRevision00] ,[Product00] ,[ProductVersion00] ,[SoftwareVersion00] ,[CellularTechnology00] ,[IMEI00] ,[MEID00] ,[PhoneNumber00] ,[SerialNumber00] ,[SubscriberCarrierNetwork00] ,[Jailbroken00] FROM [CM_P01].[dbo].[DEVICE_COMPUTERSYSTEM_DATA] On Thu, Sep 3, 2015 at 5:32 PM Stephen Owen <[email protected]<mailto:[email protected]>> wrote: Anyone have a valid CU5 database they can test against? I've installed up to CU5 but still don't have those columns. I'm thinking I might just be missing some columns in my SQL DB somehow. Looking for more than five columns under DBO.Device_computerSystem_data On Thu, Sep 3, 2015 at 4:21 PM, Stephen Owen <[email protected]<mailto:[email protected]>> wrote: Hi guys, I've got some updated info on the process here, under this post. https://social.technet.microsoft.com/Forums/en-US/c526baa5-6369-447e-96ac-0060db160421/running-testdbupgrade-from-r2-cu3-to-r2-sp1-fatal-sql-error?forum=configmanagergeneral To answer some questions, the DB is healthy, SCCM works, no issues there. When running /testDBUpgrade from my 2012 r2 CU3 database copy, I had the same issue. I've applied CU 4 now to my SCCM clone and still don't see those columns created. I'm about to try CU 5 and see if that is the one update which creates the missing columns. I have a sneaky suspicion that it will. On Thu, Sep 3, 2015 at 9:19 AM, Jason Sandys <[email protected]<mailto:[email protected]>> wrote: “I always recommand going to the latest CU before upgrading to the latest service pack Same goes with SQL and Windows” Sorry, not trying to bash, but there is no technical basis for this recommendation. There been a couple of exceptions for very specific circumstances, but these truly only applied to a very, very small percentage of installations. J From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of LEROY Mathieu Sent: Thursday, September 3, 2015 4:10 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Nasty SQL Errors when upgrading from R2 to R2 SP1 I always recommand going to the latest CU before upgrading to the latest service pack Same goes with SQL and Windows Cordialement, Mathieu Leroy Consultant T : +33 3 28 02 53 57 ― M : +33 6 21 63 74 15<tel:%2B33%206%2021%2063%2074%2015> ― F : +33 3 28 02 53 06<tel:%2B33%203%2028%2002%2053%2006> 24 rue Papin - BP 50488 - 59664 Villeneuve d'Ascq Cedex email : [email protected]<mailto:[email protected]>― web : www.osiatis.com<http://www.osiatis.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> De : [email protected] [mailto:[email protected]] De la part de Andrew Craig Envoyé : jeudi 3 septembre 2015 09:38 À : [email protected] Objet : RE: [mssms] Nasty SQL Errors when upgrading from R2 to R2 SP1<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> Hi,<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> Have you checked your SQL DB health? Are you running over remote connections? Have you checked your SQL Logs?<http://www.digitalforallnow.com/> Is the DEVICE_COMPUTERSYSTEM_DATA table there and healthy and are the columns mentioned in there?<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> Can you execute the Stored Procedure from SSMS?<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Owen Sent: 02 September 2015 19:24 To: [email protected] Subject: [mssms] Nasty SQL Errors when upgrading from R2 to R2 SP1<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> Hi guys,<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> Running the SP2 Upgrade on my R2 system (then will apply the R2 patch, and then CU1) and getting nasty errors on upgrade with. <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> The error mentions multiple invalid column names when trying to run this step. Fortunately for me, I'm using Kubisys on a copy of my infrastructure, so this hasn't taken down production. Still, with my upgrade slotted for tomorrow, I'd like to know how to fix this.<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> I'm upgrading from SCCM 2012 R2 RTM, applying SP1 to get up to date. Do you think I ought to apply one of the CU first? <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> Thanks<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> Stephen Owen<http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/> <http://www.digitalforallnow.com/>
