If you can't see any assigned to you have a problem with your data warehouse. Check the data warehouse mangement servers operations manager log. And check all the data warehouse jobs and see that they are not in failed status. 

Hello,

I've checked and find that for the incidents that are into dwh db I can't see
some fields for example:
- Assigned user and
- IT service name,
but these fields are filled in for that incidents that are in SM operational DB. May be it's by design or smth wrong with my DWH?
My reporting doesn't work because of these fields are empty in dwh db.

• Edited by abdulax Sunday, February 22, 2015 6:11 AM

I've checked and and I see such warnings ID 33503:

An error countered while attempting to execute ETL Module:
ETL process type: Load
Batch ID: 362503
Module name: LoadOMDWDataMartActionType
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

An error countered while attempting to execute ETL Module:
ETL process type: Load
Batch ID: 362502
Module name: LoadCMDWDataMartConfigItemObjectStatus
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

An error countered while attempting to execute ETL Module:
ETL process type: Extract
Batch ID: 362529
Module name: Extract_Microsoft.SystemCenter.SiteMembership_DW_PtBank
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

And one Error ID 33502:

ETL Module Execution failed:
ETL process type: Transform
Batch ID: 362519
Module name: TransformEntityDim
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

• Edited by abdulax 18 hours 52 minutes ago

Also I have such error:

ETL Module Execution failed:
ETL process type: Transform
Batch ID: 331359
Module name: TransformConfigItemGroupContainsEntitiesFact

Message: ErrorNumber="50000" Message="Unable to acquire applock - another instance of the module must already be running." Severity="18" State="1" ProcedureName="InitializeTransform" LineNumber="52" Task="(null)"

From the errors you have posted confirms that you have data warehouse problem. There is quite a few blog posts about data warehouse troubleshooting. 

You should now that troubleshooting data warehouse is a living hell and most of the time it's hard to fix the problem. If you have the possibility to reinstall the data warehouse i recommend using this. 

But if the data retention settings are set so some data only exists in the data warehouse you have to do the troubleshoting. 

http://blogs.technet.com/b/servicemanager/archive/2014/12/01/service-manager-data-warehouse-troubleshooting.aspx

I've checked and and I see such warnings ID 33503:

An error countered while attempting to execute ETL Module:
ETL process type: Load
Batch ID: 362503
Module name: LoadOMDWDataMartActionType
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

An error countered while attempting to execute ETL Module:
ETL process type: Load
Batch ID: 362502
Module name: LoadCMDWDataMartConfigItemObjectStatus
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

An error countered while attempting to execute ETL Module:
ETL process type: Extract
Batch ID: 362529
Module name: Extract_Microsoft.SystemCenter.SiteMembership_DW_PtBank
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

And one Error ID 33502:

ETL Module Execution failed:
ETL process type: Transform
Batch ID: 362519
Module name: TransformEntityDim
Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

• Edited by abdulax Sunday, February 22, 2015 4:47 PM

I'm running a custom query. But I see these relationships for that incidents that are into SM operational DB.

• Edited by abdulax 21 hours 16 minutes ago

I'm running a custom query. But I see these relationships for that incidents that are into SM operational DB.

• Edited by abdulax Thursday, February 26, 2015 2:22 PM

And i have the same problem for the built in report - List of incident. The field Assigned To is empty, all other fields are filled in.

This check box in report is resolved this problem

• Edited by abdulax 22 hours 11 minutes ago
• Marked as answer by abdulax 22 hours 11 minutes ago

This check box in report is resolved this problem

• Edited by abdulax Friday, March 13, 2015 9:01 AM
• Marked as answer by abdulax Friday, March 13, 2015 9:01 AM