The “System.FormatException” error is encountered when documenting a specific database

Applies to
ApexSQL Doc

Summary
This article discusses how to solve the “System.FormatException” error that is encountered when documenting a database

Symptoms
The “System.FormatException” error can be encountered when documenting specific databases

Exceptions
Top Level Exception
Type: System.FormatException
Message: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
Source: mscorlib

Resolution
The possible workarounds are:

  1. Replace ‘.’ in the Add SQL Server dialog with the real server name or "(local)" (e.g. “.SQL2005” change to "(local)SQL2005")
  2. If you tried to document several databases simultaneously, try to document them one by one
  3. Document your database with the Explicitly parse database option turned Off
  4. Change the regional settings of your machine to English

About ApexSQL Doc
documents SQL Servers, databases, objects, and SSIS packages in a single document. Create database documentation in a variety of formats including compiled help (*.CHM), HTML and MS Word. Schedule your documentation process unattended with the help of the CLI.

Last updated
April 7, 2013

Related posts:

  1. The “System.IO.PathTooLongException” error
  2. The “This program cannot display the webpage” error is encountered when generated CHM documents are copied to a network drive
  3. The ‘Runtime Error (at -1:0): Cannot import dll:<utf8>%AppData%\Local\VCLStylesSkin\VclStylesIno.dll.’ error is encountered when uninstalling application
  4. The synchronization script is generated with errors when synchronizing a specific database with an empty database as a destination
  5. A “Error 404” error is encountered when linking a database to Team Foundation Server in a different domain from the host