index > Team Foundation Server - Reporting > Failed to load adapter

Failed to load adapter


Hi,
please help me, I permanently got the following message:

TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.

Technical Information (for the administrative staff):

Date (UTC): 5/5/2006 6:02:40 AM

Machine: TFSBETA3R

Application Domain: /LM/W3SVC/3/Root/Warehouse-3-127912825425748674

Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 3136

Thread Id: 392

Account name: PEXIMBG\tfsservice

Detailed Message: Failed to load adapter Microsoft.TeamFoundation.WorkItemTracking.Adapter.Adapter. Exception Info: \n Microsoft.AnalysisServices.ConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)

at System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP)

at System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port)

at Microsoft.AnalysisServices.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port)

at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

--- End of inner exception stack trace ---

at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)

at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)

at Microsoft.AnalysisServices.Server.Connect(String connectionString)

at Microsoft.TeamFoundation.Warehouse.OlapCreator.GetServerEdition()

at Microsoft.TeamFoundation.Warehouse.OlapCreator.CommonInit()

at Microsoft.TeamFoundation.Warehouse.OlapCreator..ctor(String serverName, String databaseName)

at Microsoft.TeamFoundation.Warehouse.AdapterWrapper..ctor(Type type, AdapterScheduler scheduler, String connectionString, String accessAccount, String dataReaderAccount, String analysisDbServer, String analysisDbName)

at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.Initialize

Thanks



janko

Hi Janko,

From the error it looks that when the Warehouse adapters try to run every hour they fail to connect to the Cube (Analysis Services). There could be several reasons why it fails to connect so can you pleas check the following:

- Is the "SQL Server Analysis Services" service running in the database server?

- If the firewall in the database server is turned ON, does it have an exception for the SQL port?

Thanks.

Federico

Federico Kolliker Frers - MSFT
Hi, Federico
T
janko

Hi Federico,

It happens something very strange.

After the actions, I did, the error message has appeared, after 12 hours.

Janko




Software configuration manager
janko
Hi janko, the adapters are kicked every 1 hour so if there was a login problem or something that was permanently blocking the adapter from connecting to the server then you will see these errors each hour. It seems to me that there are network issues between the Application Tier and the Data Tier machines and from time to time the adapters in the Application Tier won't be able to connect to the Data Tier. Are you aware of any latency or slow connection issues between these machines that may cause the adapters to timeout when trying to establish a connection?
Federico Kolliker Frers - MSFT

Thanks for Your support.

On the test TFS machine which is single server deployment, there is same error message for load failed adapter, and because I believe that there is no problem in communication between application and data tier

janko

Hi Janko, let's try to figure out if this is happening all the time in your system. You say you have a test TFS machine where this is happening so let's use that environment to try the following.

In the Application Tier machine:

1. Reset IIS.

2. Browse to http://localhost:8080/warehouse/v1.0/warehousecontroller.asmx. If the page is already open then just refresh it.

On step 2 above the adapters will be loaded by the controller and each one will be initialized. If at that point they fail to connect to the Analysis Services database then you will see an error (same one you described) for each of them (should be 5) in the event log.

You can repeat steps 1 and 2 several times and if each time you see the error for the adapters then it means that you are getting the error every time.

Please let me know the outcome and I can help you further.

Federico Kolliker Frers - MSFT

Federico,

I browsed to http://localhost:8080/warehouse/v1.0/warehousecontroller.asmx

janko
Were you ever able to solve the problem above? I am also getting the XML page cannot be displayed on one of my servers and have yet to find an answer.
Kriss

Hi Janko,

The error you are getting is unusual and it usually indicates that there is an issue in the setup of your environment. So let me ask you some questions:

- What version of the product are you running? From the name of your server it seems Beta 3 Refresh?

- Can you access the following page in your Application Tier http://localhost:8080/services/v1.0/ServerStatus.asmx?

- What user is running the Application Pool "TFS AppPool" in your Application Tier? Is that the same service account you used during setup?

- If you reset IIS and try to access again http://localhost:8080/warehouse/v1.0/warehousecontroller.asmx

Federico Kolliker Frers - MSFT
Janko and I resolved this issue offline. He was having an issue because he was hosting the cube in a named instance in Analysis Services 2000 and Team Foundation only supports Analysis Services 2005 and doesn't support named instances.
Federico Kolliker Frers - MSFT
reply 11

You can use google to search for other answers

 

More Articles

Where are the Models?
Errors when deploying to ReportServer
Log of TFS activities???
Can't find links between Work item and test in the TfsWarehouse
Reporting Services Hidden Lines
Recreate Reports
report stops showing data - warehouse not update
Source Control Reporting
How to prevent users from viewing other projects when creating qu...
Using Excel pivot charts, can I filter on creation dates within t...
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

An attempt has been made to use a data e…
What is the formal definition of Priorit…
Can not find any Perspective other than …
How to get "Current Week" in M…
Hoe to create an hyperlink column
custom views in TFSWarehouse
report stops showing data - warehouse no…
What's the difference between TfsReportD…
Recreate Reports
Can I customize the VSTS bug report?
Work Item Details Report
TFS Project & Report Server ERrors
TFS Reporting does not work due to wareh…
ReportProcessingException: The Language …
Unplanned work report incorrect

Hot Articles

error uploading reports
Merged Changesets Report
rsRenderingExtensionNotFound
Projects are missing in reporting server
Reporting completed work per person retu…
table pagination
Create Report Problems
Error 28806. Something is wrong with Re…
Using Excel pivot charts, can I filter o…
How can I create Dynamic Query between t…
How to validate parameters in the rdl it…
is there any where, where i can get how …
URL for the 50 standard TFS reports
Print reports without preview
Daily wise resource allocation in MS Pro…

Recommend Articles

Reporting Services Hidden Lines
Unable to access any of the reports.
Reporting Services Error
Reporting on Plain Text Fields in Work I…
How to debug the subscription function
How to prevent users from viewing other …
Problem accessing TFSwarehouse using OLA…
Turning a Work Item Query Into a Report
Another warehouse not updating :( - now …
Failed to load adapter
report designer don`t find all fields
Issues with dimension after following wa…
Create Report Problems
reports don't work in projects created w…
Edit reports from Agile process template?