Yeah, I'd remove the new section from configuration.mof; (or grab a backup
copy of configuration.mof from installedlocation\data\hinvarchive and put
it back), just to be sure that error stops happening when you do.
I'll fire up my lab and see what happens when I dump that mof edit into my
lab. I don't see any sql reserved words (sometimes that causes flakiness
with mof edits), so nothing leaps out as "here's the issue".
On Tue, May 2, 2017 at 6:55 AM, <henry.wil...@sanofi.com> wrote:
> Hi Sherry
>
> For whatever reason, when I added it to the bottom of the
> Configuration.mof and watched the Dataldr.log – that message began to pop
> up. And it’s recurring every minute…
>
>
>
> Here is the console import portion:
>
> =====================================
>
> // RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac, Jonas
> Hettich & Kent Agerlund)
>
> // this section tells the inventory agent what to report to the server
>
> // 5/1/2017 9:20:23 AM
>
>
>
> #pragma namespace ("\\\\.\\root\\cimv2\\SMS")
>
> #pragma deleteclass("OEMInformation", NOFAIL)
>
> [SMS_Report(TRUE),SMS_Group_Name("OEMInformation"),SMS_
> Class_ID("OEMInformation|OEMInformation|1.0"),
>
> SMS_Context_1("__ProviderArchitecture=32|uint32"),
>
> SMS_Context_2("__RequiredArchitecture=true|boolean")]
>
> Class OEMInformation: SMS_Class_Template
>
> {
>
> [SMS_Report(TRUE),key] string KeyName;
>
> [SMS_Report(TRUE)] String Manufacturer;
>
> [SMS_Report(TRUE)] String Logo;
>
> [SMS_Report(TRUE)] String Model;
>
> };
>
>
>
> #pragma namespace ("\\\\.\\root\\cimv2\\SMS")
>
> #pragma deleteclass("OEMInformation_64", NOFAIL)
>
> [SMS_Report(TRUE),SMS_Group_Name("OEMInformation64"),SMS_
> Class_ID("OEMInformation|OEMInformation64|1.0"),
>
> SMS_Context_1("__ProviderArchitecture=64|uint32"),
>
> SMS_Context_2("__RequiredArchitecture=true|boolean")]
>
> Class OEMInformation_64 : SMS_Class_Template
>
> {
>
> [SMS_Report(TRUE),key] string KeyName;
>
> [SMS_Report(TRUE)] String Manufacturer;
>
> [SMS_Report(TRUE)] String Logo;
>
> [SMS_Report(TRUE)] String Model;
>
> };
>
> =====================================
>
>
>
> I’m not sure where to go with this one – Should I try to take everything
> out? Does this possibly indicate a permissions issue? The account I used
> is a Sysadmin of the database.
>
>
>
> Thanks for your help Sherry!
>
>
>
>
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Sherry Kissinger
> *Sent:* Monday, May 01, 2017 5:33 PM
> *To:* mssms@lists.myitforum.com
> *Subject:* Re: [mssms] Creating a MOF change causing issue - CM1606 / SQL
> 2012
>
>
>
> "CSqlSchema::CreateTable - error in CSql->Execute() create table dbo, MOF
> change, SQL 2012"
>
>
>
> That snippet you have is for the bottom of configuration.mof; not to be
> imported; so I'm confused why CM even wants to create a table. It
> shouldn't be at the "let's make a table and view" stage until you either
> import a report mof (the stuff with true/false), or if you browse to a box
> that successfully ran the configuration.mof snippet compile, and has the
> wmi classes now.
>
>
>
> Are you trying to import that snippet; or adding it to the bottom of
> configuration.mof?
>
>
>
> On Mon, May 1, 2017 at 9:43 AM, <henry.wil...@sanofi.com> wrote:
>
> Hello
>
> Trying to add OEMInformation to the Hardware Inventory using the Mof
> output from RegKeyToMOFv3_R2.exe and receiving this message in the
> Dataldr.log
>
>
>
> ============================================================
> ===============
>
> CSqlSchema::CreateTable - error in CSql->Execute() create table dbo, MOF
> change, SQL 2012
>
> ============================================================
> ===============
>
>
>
> ==================
>
> Configuration.mof addition
>
> ==================
>
> // RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac, Jonas
> Hettich & Kent Agerlund)
>
> // this section tells the inventory agent what to collect
>
> // 5/1/2017 9:20:23 AM
>
>
>
> #pragma namespace ("\\\\.\\root\\cimv2")
>
> #pragma deleteclass("OEMInformation", NOFAIL)
>
> [DYNPROPS]
>
> Class OEMInformation
>
> {
>
> [key] string KeyName;
>
> String Manufacturer;
>
> String Logo;
>
> String Model;
>
> };
>
>
>
> [DYNPROPS]
>
> Instance of OEMInformation
>
> {
>
> KeyName="RegKeyToMOF_32";
>
> [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\
> CurrentVersion\\OEMInformation|Manufacturer"),
> Dynamic,Provider("RegPropProv")] Manufacturer;
>
> [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\
> CurrentVersion\\OEMInformation|Logo"),Dynamic,Provider("RegPropProv")]
> Logo;
>
> [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\
> CurrentVersion\\OEMInformation|Model"),Dynamic,Provider("RegPropProv")]
> Model;
>
> };
>
>
>
> #pragma namespace ("\\\\.\\root\\cimv2")
>
> #pragma deleteclass("OEMInformation_64", NOFAIL)
>
> [DYNPROPS]
>
> Class OEMInformation_64
>
> {
>
> [key] string KeyName;
>
> String Manufacturer;
>
> String Logo;
>
> String Model;
>
> };
>
>
>
> [DYNPROPS]
>
> Instance of OEMInformation_64
>
> {
>
> KeyName="RegKeyToMOF_64";
>
> [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\
> CurrentVersion\\OEMInformation|Manufacturer"),
> Dynamic,Provider("RegPropProv")] Manufacturer;
>
> [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\
> CurrentVersion\\OEMInformation|Logo"),Dynamic,Provider("RegPropProv")]
> Logo;
>
> [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\
> CurrentVersion\\OEMInformation|Model"),Dynamic,Provider("RegPropProv")]
> Model;
>
> };
>
> ================================
>
>
>
> Any Help is appreciated.
>
> Thanks
>
>
>
>
>
>
>
>
> --
>
> Thank you,
>
> Sherry Kissinger
>
>
> My Parameters: Standardize. Simplify. Automate
> Blogs: http://www.mofmaster.com
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.mofmaster.com&d=DQMFaQ&c=Dbf9zoswcQ-CRvvI7VX5j3HvibIuT3ZiarcKl5qtMPo&r=rYU1OkDK6KGNCD3HQmVUxzwASyVld-wfgoG00ci6xjA&m=YPyHr7OObS_34hvCcT1iz-Q45hEcDl-f762Mn6lD3a4&s=0Oew_Nv8s9YEW66jZlw1jNla6IXLDUe3NelB1YtuSLQ&e=>,
> http://mnscug.org/blogs/sherry-kissinger
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__mnscug.org_blogs_sherry-2Dkissinger&d=DQMFaQ&c=Dbf9zoswcQ-CRvvI7VX5j3HvibIuT3ZiarcKl5qtMPo&r=rYU1OkDK6KGNCD3HQmVUxzwASyVld-wfgoG00ci6xjA&m=YPyHr7OObS_34hvCcT1iz-Q45hEcDl-f762Mn6lD3a4&s=nwY65kBJgSQ4mrBkrBspYa9F-yU3Eq_iqhsNKqVwPz8&e=>,
> http://www.smguru.org
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.smguru.org&d=DQMFaQ&c=Dbf9zoswcQ-CRvvI7VX5j3HvibIuT3ZiarcKl5qtMPo&r=rYU1OkDK6KGNCD3HQmVUxzwASyVld-wfgoG00ci6xjA&m=YPyHr7OObS_34hvCcT1iz-Q45hEcDl-f762Mn6lD3a4&s=Ii0apflGDBDmbaG8XsjQ0Z94VMq86ip-Qy9YlYsCGCg&e=>
>
>
>
>
--
Thank you,
Sherry Kissinger
My Parameters: Standardize. Simplify. Automate
Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger,
http://www.smguru.org
