日志提示“导入静态数据TrailServiceType失败”

发布时间:  2012-07-18 浏览次数:  48 下载次数:  0
问题描述
数据库初始化失败,通过查看“C:\HWENGR\logs\logsServer”目录下的日志,发现以下提示信息:
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: 导入静态数据失败 .
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: 导入静态数据失败 .
2008-04-02_18:20:11(CServerConfigManagement.InitializeDatabase)       ERROR:Initialize database failed
2008-04-02_18:20:11(CServerConfigManagement.InitializeDatabase)       ERROR:java.lang.Exception: 导入静态数据失败 .
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

告警信息
处理过程
步骤 1     在命令提示符下执行如下命令:            > isql -Usa -Psa's_password -SDBSVR
            1> sp_helpsort
            2> go
        屏幕显示:
            Unicode 3.1 UTF-8 Character Set
        说明:如果出现UTF-8,说明数据库所用的字符集是中文,否则需要重装数据库。
步骤 2尝试重新初始化数据库。
根因
Microsoft SQL server数据库的字符集不是中文,但所使用的网管为中文。
建议与总结

END