InstallationError 32000: in SetupWarehouse.exe (Team Foundation App-Data Tier Beta 2 Setup)
Hello All,
After a lot of installation problems installing Foundation Server I cleaned the Windows 2003 Server Standard Edition and started, allmost desparate, all over again.
I checked everything and even started reading the installationmanual.
I checked the User (TFSSETUP and TFSSERVICE are local Administrators) and all the services (Analysis Server, Report Server, SQL Server, SQL Server Agentand Sharepoint) and started the installation
Eveything seemed to be fine for a while. Then, almost at the end of the installation, the following Exception occurred:
Message on the Screen:
Error 32000. The commandline "C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\bisdwserver\bin\SetupWarehouse.exe" -n -s "SERVERNAME" -d BisDWDB -c "C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\bisdwserver\bin\Consolodated.xml" -a "DOMAIN\TFSSERVICE" -v -l "..local..\Temp\SetupWarehouse.log"" returned non-zro value: 3.
Contents of the Log:
Microsoft.AnalysisServices.OperationException: File system error: The following error occurred during a file operation: . (\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\BisDWDB.0.db\Person.0.dim.xml).
Internal error: An unexpected error occurred (file 'pctransaction.cpp', line 211, function 'PCTransaction::Rollback').
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update()
at Microsoft.VisualStudio.Bis.Warehouse.MetaData.OlapCreator.CreateDimensions(Database database, DataSourceView dataSourceView)
at Microsoft.VisualStudio.Bis.Warehouse.MetaData.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount)
at Microsoft.VisualStudio.Bis.Tools.WarehouseSetup.SetupWarehouse()
Please help me
Peter Cox
New-Way Automation bv.
From the command you can see that there is a logfile created, can you tell me what the error is reported in the logfile?
It can be found in the location : "..local..\Temp\SetupWarehouse.log"
you can find the file by running the command %temp% and then look for the setupWarehouse.log file.
If it tels you that there is no user mapping between .... you can try to run the command again after deleting the directory : c:\program files\Microsoft SQL Server\MSSQL.2\OLAP\Data
That helped for me. Se the other threads on this same toppics for additional help:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=11686
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=12655
Hi Marcel,
Nice to see that you responded on my post. (I attended your Team System course at InfoSupport).
The contents of the error in the log where also in the initial post.
I checked al lot of similar looking posts, including your posts.
None of them where the same. I tried some of the advised actions. None of them worked.
Contents of the Log:
Microsoft.AnalysisServices.OperationException: File system error: The following error occurred during a file operation: . (\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\BisDWDB.0.db\Person.0.dim.xml).
Internal error: An unexpected error occurred (file 'pctransaction.cpp', line 211, function 'PCTransaction::Rollback').
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update()
at Microsoft.VisualStudio.Bis.Warehouse.MetaData.OlapCreator.CreateDimensions(Database database, DataSourceView dataSourceView)
at Microsoft.VisualStudio.Bis.Warehouse.MetaData.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount)
at Microsoft.VisualStudio.Bis.Tools.WarehouseSetup.SetupWarehouse()
Thanks in advance,
Peter Cox
New-Way Automation bv.
What version of SQL Server are you using?
I actually have this exact error, but I think my problem is more related to ADAM since I'm not running a PDC. My error message in the log file is:
If exists(select name from Sysdatabases where name='BisDWDB') begin exec ('alter database [BisDWDB] set read_only with rollback immediate') waitfor delay '000:0:15' exec ('drop database BisDWDB') end
create database [BisDWDB]
exec sp_grantlogin [SERVER1\TFSSERVICE]
System.Data.SqlClient.SqlException: Windows NT user or group 'SERVER1\TFSSERVICE' not found. Check the name again.This tells me it's trying to use the username of SERVER1\TFSSERVICE on my DATABASE1 machine, which of course won't work - but I'm not sure, without a domain, how to use ADAM to solve the problem, since I can't even connect to the ADAM service.
Must I install Active Directory on my Application tier machine before I install TS? What's the best configuration for this with only 2 hosting machines and no domain?
Hi Allen,
I am using the CTP version that should be used with Visual Studio Beta 2.
Peter
With Beta 2, you must install Team System in a domain.
Are you installing in a domain or workgroup? Beta 2 must be installed in a domain.
Hi Allen,
I am installing in a domain....
Peter
Peter,
I was trying to follow the thread, but not sure I have the 100% story here. Some questions/thoughts.
1. TFS Beta 2 requires that you run in a domain. And, that domain must be a W2K3 Active Directory. You can't get there with a W2K AD.
2. When you entered the account information you should make sure you provide <domain>\<account>. And check the final screen to make sure. We validate the user id & password (on the AT) to make sure they are valid. However, if you have a local machine account with the same name the API we use will on occassion resolve to the local machine AND you need to have the domain account
Hi Marc,
I am running TFS Beta 2 in a 2003 AD domain.
TFS Beta 2 is running in a single server installation with a <domain>\TFSSetup account.
Peter
I also have the similar error during execution of SetupWarehouse.exe, however my setupwarehouse.log reads ...
Microsoft.AnalysisServices.OperationException: Errors in the encryption library: Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change.
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.MajorObject.Update()
at Microsoft.VisualStudio.Bis.Warehouse.MetaData.OlapCreator.SetupAnalysisDatabase(Server server, String analysisDBName)
at Microsoft.VisualStudio.Bis.Warehouse.MetaData.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount)
at Microsoft.VisualStudio.Bis.Tools.WarehouseSetup.SetupWarehouse()
I am performing Single-Server installation of TFS Beta with SQL Server 2005 CTP (April Version) on 2003 AD Domain - the same configuration as Peter I believe - all though I am using a single account for setup and service: TFSService.
I was also sure to supply the fully qualified user account with domain name during install.
Any help would be much appreciated.
But, I have problem like this too. Windows 2003 RUS SP1, native 2003AD on another server.
From log :
Started creation of OLAP.
Microsoft.AnalysisServices.OperationException: The following system error occurred: Invalid procedure call or argument.
Errors in the metadata manager. An error occurred while getting the value of the 'ConfigurationSettings\FileStore\PercentScanPerPrice' configuration property.
at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.VisualStudio.Bis.Warehouse.MetaData.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount)
at Microsoft.VisualStudio.Bis.Tools.WarehouseSetup.SetupWarehouse()
Please, help me too
