Curse you Excel Services

I don’t know what happened. We’d always been such good friends. But one client, one install, the damned thing wouldn’t refresh from a list.
After Binging ( googling ) ULS’s for a while, I stumbled upon a very helpful flowchart Microsoft has put together. It helped. I didn’t get THE answer. But it helped.
It does make me think that there have been plenty of stuck pumpkins before me on this this one. MS doesn’t often provide a huge flowchat for troubleshooting. I wish there were more …

Microsofts SharePoint 2010 Excel Services Troubleshooting Flowchart

PS: These were my errors:
ConnectionManager.GetConnection: Failed to create new connection, exception=Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.CreateConnection(QueryType queryType, String connectionString, String userName, Boolean isTensor, Boolean integratedAuthentication, Int32 lcid, SecureString password, String workbookUrl, Int32 timeout) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId), sessionId=1.V21.26vhnMHWSZdyQqQNWeB… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services 6k4q Medium …dc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, connectionString=Provider=Microsoft.Office.List.OLEDB.2.0;Data Source=””;ApplicationName=Excel;Version=12.0.0.0 pool count=0 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64 w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services eq3m High ConnectionManager.GetConnection: Caught an exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.CreateConnection(QueryType queryType, String connectionString, String userName, Boolean isTensor, Boolean integratedAuthentication, Int32 lcid, SecureString password, String workbookUrl, Int32 timeout) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId) at Microsoft.Office.Excel.Server.CalculationServer.Con… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services eq3m High …nectionManager.CreateConnectionAndAddToList(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Boolean auditConnection, Int32 keyLcid, ConnectionInfo connectionInfo, ConnectionKey connectionKey, AutoReaderWriterLock autoPoolLock, Connection& connection, ConnectionList& connectionList) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.GetConnection(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Int64 privateConnectionId, Boolean auditConnection) 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64 w3wp.exe (0x08C0) 0x2434 Excel Services Application External Data 2051 Information Refresh failed for ‘Call Register Connection’ in the workbook ‘http://clientweb/reception/Documents/Book5.xlsx’. [Session: 1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N User: 0#.w|ad\user_id] 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64 w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services 3sls Medium ExternalSource.ValidateConnection: Unable to get a connection: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.Interop.EngineInterop.CreateConnection(QueryType queryType, String connectionString, String userName, Boolean isTensor, Boolean integratedAuthentication, Int32 lcid, SecureString password, String workbookUrl, Int32 timeout) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.CreateConnection(Credentials credentials, ConnectionInfo connectionInfo, Int32 keyLcid, Uri workbookUrl, Boolean auditConnection, SessionId sessionId) at Microsoft.Office.Excel.Server.CalculationS… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services 3sls Medium …erver.ConnectionManager.CreateConnectionAndAddToList(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Boolean auditConnection, Int32 keyLcid, ConnectionInfo connectionInfo, ConnectionKey connectionKey, AutoReaderWriterLock autoPoolLock, Connection& connection, ConnectionList& connectionList) at Microsoft.Office.Excel.Server.CalculationServer.ConnectionManager.GetConnection(ConnectionRequest connectionRequest, ExtendedConnectionInfo extendedConnInfo, Credentials credentials, Int64 privateConnectionId, Boolean auditConnection) at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.TryGetValidatedConnection(Request request, Credentials credentials, ExtendedConnectionInfo extendedConnectionInfo, Boolean shouldReportFailur… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.64* w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services 3sls Medium …e, Boolean auditConnection, Connection& connectionOut). sessionId=1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, externalSource=Call Register Connection 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services 482l Medium ConnectionInfoManager.InitConnInfoFromOdcFile: ODC File Uri is not valid: 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services 8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all available connection information. Exception: Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException: Exception of type ‘Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException’ was thrown. at Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request request, String externalSourceName, Int32 externalSourceIndex, Boolean& shouldReportFailure) at Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request request, ExternalSourceStateInfo externalSourceStateInfo, ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index, ConnectionInfoManager connectionInfoManager, ExternalDataScenario scenario, DataOperation dataOpe… 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66* w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services 8xk9 Medium …ration, Boolean verifyPreOperationConnection), Data Connection Name: Call Register Connection, SessionId: 1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, UserId: 0#.w|ad\user_id 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2434 Excel Services Application Excel Calculation Services eq3r Medium ConnectionRequest.ConnectionRequest: New connection request. SessionId=1.V21.26vhnMHWSZdyQqQNWeBdc90.5.en-US5.en-AU73.-0600#0000-04-00-01T03:00:00:0000#+0000#0000-10-00-01T02:00:00:0000#-006036.fab5481e-2082-4df1-af62-af0f9a6e7ea31.N, WorkbookVersion=ConnectionInfo.WorkbookVersion: Uri=http://clientweb/reception/Documents/Book5.xlsx, Version=Friday, 22 February 2013 05:22:54 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 SharePoint Server Logging Correlation Data xmnv Medium Name=Job: CreateUserWorkbook 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 SharePoint Server Logging Correlation Data xmnv Medium Document=http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services 4n14 Medium UserWorkbook.CreateWorkbookJob: Starting to create a UserWorkbook for BaseWorkbook http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services aizn Medium UserWorkbook.CreateFromPreviousWorkbookAsync: previous workbook is available, no re-loading was needed 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.66 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services f1va Medium CWorkbookWrapper::CWorkbookWrapper: Created with ID=2 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services aysl Medium Succeeded to initialize a chart. 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x2B10 Excel Services Application Excel Calculation Services 4n15 Medium UserWorkbook.CreateWorkbookJobCallback: Successfully created a UserWorkbook for BaseWorkbook http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x1F3C SharePoint Server Logging Correlation Data xmnv Medium Document=http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.68 w3wp.exe (0x08C0) 0x1F3C Excel Services Application Excel Calculation Services hly6 Medium OpenWorkbookOperation.OpenWorkbookComplete: CloseUri /reception/Documents, ClientUri http://clientweb/reception/Documents/Book5.xlsx 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.69 w3wp.exe (0x08C0) 0x1F3C SharePoint Server Logging Correlation Data xmnv Medium Result=Success 353ca798-d961-4c0e-ac93-368cd5f983d9
02/25/2013 13:43:50.69 w3wp.exe (0x08C0) 0x1F3C Excel Services Application Excel Calculation Services 7921 Information