locked
Unable to import MP - invalid columns RRS feed

  • Question

  • Hi everyone,

    I am trying to update a Management Pack that I wrote that discovers several classes using a VB script.  In this update, I am adding a new property to each class, called LocaleName.

    The MP was saved in the authoring console, and verified in the authoring console.

    I sealed the MP, and then tried to import it.  I got the message "the Management pack is invalid" at the console, and on the RMS, I see these messages:

    Event ID 33333:

    Data Access Layer rejected retry on SqlError:

    Request: MPInfra_p_ManagementPackInstall -- (ManagementPackXML=<ManagementPack xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" ContentReadable="t...), (ManagementPackXMLUpdateFragment=), (RunTimeXML=<ManagementPack xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" ContentReadable="t...), (MPKeyToken=89d8bf5f10944628), (RETURN_VALUE=0)

    Class: 16

    Number: 207

    Message: Invalid column name 'LocaleName_CA5D45CB_4D00_3FC2_ADAD_AC95373AF61E'.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    ---------------------------

    and

    Event ID 26319

    An exception was thrown while processing ImportManagementPack for session id uuid:9b5c4f48-2787-4fbc-82ef-b6c876d16d37;id=611.

    Exception Message: The creator of this fault did not specify a Reason.

    Full Exception: System.ServiceModel.FaultException`1[Microsoft.EnterpriseManagement.Common.ManagementPackException]: The creator of this fault did not specify a Reason. (Fault Detail is equal to : Database error. [MPInfra_p_ManagementPackInstall] failed with exception:

    Database error. [MPInfra_p_ManagementPackInstall] failed with exception:

    Invalid column name 'LocaleName_2A624C68_B7A2_D9A7_E336_FCCCDDE33BE9'.

    Invalid column name 'LocaleName_402BC24E_ED9A_55C5_AEBA_D165A06DA4F7'.

    Invalid column name 'LocaleName_15E9BE71_214A_ABB4_69A0_1F88143B9450'.

    Invalid column name 'LocaleName_C81A094D_63DB_34F9_23E3_2D121449399E'.

    Invalid column name 'LocaleName_4F5D5BEB_2CB1_8017_B5B6_FAD585AB5E55'.

    Invalid column name 'LocaleName_D70D28C2_5357_A6A4_72FC_45BA35A3B4CE'.

    Invalid column name 'LocaleName_3BF24195_5E6B_437E_F120_A66C5DC7842C'.

    Invalid column name 'LocaleName_9D392F7E_B183_1313_B2B5_F368E863FD44'.

    Invalid column name 'LocaleName_BA4E58C1_9622_3074_CF17_B2D53198CF45'.

    Invalid column name 'LocaleName_17A66B3F_6B63_82F1_265B_EF1A6207E883'.

    Invalid column name 'LocaleName_CA5D45CB_4D00_3FC2_ADAD_AC95373AF61E'.

    Invalid column name 'LocaleName_83A7FEE2_F43E_4446_FC82_AD1343380E21'.

    Inval...).

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp

    -------------------------

    I am running SCOM 2007 R2 Cumulative Update 3.  The database is SQL 2005 SP3, on Win 2003 x64.  The RMS runs on a Win 2003 x64 server.

    Thanks in advance,

    Steve

    Tuesday, April 19, 2011 8:53 PM

Answers

  • Actually, any chance these are VIEW column names?  The presence of guids tells us that you created them in the operators console and then saved them to an MP.xml file.  If you then try and import that xml file into another SCOM instance, they won't work because those are instance specific ID values.
    Microsoft Corporation
    • Marked as answer by Vivian Xing Thursday, April 28, 2011 8:42 AM
    Monday, April 25, 2011 9:32 PM
  • Actually, I did try to make some additional objects public. 

    I use both the Operators console and the Authoring guide when I maintain MPs.  In fact, sometimes I even edit the .xml itself.  Perhaps I need to instill more discipline in my work.

    In the meantime, I made up a separate MP to get the information.  I had to do this due to time pressures. 

    I really should take a couple of steps back and re-read the documentation. 

    Thanks to everyone for their assistance!

    Steve

    • Marked as answer by stevetarzon Friday, April 29, 2011 1:57 PM
    Friday, April 29, 2011 1:57 PM

All replies

  • Hi,

    This can be an account permission or connection issue. Please check if any information in the following article will help:

    Troubleshooting event id 33333 logged by the DataAccessLayer:

    http://blogs.msdn.com/b/boris_yanushpolsky/archive/2008/01/24/troubleshooting-event-id-33333-logged-by-the-data-access-layer.aspx

    OpsMgr 2007: DataAccessLayer Event ID 33333 with "should not generate data about this managed object"

    http://blogs.technet.com/b/smsandmom/archive/2008/03/13/opsmgr-2007-dataaccesslayer-event-id-33333-with-should-not-generate-data-about-this-managed-object.aspx

    Alert with EventId 33333 and Source DataAccessLayer

    http://social.technet.microsoft.com/Forums/en-US/operationsmanagerextensibility/thread/5f40a475-b76c-40cf-895f-231099507efe/


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, April 20, 2011 7:50 AM
  • Thank you Vivian, I will take a look.

    Steve

    Wednesday, April 20, 2011 1:08 PM
  • Hi Steve

    I realised that you have added a new property but have you made any changes to existing parts of the Management Pack?

    If you execute the VBScript manually (passing appropriate parameters), does the output look correct?

    http://blogs.technet.com/b/kevinholman/archive/2010/03/09/basic-troubleshooting-of-discovery-scripts.aspx

    Cheers

    Graham

     


    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
    Wednesday, April 20, 2011 1:35 PM
  • Hi Steve!

    Do you have a staging environment where the old version of the MP is installed?

    If so, would it be possible to verify if you can delete the old version and then import the new one?

     

    Is the ClassType marked public?

    Is the new property marked as Key?

    If so, read the chapter on version control in the Authoring Guide.

    There is a number of things to consider when upgrading to new versions of MPs.

    /Roger

     


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Sunday, April 24, 2011 8:17 AM
  • Thanks Roger, I will take a look.  I have a feeling I've done something that doesn't permit me to upgrade the version of the MP.  I am sure it is not a permission problem, I have other MPs I've been able to update.
    Monday, April 25, 2011 1:23 PM
  • Yes, do take a look. Unfortunately, the error shown, when trying to import a MP, with these issues, is not very informative.

    I've run into this a number of times (my own fault, read the fine manual :)).

    /Roger


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, April 25, 2011 4:54 PM
  • Actually, any chance these are VIEW column names?  The presence of guids tells us that you created them in the operators console and then saved them to an MP.xml file.  If you then try and import that xml file into another SCOM instance, they won't work because those are instance specific ID values.
    Microsoft Corporation
    • Marked as answer by Vivian Xing Thursday, April 28, 2011 8:42 AM
    Monday, April 25, 2011 9:32 PM
  • Actually, I did try to make some additional objects public. 

    I use both the Operators console and the Authoring guide when I maintain MPs.  In fact, sometimes I even edit the .xml itself.  Perhaps I need to instill more discipline in my work.

    In the meantime, I made up a separate MP to get the information.  I had to do this due to time pressures. 

    I really should take a couple of steps back and re-read the documentation. 

    Thanks to everyone for their assistance!

    Steve

    • Marked as answer by stevetarzon Friday, April 29, 2011 1:57 PM
    Friday, April 29, 2011 1:57 PM