cabrite 发表于 2010-9-30 10:36:08

qc无法创建新项目,大概是数据库的问题,帮忙看下

以下是错误提示,我装oracle10的时候都是默认安装啊,而且装好之后,我去database control建了一个表空间“上海”也成功了,大家帮忙看看怎么解决,这俩以前都没弄过,一头雾水


to Create Project;
Failed to create Quality Center project;
Failed to create project '上海';
Failed to create new project '上海';
Can't load database;
CORACLEDBCreator : Unable to create database schema 'default_上海_db';
ORA-00959: tablespace '上海 (' does not exist
;

Stack Trace:
java.sql.SQLException: ORA-00959: tablespace '上海 (' does not exist

at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.execute(Unknown Source)
at com.mercury.optane.core.db.convertor.CORACLEDBCreator.createDB(CORACLEDBCreator.java:194)
        wrapped in com.mercury.optane.core.CTdException: CORACLEDBCreator : Unable to create database schema 'default_上海_db'
at com.mercury.optane.core.db.convertor.CORACLEDBCreator.createDB(CORACLEDBCreator.java:220)
at com.mercury.optane.core.db.convertor.CDBWriter.load(CDBWriter.java:175)
        wrapped in com.mercury.optane.core.CTdException: Can't load database
at com.mercury.optane.core.db.convertor.CDBWriter.load(CDBWriter.java:212)
at com.mercury.optane.core.db.convertor.CDBConvertor.load(CDBConvertor.java:85)
at com.mercury.optane.core.db.convertor.CDBConvertor.load(CDBConvertor.java:139)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertXML2DB(CDBConvertor.java:320)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertXML2DB(CDBConvertor.java:293)
at com.mercury.optane.core.db.convertor.CDBProject.importProject(CDBProject.java:216)
at com.mercury.optane.core.db.convertor.CDBProject.importProject(CDBProject.java:190)
at com.mercury.td.saserver.api.logics.CProjectLogic.createNewTdProject(CProjectLogic.java:4238)
        wrapped in com.mercury.optane.core.CTdException: Failed to create new project '上海'
at com.mercury.td.saserver.api.logics.CProjectLogic.createNewTdProject(CProjectLogic.java:4249)
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1681)
        wrapped in com.mercury.optane.core.CTdException: Failed to create project '上海'
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1699)
        wrapped in com.mercury.optane.core.CTdException: Failed to create Quality Center project
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1740)
at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectCreateProject(CTdSiteAdminServlet.java:326)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
        wrapped in com.mercury.optane.core.CTdException: Failed to Create Project
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)

archonwang 发表于 2010-9-30 10:45:15

oracle报错。请按提示检查。另外,不建议直接使用中文生成库名。

bill_hen 发表于 2010-9-30 10:59:44

很可能是 中文库名 QC 不认识。

cabrite 发表于 2010-9-30 14:46:17

谢谢二位,改成英文库名就好了,但是我之前装过一次,却可以,不过第二天机器重启之后,qc就有问题了,大概就是因为这个库名,呵呵

zoes0307 发表于 2011-8-3 09:56:26

我也和楼主一样的问题 请大家帮忙看看
Messages:
Failed to Create Project;
Failed to create Quality Center project;
Failed to create project 'ota';
Failed to create new project 'ota';
Can't load database;
CORACLEDBCreator : Unable to create database schema 'otatest_ota_db';
ORA-30033: Undo tablespace cannot be specified as default user tablespace
;

Stack Trace:
java.sql.SQLException: ORA-30033: Undo tablespace cannot be specified as default user tablespace

at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.execute(Unknown Source)
at com.mercury.optane.core.db.convertor.CORACLEDBCreator.createDB(CORACLEDBCreator.java:194)
        wrapped in com.mercury.optane.core.CTdException: CORACLEDBCreator : Unable to create database schema 'otatest_ota_db'
at com.mercury.optane.core.db.convertor.CORACLEDBCreator.createDB(CORACLEDBCreator.java:220)
at com.mercury.optane.core.db.convertor.CDBWriter.load(CDBWriter.java:175)
        wrapped in com.mercury.optane.core.CTdException: Can't load database
at com.mercury.optane.core.db.convertor.CDBWriter.load(CDBWriter.java:212)
at com.mercury.optane.core.db.convertor.CDBConvertor.load(CDBConvertor.java:85)
at com.mercury.optane.core.db.convertor.CDBConvertor.load(CDBConvertor.java:139)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertXML2DB(CDBConvertor.java:320)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertXML2DB(CDBConvertor.java:293)
at com.mercury.optane.core.db.convertor.CDBProject.importProject(CDBProject.java:216)
at com.mercury.optane.core.db.convertor.CDBProject.importProject(CDBProject.java:190)
at com.mercury.td.saserver.api.logics.CProjectLogic.createNewTdProject(CProjectLogic.java:4238)
        wrapped in com.mercury.optane.core.CTdException: Failed to create new project 'ota'
at com.mercury.td.saserver.api.logics.CProjectLogic.createNewTdProject(CProjectLogic.java:4249)
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1681)
        wrapped in com.mercury.optane.core.CTdException: Failed to create project 'ota'
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1699)
        wrapped in com.mercury.optane.core.CTdException: Failed to create Quality Center project
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1740)
at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectCreateProject(CTdSiteAdminServlet.java:326)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
        wrapped in com.mercury.optane.core.CTdException: Failed to Create Project
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)

zoes0307 发表于 2011-8-3 10:38:24

问题找到了是在创建时选择表空间的时候最好是选择自己新建的表空间!

wendi1986 发表于 2012-7-17 09:02:25

帮我看看这个又是什么原因
Messages:
Failed to Run Query;
Failed to execute the query;
Login failed for user 'sa'.;

Stack Trace:
com.mercury.jdbc.base.BaseSQLException: Login failed for user 'sa'.
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unknown Source)
at com.mercury.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.connect(Unknown Source)
at com.mercury.jdbc.base.BaseConnectionStartup.run(Unknown Source)
        wrapped in com.mercury.optane.core.CTdException:
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:665)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:491)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:316)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:299)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:264)
at com.mercury.optane.core.db.CAbsStatement.<init>(CAbsStatement.java:76)
at com.mercury.optane.core.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:129)
at com.mercury.optane.core.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:124)
at com.mercury.td.saserver.api.logics.CAdminLogic.runQuery(CAdminLogic.java:425)
        wrapped in com.mercury.optane.core.CTdException: Failed to execute the query
at com.mercury.td.saserver.api.logics.CAdminLogic.runQuery(CAdminLogic.java:503)
at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectRunQuery(CTdSiteAdminServlet.java:657)
at sun.reflect.GeneratedMethodAccessor657.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
        wrapped in com.mercury.optane.core.CTdException: Failed to Run Query
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)
页: [1]
查看完整版本: qc无法创建新项目,大概是数据库的问题,帮忙看下