Donovan Brown

Technology Blog

I exceeded the maximum size for upload in SharePoint

10 April 2013 Donovan-Brown Work (0)
Problem: I get a size limit error when I try to upload a document to SharePoint. Solution: By default the maximum size is set to 50 MB. We simply need to increase the acceptable file size. Explanation: In Central Administration, in Application Management, click Manage web applications. Select the application (for example, SharePoint - 80). On the Web Applications ribbon, click the down arrow on the General Settings button. Click General Settings. Scroll to Maximum Upload Size. Set the property to the same number as the Maximum Workbook Size in Excel Services. Click OK.

Web application causes An attempt was made to load a program with an incorrect format error.

23 March 2013 Donovan-Brown Work (0)
Problem: When I attempt to start my asp.net web application running in IIS 8 I receive the following error: Could not load file or assembly 'Xxx' or one of its dependencies. An attempt was made to load a program with an incorrect format. Solution: Enable 32-Bit Applications for the Application Pool running your application. Explanation: Start IIS and select your web applications virtual directory under Sites\Default Web Site. Select Basic Settings from the Actions pane.  Note the Application pool your application is using and click Cancel to close the dialog.  Select Application Pools from the Connections pane.  Right click on the application pool running your web application and select Advanced Settings from the context menu.  Change Enable 32-bit Applications from False to True.

How to connect Office 2003 to TFS 2012

20 March 2013 Donovan-Brown Work (0)
Problem: Team Explorer 2012 does not integrate with Office 2003. Solution: Install Team Explorer 2008, Visual Studio 2008 SP1 and 2008 Compatibility Update. Explanation: This procedure will also work to get Visual Studio 2008 connected to TFS 2012. If you open Excel 2003 after installing Team Explorer 2012 you may get an error when you exit Excel. Just click Close the program. The next time start Excel you will be presented the following error: Click Yes to disable the 2012 version of the ‘team foundation add-in’ and close Excel. Now you will have to execute a few commands from an elevated command prompt. From an admin command prompt, change directories to “Program Files\Microsoft Visual Studio 9\Common7\IDE\PrivateAssemblies” or “Program Files (x86)\Microsoft Visual Studio 9\Common7\IDE\PrivateAssemblies” on a 64 bit machine. To register the 2008 version of the add-in run the following command and press Enter: regsvr32 TFSOfficeAdd-in.dll Now when you open Excel you will see a new Team menu.

I get an error trying to run reports on TFS2012 install

19 March 2013 Donovan-Brown Work (0)
Problem: I get the following error when I attempt to view reports: An error has occurred during report processing. (rsProcessingAborted)Cannot impersonate user for data source 'TfsReportDS'. (rsErrorImpersonatingUser)Log on failed. Ensure the user name and password are correct. (rsLogonFailed)For more information about this error navigate to the report server on the local server machine, or enable remote errors  Solution: Verify that the password for the account reporting services is using has not expired. Explanation: In your browser, navigate to http://localhost/reports (from your reporting server machine).Click on Tfs2010ReportDS on the home page. Under the 'Credentials stored securely in the report server' click the Test Connection button. You should see the following message "Log on failed. Ensure the user name and password are correct."Simply reenter the username and password information and test the connection again.

Cannot register assembly during Team Build (and I don't want too)

06 February 2013 Donovan-Brown Work (0)
Problem: I have a solution that contains a project with the "Make assembly COM-Visible" checked and I get the following error when I attempt to run a team build: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Microsoft.Common.targets (3885): Cannot register assembly "C:\Builds\1\TeamProject\Libraries - CI\bin\Debug\Mydll.dll" - access denied. Please make sure you're running the application as administrator. Access to the registry key 'HKEY_CLASSES_ROOT\Mydll' is denied. Solution: Pass "/p:RegisterForComInterop=false" to MSBuild using the MSBuild Arguments process parameter of your build definition. Explanation: The service account running my build agent is not an adminstrator on my build.  Therefore; it does not have permissions to write to the registry to register the COM assembly.  Because this is my build machine I have no desire to have the COM assembly registered on this machine. I simply what the solution to build. When the "Make assembly COM-Visible" is checked the project file is changed to include a target to register the assembly. That target has a condition testing if RegisterForComInterop is true.  By passing the values to MSBuild you are overriding the default value of True with False.  This will allow the project to compile and skip the step to register.

I don't trust 2012 Auto merge but it does it automatically.

31 January 2013 Donovan-Brown Work (0)
Problem: I would like a chance to review the changes before having Visual Studio 2012 automerge my files. Solution: Disable the "Attempt to automatically resolve conflicts when they are generated. Explanation: When Visual Studio 2012 is installed it defaults with this option set. If you uncheck this box Visual Studio behaves as it did in the 2010 version.  You are presented the Conflict Resolution window with options to AutoMerge, Merge Changes In Merge Tool, Take Server Version or Keep Local Version.

How do I convert a Web Site to a Web Application

30 January 2013 Donovan-Brown Work (0)
Problem: We created our application using the Web Site project template and would like to change to a Web Application. Solution: http://msdn.microsoft.com/en-us/library/aa983476(v=vs.100).aspx Explanation: Just don't use Web Sites! Why would I want my source code (all of my IP) on a server that could be compromised? They also do not play nice with source control systrems or automated build.

I want xml transforms to happen on build instead of only publish.

11 January 2013 Donovan-Brown Work (0)
Problem: I have xml transforms I want to preform on build not only on publish. I also want an easy way to transform my config files during my team build.  Finally I want to use it on app.configs in WPF applications as well. Solution: Use SlowCheetah XML Transforms package.  You can install it from the Extension Manager in Visual Studio.  Explanation: SlowCheetah enables you to transform your app.config or any other XML file based on the build configuration. It also adds additional tooling to help you create XML transforms.  http://visualstudiogallery.msdn.microsoft.com/69023d00-a4f9-4a34-a6cd-7e854ba318b5  

I have to create the same branches in every new team project

17 December 2012 Donovan-Brown Work (0)
Problem: I have to create the same branching structure in several team projects.  I would like a way to automate this process. Solution: Use the tf.exe and tfpt.exe command line tools in a batch file. Explanation: Using the tf.exe and tfpt.exe command line tools you can preform the same task from the command line that you can preform in the IDE.  Using tf.exe and tfpt.exe we can script the creation of the desired branching structure to speed up the process. You can download the Microsoft Visual Studio Team Foundation Server 2012 Update 1 Power Tools from here. The script below creates the Basic Branch Plan from the Visual Studio Team Foundation Server Branching and Merging Guide which you can download from here. The script must by run from a Developer Command Prompt so that tf.exe and tfpt.exe can be found.  Your other option is to update the environment variables for you machine to include the location of tf.exe and tfpt.exe in your path. @ECHO OFF REM If they did not provide arguments show them how to REM use this batch file if "%1" == "" GOTO Usage if "%2" == "" GOTO Usage REM Create a temp workspace to create the branches in. REM This will be deleted at the end tf workspace /new /noprompt temp /collection:%1 REM Before you can create branches you must do a get latest tf get $/%2 REM Create a main folder that will become the main branch of code md %2\Main REM Add this folder to TFS tf add %2\Main /noprompt REM Check in the main folder tf checkin /comment:"Adding main branch" /recursive /noprompt REM Now start creating the other branches REM main to dev tf branch $/%2/Main $/%2/Dev /noget /checkin REM main to release tf branch $/%2/Main $/%2/Release /noget /checkin REM We have to use tfpt from the power tools to convert REM the folder to a branch so we get the new branch icons REM in source control explorer tfpt branches /convertToBranch /collection:%1 /recursive $/%2/Main Echo Deleting temp workspace Echo. tf workspace /delete /noprompt temp REM Remove the directories we created rd %2 /s /q REM Skip usage and just end GOTO End REM Show how to use the script :Usage Echo This batch file will create the default Main, Dev and Release branches Echo for a team project. Echo Requires: Echo Microsoft Visual Studio Team Foundation Server 2012 Update 1 Power Tools Echo. Echo Usage: Echo createBraches collection teamProjectName Echo. Echo collection = http://tfs:8080/tfs/myCollection Echo teamProjectName = the team project name in that collection Echo. Echo createBranches http://tfs:8080/tfs/sandboxcollection teamProjectName :End createBranches.cmd (1.67 kb)