I don't manage mobile devices. I've got the table, but am missing columns. This... This is weird.
On Fri, Sep 4, 2015, 5:06 AM Andrew Craig <[email protected]> wrote: > 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]> 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]> 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]> 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]> 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]> 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]] *On Behalf Of *LEROY Mathieu > *Sent:* Thursday, September 3, 2015 4:10 AM > *To:* [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 ― *F* : +33 3 28 02 53 > 06 > > 24 rue Papin - BP 50488 - 59664 Villeneuve d'Ascq Cedex > > *email* : [email protected]― *web* : 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 > <http://www.digitalforallnow.com/>* > > > > *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/> > >
