Visio Services data refresh failed - Events 8037 8038 8063 8062 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010 Enterprise

Alert Name:   Visio Services data refresh failed

Event ID:  8037, 8038, 8062, and 8063

Summary:   Users can connect published Microsoft Visio diagrams to external data sources, such as Excel Services in Microsoft SharePoint Server 2010. This error might occur because the schema of the data in a file changes in such a way that the expected primary key is invalid.

Symptoms:   One or more of the following symptoms might appear:

  • This event appears in the event log: Event ID: 8037 Description: Invalid data type found in Published File cache for file <FileName> Exception : <ExceptionCode>.

  • This event appears in the event log: Event ID: 8038 Description: Invalid data type found in Rendered File cache for file <FileName> Exception : <ExceptionCode>.

  • This event appears in the event log: Event ID: 8063 Description: Invalid data type found in ODC cache for file %1.

  • This event appears in the event log: Event ID: 8062 Description: Primary key column deleted.

Cause:   One or more of the following might be the cause:

  • A user might connect to an external data source, such as an Microsoft Excel workbook that no longer exists or is inaccessible.

  • A user might connect to an external data source whose primary key column is changed, and Visio Services in Microsoft SharePoint Server 2010 cannot update the external data in the Visio diagram.

  • A user might connect to a data source that is not a valid data provider type.