none
PowerShell script failed - System.Management.Automation.ActionPreferenceStopException - "Invalid column name"

    Question

  • Hi,

    we are running SCOM 2012 SP1 UR1.

    We have following error:

    The PowerShell script failed with below
    exception

    System.Management.Automation.ActionPreferenceStopException:
    Command execution stopped because the preference variable
    "ErrorActionPreference" or common parameter is set to Stop: Invalid column name
    'DomainName_688FBE34_B4B5_7C7C_AC4B_991BB45EE582'.
    Invalid column name
    'LongBackupPolicy_79BAABC7_FDC0_4479_323D_3C82378F1CD4'.
    Invalid column name
    'ProtectionType_0AB19B4B_E8BB_8285_B9A0_EC49103DB996'.
    Invalid column name
    'RecoveryPointCount_25F6848B_86B3_59DB_7A79_314F2E0C7E57'.
    Invalid column
    name 'RecoveryPointSize_3F89507E_C1F0_6FCC_106D_24EE283F570E'.
    Invalid column
    name 'RecoveryPointVolume_23D62E44_5CA4_7E31_71F6_735098FD8667'.
    Invalid
    column name 'ReplicaSize_EF861F39_B408_5C7C_84AE_7F933F91FBA6'.
    Invalid
    column name 'ReplicaVolume_84FF3D4A_7D56_FD8D_FE98_833A5DEAF253'.
    Invalid
    column name 'ShortBackupPolicy_9A4E720A_DC04_8A2B_DA0B_248F8E4CBEAB'.
    Invalid
    column name 'DataSourceType_DC804839_F4C4_0B12_3579_C0E407B9F093'.
    At line:65
    char:39
    + $objInstance = Get-SCOMClassInstance <<<< -Id
    $obj.Name
    at
    System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object
    input, Hashtable errorResults, Boolean enumerate)
    at
    System.Management.Automation.PipelineNode.Execute(Array input, Pipe outputPipe,
    ArrayList& resultList, ExecutionContext context)
    at
    System.Management.Automation.ParseTreeNode.Execute(Array input, Pipe outputPipe,
    ExecutionContext context)
    at
    System.Management.Automation.AssignmentStatementNode.Execute(Array input, Pipe
    outputPipe, ExecutionContext context)
    at
    System.Management.Automation.StatementListNode.ExecuteStatement(ParseTreeNode
    statement, Array input, Pipe outputPipe, ArrayList& resultList,
    ExecutionContext context)




    Script Name:
    GetMGAlertsCount.ps1


    One or more workflows were affected by this.



    Workflow name:
    ManagementGroupCollectionAlertsCountRule

    Instance name: All Management
    Servers Resource Pool

    Instance ID:
    {4932D8F0-C8E2-2F4B-288E-3ED98A340B9F}

    Management group: Production

    I hope somebody has an idea ?

    Thanks

    sebastian

    Tuesday, April 02, 2013 1:02 PM

Answers