急急急，即时通讯服务启动不起来

czdh

即时通讯服务启动不起来，在服务器配置工具中配置了一下数据库，即时通讯服务就启动不了了，请帮忙解决一下。

czdh

2011.07.19 08:51:26 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:280)
]
java.sql.SQLException: 对象名 'jiveProperty' 无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:271)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)
        at org.jivesoftware.util.JiveProperties.<init>(JiveProperties.java:49)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:43)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:495)
        at org.jivesoftware.wildfire.XMPPServer.initialize(XMPPServer.java:331)
        at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:409)
        at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:177)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)
        at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
2011.07.19 08:51:26 [org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:669)
] Database could not be accessed
java.sql.SQLException: 对象名 'jiveID' 无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:660)
        at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:413)
        at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:177)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)
        at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
2011.07.19 08:51:27 [org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:443)
]
java.lang.IllegalArgumentException: java.sql.SQLException: 对象名 'jiveID' 无效。
        at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:670)
        at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:413)
        at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:177)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)
        at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)
Caused by: java.sql.SQLException: 对象名 'jiveID' 无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:660)
        ... 10 more

czdh

info.log


2011.07.19 08:51:26 Found old database schema (2.0). Upgrading to latest schema.
2011.07.19 08:51:26 Warning: Make sure that database was not modified for release: 2.1. Upgrade script not found: /database/upgrade/2.0_to_2.1/wildfire_sqlserver.sql
2011.07.19 08:51:26 Warning: Make sure that database was not modified for release: 2.2. Upgrade script not found: /database/upgrade/2.1_to_2.2/wildfire_sqlserver.sql
2011.07.19 08:51:26 Warning: Make sure that database was not modified for release: 2.3. Upgrade script not found: /database/upgrade/2.2_to_2.3/wildfire_sqlserver.sql
2011.07.19 08:51:26 Warning: Make sure that database was not modified for release: 2.4. Upgrade script not found: /database/upgrade/2.3_to_2.4/wildfire_sqlserver.sql
2011.07.19 08:51:26 Warning: Make sure that database was not modified for release: 2.5. Upgrade script not found: /database/upgrade/2.4_to_2.5/wildfire_sqlserver.sql
2011.07.19 08:51:26 Database upgraded successfully.
2011.07.19 08:51:27 Server halted

amao800613

看日志好像是你的数据库中把Messenger对应的数据库表弄丢了，jive打头的都是即时通信的表！

czdh

运行了一下C:\Program Files\Justep\X3 Server\IMserver\resources\database，下面的sqlserver.sql,x3sys和x3doc都有jive的表

czdh

服务器配置工具中业务数据库和文档数据库是指向X3SYSY还是X3DOC