locked
MIM Agent 'Export' fails. Error 'Stopped-Server' RRS feed

  • Question

  • Hi Guys, anyone faced similar issue? need help !

    Full Import, Full Sync worked fine on MIM Agent. Export fails. Any help would be appreciated.

    Error :

    ERROR on MIM Server:

    .Net SqlClient Data Provider: System.Data.SqlClient.SqlException (0x80131904): Reraised Error 1088, Level 16, State 7, Procedure ReseedExportMessage, Line 19, Message: Cannot find the object "ExportMessage" because it does not exi
    st or you do not have permissions.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.ResourceManagement.Data.Sync.InitiateExport(Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.Export.ExportSession.DoOpen()
    at MIIS.ManagementAgent.Export.ExportSession.ExportSessionStateBase.DoOpen()
    at MIIS.ManagementAgent.Export.ExportSessionFactory.CreateExportSession()
    at MIIS.ManagementAgent.RavenMA.DoOpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.State.SynchronizationStateMachine.DoOpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.State.Export.ExportStateMachine.DoOpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.State.Export.InitialState.OpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.State.Export.ExportStateMachine.OpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.State.SynchronizationStateMachine.OpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.State.InitializedState.OpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.State.SynchronizationStateMachine.OpenDataSourceForExport(String stepData, Guid exportSessionIdentifier)
    at MIIS.ManagementAgent.RavenMA.OpenDataSourceForExport(String pszStepData, Guid guidExportSession)
    ClientConnectionId:f1dcef9e-b442-4f45-9a48-fa436dd71390
    Error Number:50000,State:1,Class:16


    ranzaan.m


    • Edited by ranzaan Thursday, June 16, 2016 10:43 AM
    Thursday, June 16, 2016 10:42 AM

All replies

  • Hi

    The MIMMA uses SQL query to import and the webservice to export.

    Test if the webservice is active and check the password on the MIMMA account.

    When you enter the password in MIMMA you will see requests to delete and create all MA in the portal, if not the webservice is not working as it supsed to. 

    Monday, June 20, 2016 9:12 AM
  • If the user FIMServiceTruncateUser don't have the right permissions you will get this message.

    try to run this on the database FIMService

    GRANT ALTER on [sync].[DeltaImportLog] to [FIMServiceTruncateUser]

    GRANT ALTER on [sync].[DeltaImportWatermark] to [FIMServiceTruncateUser]

    GRANT ALTER on [sync].[ExportItem] to [FIMServiceTruncateUser]

    GRANT ALTER on [sync].[ExportMessage] to [FIMServiceTruncateUser]

    Friday, October 16, 2020 2:31 PM