locked
Remove attribute from SQL Server MA? RRS feed

  • Question

  • I am using ILM 2007, version 3.3.1139.2, connecting to SQL Server 2005.

    I am trying to remove an attribute from an existing SQL Server MA.  First I removed the attribute flows.  Then I removed the attribute from the SQL Server table.  But when I attempt to Refresh Schema, ILM complains that it can't find the deleted attribute in the schema.

    How can I delete an attribute?

    Thanks, Greg

    Tuesday, June 22, 2010 8:14 PM

Answers

  • Apparently it is easy to do.  You do receive the huge warning message, which sends you back to the MA Properties wizard.  It basically is forcing you to "correct" the errors, which means just checking everything within the properties and clicking OK.
    • Marked as answer by Greg2442 Thursday, July 8, 2010 8:23 PM
    Thursday, July 8, 2010 8:23 PM

All replies

  • What's the error message you get, exactly?

    Are you connecting to a table directly or a view?
    Are you using multivalue-tables or delta-views?

    Kind regards,
    Peter


    Peter Geelen - Sr. Consultant IDA (http://www.fim2010.be)

    [If a post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of that post. By marking a post as Answered or Helpful, you help others find the answer faster.]
    Tuesday, June 22, 2010 9:20 PM
  • Validating object type inclusion ...
    Validating object type inclusion completed successfully
    Validating attribute inclusion ...
    Error validating attribute inclusion:
    The Attribute 'thisismyattribute' could not be located in the schema.

    Then I'm forced into the MA properties dialog/wizard to "fix" the problem.

    I'm using the table directly, nothing multi-valued, and I do use a delta table.

    Tuesday, June 22, 2010 9:27 PM
  • I've experienced exactly the same error with a writeable view.
    The complete message is like : "
    Retrieving the management agent data ...
    Retrieving the management agent data complete
    Retrieving the new schema ...
    Retrieving the new schema complete
    Comparing new and old schema ...
    The schemas are different
    Retrieving the metaverse data ...
    Retrieving the metaverse data complete
    Validating object type inclusion ...
    Validating object type inclusion completed successfully
    Validating attribute inclusion ...
    Error validating attribute inclusion:
    The Attribute 'DeletedAttribute' could not be located in the schema.
    Validating validating stay disconnector rules ...
    Validating stay disconnector rules completed successfully
    Validating join and project rules ...
    Validating join and project rules completed successfully
    Validating attribute flow rules ...
    Validating attribute flow rules completed successfully
    Validating deprovisioning rules ...
    Validating deprovisioning rules completed successfully
    Validating extension settings ...
    Validating extension settings completed successfully
    Calling the management agent's custom refresh schema validator...
    The management agent's validator completed successfully.
    The new schema is incompatible with the current rules
    Please correct the rules using the new schema

    Closing the dialog will bring up the propertypages with the new schema.
    Please make the appropriate changes to the rules at which time the new schema can be saved to the server.
    "

    The MA did not allow to delete the attribute from the GUI.
    I was able to solve it by duplicating the view (with attribute removed) in SQL, saving it with a different name, then connecting the MA to it.
    After saving the MA configuration, reopened it and switched back to the old view (with attribute removed), and then removed the duplicated view.

    Kind regards,
    Peter


    Peter Geelen - Sr. Consultant IDA (http://www.fim2010.be)

    [If a post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of that post. By marking a post as Answered or Helpful, you help others find the answer faster.]
    Tuesday, June 22, 2010 10:17 PM
  • Can you create a temporary view (with the same fields as the orginal table, except for the deleted fields)?
    Then change the MA config to this temporary view and then switch back the config?
    Just change the config and switch back, without running the schema update or any run profile.

    If that doesn't work: alternatively, you could try to duplicate the table (+ delta table/view). 

    HTH,
    Peter


    Peter Geelen - Sr. Consultant IDA (http://www.fim2010.be)

    [If a post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of that post. By marking a post as Answered or Helpful, you help others find the answer faster.]
    Tuesday, June 22, 2010 10:20 PM
  • I'll try these options.

    But, as a general question, is it always this difficult to remove an attribute from a SQL Server MA? 

    Wednesday, June 23, 2010 2:46 AM
  • Is that a rhetorical question?
    I'll leave it to MS to confirm if it's a built-in feature.

    AFAIK, the schema update for the SQL MA works fine (updates, add attributes).
    I've come across the situation just once, using views...

    HTH,
    Peter


    Peter Geelen - Sr. Consultant IDA (http://www.fim2010.be)

    [If a post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of that post. By marking a post as Answered or Helpful, you help others find the answer faster.]
    Wednesday, June 30, 2010 9:30 PM
  • Apparently it is easy to do.  You do receive the huge warning message, which sends you back to the MA Properties wizard.  It basically is forcing you to "correct" the errors, which means just checking everything within the properties and clicking OK.
    • Marked as answer by Greg2442 Thursday, July 8, 2010 8:23 PM
    Thursday, July 8, 2010 8:23 PM