Log hints " failed to import static data TrailServiceType"

Publication Date:  2012-11-28 Views:  210 Downloads:  0
Issue Description
Database initialization failed, through checking the log under the directory“C:\HWENGR\logs\logsServer”, found the following tip information:
2008-04-02_18:20:11(CServerConfig.RunCommand) ERROR:Execute command failed
2008-04-02_18:20:11(CServerConfig.RunCommand) ERROR:java.lang.Exception: MSSQL bcp executes failed
2008-04-02_18:20:11(CServerConfig.LoadDataTable) ERROR:Load data to VSMDB.TrailServiceType from D:\VSM\server\database/staticdata/chinese\TrailServiceType.dat failed
2008-04-02_18:20:11(CServerConfig.LoadDataTable) ERROR:java.lang.Exception: Failed to import static data.
2008-04-02_18:20:11(CServerConfigManagement.loadAllStaticDatatable)       ERROR:load static data failed
2008-04-02_18:20:11(CServerConfigManagement.loadAllStaticDatatable)       ERROR:java.lang.Exception: Failed to import static data.
2008-04-02_18:20:11(CServerConfigManagement.InitializeDatabase)       ERROR:Initialize database failed
2008-04-02_18:20:11(CServerConfigManagement.InitializeDatabase)       ERROR:java.lang.Exception: Failed to import static data.
2008-04-02_18:20:11(CServerConfigManagement.InitializeDatabase)       ERROR:Error Message is Starting copy...
SQLState = 23000, NativeError = 2627
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UQ__TrailServiceType__114A936A'. Cannot insert duplicate key in object 'TrailServiceType'.
SQLState = 01000, NativeError = 3621
Warning = [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
BCP copy in failed
Alarm Information
None.
Handling Process
Step 1: at the command prompt execute the following commands:  
       > isql -Usa -Psa's_password -SDBSVR
            1> sp_helpsort
            2> go
      the screen displays:
            Unicode 3.1 UTF-8 Character Set
        Note: if appeared UTF-8, namely the used character set of database is Chinese, otherwise need to reinstall database.
Step 2: try to reinitialize database.
Root Cause
The character set of Microsoft SQL server database is not Chinese, but the used network management is Chinese.
Suggestions
None.

END