none
Unable to create criteria based set RRS feed

  • General discussion

  • Hi

    Am able to create manual mebership set

    But unable to create criteria based

    Error while submitting :Error processing your request: The server was unwilling to perform the requested operation.
    Reason: Unspecified.
    Attributes:
    Correlation Id: dea87d5e-b9b6-4e45-9bc9-0d22f528de70
    Request Id:
    Details: Request could not be dispatched.

    Event

    Log Name:      Forefront Identity Manager
    Source:        Microsoft.ResourceManagement
    Date:          11/8/2012 9:53:40 AM
    Event ID:      3
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      FIM

    Description:
    Reraised Error 50000, Level 14, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 50000, Level 14, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 229, Level 14, State 5, Procedure sp_executesql, Line 1, Message: The EXECUTE permission was denied on the object 'sp_executesql', database 'mssqlsystemresource', schema 'sys'.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft.ResourceManagement" />
        <EventID Qualifiers="0">3</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2012-11-08T04:23:40.000000000Z" />
        <EventRecordID>243</EventRecordID>
        <Channel>Forefront Identity Manager</Channel>
        <Computer>FIM</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Reraised Error 50000, Level 14, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 50000, Level 14, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 229, Level 14, State 5, Procedure sp_executesql, Line 1, Message: The EXECUTE permission was denied on the object 'sp_executesql', database 'mssqlsystemresource', schema 'sys'.</Data>
      </EventData>
    </Event>

    Thursday, November 8, 2012 4:30 AM

All replies

  • Seems a permission issue but that is strange, can you verify that your account and the service account indeed have this permission?

    Need realtime FIM synchronization and advanced reporting? check out the new http://www.imsequencer.com that supports FIM 2010, Omada Identity Manager, SQL, File, AD or Powershell real time synchronization!

    Thursday, November 8, 2012 10:49 AM
  • What is the criteria you are trying to set?

    The error suggest you are trying to do something for which you do not have persmissions or which violates a database constrain or something like that.

    Thursday, November 8, 2012 6:58 PM
  • yes all are right , it was a permisison issue fimservice was not having master access on SQL Db

    Can anyone please share the specific permissions required for FIM service accounts?

    Wednesday, November 14, 2012 11:26 AM