win7下sybase15.0.3开发版恢复数据库，无法为索引找到可用的索引描述符

zhangsan2 2014-02-17 11:23:34

win7下sybase15.0.3恢复在另一台电脑上拷贝来的dmp文件（未知备份细节），联机后不能打开用户表，症状：
com.sybase.jdbc3.jdbc.SybSQLException: 无法为索引找到可用的索引描述符。增加'number of open indexes'的值。若sp_configure因为缺少索引描述符而失败, 编辑配置文件并重启服务器。
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.tds.TdsResultSet.nextResult(Unknown Source)
at com.sybase.jdbc3.tds.TdsResultSet.next(Unknown Source)
at com.sybase.jdbc3.jdbc.SybResultSet.next(Unknown Source)
at com.sybase.aseplugin.sql.ASResultSet.getNextRow(ASResultSet.java:179)
at com.sybase.aseplugin.so.TablesCtrSO.open(TablesCtrSO.java:61)
at com.sybase.aseplugin.bo.ASEBaseContainer2.getItems(ASEBaseContainer2.java:600)
at com.sybase.aseplugin.bo.ASEBaseContainer2.getItems(ASEBaseContainer2.java:594)
at com.sybase.aseplugin.bo.ASEBaseContainer2.open(ASEBaseContainer2.java:276)
at com.sybase.aseplugin.bo.ASEBaseContainer2.open(ASEBaseContainer2.java:257)
at com.sybase.aseplugin.bo.ASEContainerHelper.onNotify(ASEContainerHelper.java:560)
at com.sybase.aseplugin.bo.ASEBaseContainer2.onNotify(ASEBaseContainer2.java:373)
at com.sybase.central.viewer.NewInterfaceVersionHelper.doOnNotify(NewInterfaceVersionHelper.java:83)
at com.sybase.central.viewer.ScopePane.treeWillExpand(ScopePane.java:182)
at javax.swing.JTree.fireTreeWillExpand(JTree.java:2726)
at javax.swing.JTree.setExpandedState(JTree.java:3424)
at javax.swing.JTree.expandPath(JTree.java:2166)
at javax.swing.plaf.basic.BasicTreeUI.toggleExpandState(BasicTreeUI.java:2209)
at javax.swing.plaf.basic.BasicTreeUI.handleExpandControlClick(BasicTreeUI.java:2196)
at javax.swing.plaf.basic.BasicTreeUI.checkForClickInExpandControl(BasicTreeUI.java:2154)
at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(BasicTreeUI.java:3508)
at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(BasicTreeUI.java:3456)
at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3983)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2440)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at com.sybase.util.EventMonitor.dispatchEvent(EventMonitor.java:435)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
期待高手给出解决方案，我是菜鸟一个！
万分感谢！

...全文