No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Log hints " failed to import static data TrailServiceType"

Publication Date:  2012-11-28 Views:  552 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