none
FIM 2010 R2 Oracle Updatable View RRS feed

  • Question

  • Hi,

    Recently i created a Management Agent for Oracle, this MA used an Updatable View, when i run a FI all works fine but when i run an export the MA throws an error, the error is:

    Oracle ROW-00009: Cannot update row  Ora-ORA-01446

    I have doubt if FIM 2010 R2 supports Oracle updatable views or not?.

    I tested with SQL Server and works fine using an updatable view.

    Regards.


    MCP-ASP.NET With C#, MCTS SQLServer 2005 I&M

    Tuesday, June 9, 2015 11:05 PM

Answers

  • Well, Materialized (or updatable) Views are supported. I have done that in the past

    Nosh Mernacaj, Identity Management Specialist

    Wednesday, June 10, 2015 4:33 PM

All replies

  • I assume you Oracle MA Account has the right access?

    Nosh Mernacaj, Identity Management Specialist

    Wednesday, June 10, 2015 3:14 PM
  • Hi Nosh,

    Yes the rights are correct, i tested from PLSQL Developer and the update works.

    Regards.


    MCP-ASP.NET With C#, MCTS SQLServer 2005 I&M

    Wednesday, June 10, 2015 4:31 PM
  • Well, Materialized (or updatable) Views are supported. I have done that in the past

    Nosh Mernacaj, Identity Management Specialist

    Wednesday, June 10, 2015 4:33 PM
  • Could you try to run an update directly using SQLPLUS?

    Maybe you have a simple data issue.


    Nosh Mernacaj, Identity Management Specialist

    Wednesday, June 10, 2015 4:35 PM