Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio Team System >> Team Foundation Server - Reporting & Warehouse

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

[3451 byte] By [janko] at [2008-2-15]
«« How to utilize Shortcut property RUN -> Minimized
»» Smartphone and scrollable dialogs
# 1

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

FedericoKollikerFrers-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 2
Hi, Federico
Thanks for Your post.

- Is the "SQL Server Analysis Services" service running in the database server?
>>SQL Server Analysis Services is already running
- If the firewall in the database server is turned ON, does it have an exception for the
SQL port?
>>Firewall in the database server is turned OFF
However, You gave me an idea about SQL Server Analysis Services, You mentioned.
I changed the owner of these services from local system to domain\tfsservice and I assigned
it sysadmin role in SQL management studio.
This procedure solved the problem, the error message didn't appear anymore.

Janko
janko at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 3

Hi Federico,

It happens something very strange.

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

Janko

janko at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 4
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?
FedericoKollikerFrers-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 5

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(they are on same machine).

Regards

janko at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 6

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.

FedericoKollikerFrers-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 7

Federico,

I browsed to http://localhost:8080/warehouse/v1.0/warehousecontroller.asmx and I got the following message:

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

Invalid at the top level of the document. Error processing resource 'http://tfsbeta3r:8080/warehouse/v1.0/warehousecontroll...

TF10216: Team Foundation services are currently unavailable. Try again later. If the problem persists, contact your Team Fou... 
janko at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 8
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 at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 9

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 can you please look in the event log in the Application Tier at that time and send me any "Tfs Warehouse" errors or warnings.

My e-mail at work is fedek@(noSpam)microsoft.com, please feel free to e-mail me and we can find the solution faster and then post it here.

Thanks.

Federico

FedericoKollikerFrers-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 10
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.
FedericoKollikerFrers-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
Visual Studio Team System
Team Foundation Server - Reporting & Warehouse

Visual Studio Team System Hot Topic

Visual Studio Team System New Topic

Visual Studio Team System

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified