Hi, Have you checked your SQL DB health? Are you running over remote connections? Have you checked your SQL Logs? Is the DEVICE_COMPUTERSYSTEM_DATA table there and healthy and are the columns mentioned in there?
Can you execute the Stored Procedure from SSMS? 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 Hi guys, Running the SP2 Upgrade on my R2 system (then will apply the R2 patch, and then CU1) and getting nasty errors on upgrade with. [Inline image 1] 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. 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? Thanks Stephen Owen
