When performing a search in an Archive Manager (AM) implementation on a non-English OS the following result may be obtained:
Sorry, no results were found that match your search criteria.
Also in the Application event log of the AM server an error similar to the one below is logged:
Event Type:Error
Event Source:Archive Manager Full Text Search Service
Event Category:None
Event ID:0
Date:DD/MM/YYYY
Time:HH:MM:SS
User:N/A
Computer:ArchiveManagerservername
Description:
Error in Full Text Search
There was an unhandled exception in this application
Exception Source: .Net SqlClient Data Provider
Exception Type: System.Data.SqlClient.SqlException
Exception Message: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 6, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 7, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 9, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 10, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 11, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 12, column 2 (Score).
Bulk load data conversion error (type mismatch or invalid character for the specified codepa
This is due to a mismatch between the Regional Settings of the SQL server and the WindowsOperating Systemwhere Archive Manager is installed.
WORKAROUND
Logon as the AM service account (by default ArchiveMgr_service) on the Archive Manager server and change the regional settings to English.
STATUS
Change Request ST29131 has been submitted to Development for consideration in a future release of Archive Manager.
