0

I am trying to configure Team Foundation Server 2018 with SQL Server but I am getting an error at readiness check validation

TF255407: An error occurred while attempting to validate the configuration database. Error message: Data is Null. This method or property cannot be called on Null values.

I already have TFS setup running on one of the server which is currently live and its working fine. I want to setup one more server to test the backup of TFS data, so for that I have installed same version of TFS i.e. 2018 and SQL Server 2016. Below are all the activities which I have performed.

Running TFS Instance Details.

  1. TFS Version: 2018
  2. SQL Server: 2016 SP1
  3. OS: Windows server 2019
  4. TFS DB's:
  • Tfs_Configuration: 1.5 GB
  • Tfs_Projects: 48 GB
  • Tfs_Products: 24 GB
  • Tfs_AppDevelopment: 29 GB
  • Tfs_Migration: 7 GB

New Server Details.

  1. TFS Version: 2018
  2. SQL Server: 2016 SP1
  3. OS: Windows server 2016

All above db backups I have restored on new server. Installed TFS 2018 and when trying to configure I am selecting existing deployment.

I have installed same version of TFS i.e. 2018 and SQL server 2016.

Log File: Scanning for Team Project Collection databases. Configuration database instance stamp is 004d197e-60de-4300-b4fb-7c325c9358da Exception Message: Data is Null. This method or property cannot be called on Null values. (type SqlNullValueException) Exception Stack Trace: at System.Data.SqlClient.SqlBuffer.get_String() at Microsoft.TeamFoundation.Framework.Server.SqlConnectionBootstrapBinder.Bind() at Microsoft.TeamFoundation.Framework.Server.ObjectBinder1.ObjectEnumerator.MoveNext() at Microsoft.TeamFoundation.Framework.Server.ObjectBinder1.ObjectEnumerator.get_Items()

Imran Shaikh
  • 1
  • 1
  • 2
  • This post of your has more information: https://learn.microsoft.com/en-us/answers/questions/1352911/team-foundation-server-2018-data-is-null. Have you tried looking at the log file? Did you find any additional details there? – Alex Aug 28 '23 at 01:18
  • Not getting any solution, – Imran Shaikh Aug 28 '23 at 08:18
  • Scanning for Team Project Collection databases. Configuration database instance stamp is 004d197e-60de-4300-b4fb-7c325c9358da Exception Message: Data is Null. This method or property cannot be called on Null values. (type SqlNullValueException) Exception Stack Trace: at System.Data.SqlClient.SqlBuffer.get_String() at Microsoft.TeamFoundation.Framework.Server.SqlConnectionBootstrapBinder.Bind() at Microsoft.TeamFoundation.Framework.Server.ObjectBinder`1.ObjectEnumerator.MoveNext() at Microsoft.TeamFoundation.Framework.Server.ObjectBinder`1.ObjectEnumerator.get_Items() – Imran Shaikh Aug 28 '23 at 08:34
  • How did you backup TFS databases? Did you use the TFS backup tool or backed up databases individually? – Alex Aug 30 '23 at 02:45
  • I tried both the ways, TFS tool and standard SQL backup. Database is getting restored properly no errors but throws error when i am configuring TFS. – Imran Shaikh Aug 31 '23 at 06:11
  • You should use TFS tool to get consistent backup across DBs – Alex Sep 01 '23 at 21:30

0 Answers0