Knowledge Base

Index was outside the bounds of the array error during registration

Category: Troubleshooting & error messages
Date: 13 Jul 2009
Product: SQL Backup
Versions: 5,6

When registering a new SQL Server into the SQL Backup console, the following error message may appear:
IndexOutOfRangeException
Index was outside the bounds of the array.
   at System.Globalization.DateTimeFormatInfo.InsertHash(TokenHashValue[] hashTable, String str, TokenType tokenType, Int32 tokenValue)
   at System.Globalization.DateTimeFormatInfo.CreateTokenHashTable()
   at System.Globalization.DateTimeFormatInfo.Tokenize(TokenType TokenMask, TokenType& tokenType, Int32& tokenValue, __DTString& str)
...

The cause of this error could be invalid regional settings on the computer which is running the SQL Backup console. SQL Backup is attempting to convert the date and time at the server to an internal format used by the Microsoft .NET Framework, and this conversion process may fail if the date and time separators are incorrect. To fix this problem, check your Windows regional settings.

For example, in Windows XP, open the Control Panel, then the Date, Time, Language, and Regional options. Next, select 'Change the format of numbers, dates, and times', and click the 'customize' button. On the 'Time' tab, ensure that the time separator is a colon (:), a time format, and AM and PM symbols are not blank. Click the 'Date' tab and ensure that there is a short date format and a Date separator selected.

If the regional settings are correct, SQL Backup should be able to correctly parse the date and time returned by the SQL Server.