I was receiving the error at the end of this post when running the ETL script for FIM Reporting.

SCSM was reporting that the Load.Common module was failing. When I opened the job, the LoadDWDataMartFIMAttributeTypeDim module was in the failed state.

I have no idea what caused it but the (most likely unsupported) fix was to back up the DWDataMart and DWRepository databases. Then, I truncated the dbo.FIMAttributeTypeDim tables in both databases. (I also truncated the dbo.FIMAttributeTypeDim_bulkstg table in the DWDataMart db, but that might not have been necessary.)

I ran the ETL script again and didn’t get an error.

Event Viewer error:

ETL Module Execution failed:

ETL process type: Load

Batch ID: 15444

Module name: LoadDWDataMartFIMAttributeTypeDim

Message: Cannot insert duplicate key row in object ‘dbo.FIMAttributeTypeDim’ with unique index ‘IX_FIMAttributeTypeDim_FIMAttributeTypeName’.

The statement has been terminated.

Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)