设为首页收藏本站
开启辅助访问 切换到宽版

天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件

 找回密码
 注册成为天翎用户
天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件»首页 › 技术支持 › 普通求助专区 › 迁移oacle报错！！！！！！！！！！！1
返回列表 发新帖
查看: 2744|回复: 3

迁移oacle报错！！！！！！！！！！！1

[复制链接]
lingfenghuzhou 发表于 2011-7-27 17:04:43 | 显示全部楼层 |阅读模式
本帖最后由 shary 于 2011-8-3 09:27 编辑

7:00:44,593  INFO ProxoolFacade:86 - Proxool 0.9.1 (23-Aug-2008 11:10)
17:01:11,859 ERROR SchemaUpdate:155 - Unsuccessful: alter table T_APPLICATION add ID varchar2(255)
17:01:11,859 ERROR SchemaUpdate:156 - ORA-00942: table or view does not exist

17:01:17,968 ERROR SchemaUpdate:155 - Unsuccessful: alter table T_USER_ROLE_SET add constraint FK82CBCE42F336993C foreign key (USERID) references T_USER
17:01:17,968 ERROR SchemaUpdate:156 - ORA-00942: table or view does not exist

17:01:21,593  WARN JDBCExceptionReporter:77 - SQL Error: 942, SQLState: 42000
17:01:21,593 ERROR JDBCExceptionReporter:78 - ORA-00942: table or view does not exist

cn.myapps.init.InitializationException: could not execute query
        at cn.myapps.init.InitOperationInfo.run(InitOperationInfo.java:81)
        at cn.myapps.init.InitSystem.init(InitSystem.java:41)
        at cn.myapps.base.web.listener.StartupListener.contextInitialized(StartupListener.java:53)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        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:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
17:01:21,687  INFO AutoAuditJobManager:64 - ********************* Auto Audit Job Manager Init Jobs Start ********************
17:01:22,421  WARN JDBCExceptionReporter:77 - SQL Error: 942, SQLState: 42000
17:01:22,421 ERROR JDBCExceptionReporter:78 - ORA-00942: table or view does not exist

17:01:22,437 ERROR AutoAuditJobManager:135 - Auto Audit Job Manager Init Jobs Error:
org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2214)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at cn.myapps.base.dao.HibernateBaseDAO.getDatas(HibernateBaseDAO.java:237)
        at cn.myapps.base.dao.HibernateBaseDAO.getDatas(HibernateBaseDAO.java:164)
        at cn.myapps.base.dao.HibernateBaseDAO.getDatas(HibernateBaseDAO.java:111)
        at cn.myapps.base.dao.HibernateBaseDAO.simpleQuery(HibernateBaseDAO.java:677)
        at cn.myapps.base.ejb.AbstractDesignTimeProcessBean.doSimpleQuery(AbstractDesignTimeProcessBean.java:330)
        at cn.myapps.core.deploy.application.ejb.ApplicationProcessBean$$EnhancerByCGLIB$$b39c2f5e.CGLIB$doSimpleQuery$20(<generated>)
        at cn.myapps.core.deploy.application.ejb.ApplicationProcessBean$$EnhancerByCGLIB$$b39c2f5e$$FastClassByCGLIB$$1a652562.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:182)
        at cn.myapps.core.deploy.application.ejb.ApplicationProcessBean$$EnhancerByCGLIB$$b39c2f5e.doSimpleQuery(<generated>)
        at cn.myapps.core.workflow.engine.AutoAuditJobManager.initJobs(AutoAuditJobManager.java:75)
        at cn.myapps.base.web.listener.StartupListener.contextInitialized(StartupListener.java:76)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        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:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
17:01:22,468  INFO AutoAuditJobManager:144 - ********************* Auto Audit Job Manager Init Jobs End ********************
17:01:22,609  INFO Logger:51 - Logging using commons-logging.
Pushlet[INFO] Config: loading pushlet.properties from classpath
Pushlet[INFO] Config: loaded values={pull.refresh.wait.max.millis=10000, subscriber.class=cn.myapps.core.pushlet.OBPMSubscriber, session.timeout.mins=5, log.level=4, config.version=1.0.2, sessionmanager.class=nl.justobjects.pushlet.core.SessionManager, queue.size=24, listen.force.pull.all=false, queue.read.timeout.millis=1000, poll.refresh.wait.max.millis=10000, listen.force.pull.agents=safari, pull.refresh.timeout.millis=300000, subscription.class=nl.justobjects.pushlet.core.Subscription, queue.write.timeout.millis=20, logger.class=nl.justobjects.pushlet.util.Log4jLogger, session.class=nl.justobjects.pushlet.core.Session, session.id.generation=randomstring, dispatcher.class=nl.justobjects.pushlet.core.Dispatcher, poll.refresh.wait.min.millis=6000, poll.refresh.timeout.millis=60000, pull.refresh.wait.min.millis=5000, session.id.size=10, controller.class=nl.justobjects.pushlet.core.Controller, sources.activate=true}
17:01:27,125  INFO pushlet:79 - Logging intialized logger class=class nl.justobjects.pushlet.util.Log4jLogger
17:01:27,125  INFO pushlet:79 - init() Pushlet Webapp - version=2.0.4 built=20100205-1406
17:01:27,140  INFO pushlet:79 - SessionManager created className=class nl.justobjects.pushlet.core.SessionManager
17:01:27,140  INFO pushlet:79 - SessionManager: Wed Jul 27 17:01:27 CST 2011 started; interval=60000ms
17:01:27,156  INFO pushlet:79 - Dispatcher created className=class nl.justobjects.pushlet.core.Dispatcher
17:01:27,156  INFO pushlet:79 - Dispatcher started
17:01:27,156  INFO pushlet:79 - EventSourceManager: start
17:01:27,171  INFO pushlet:79 - Activating 0 EventSources
回复

使用道具 举报

linner 发表于 2011-7-28 10:45:24 | 显示全部楼层
这个我之前也有遇到过，你试着新建一个空的数据库重新运行一下看，因为可能你的表已经存在了，所以运行时创建表的时候报错，我之前就是这样解决的，希望能对你有帮助。
回复 支持 反对

使用道具 举报

matt_ 发表于 2011-7-28 13:44:42 | 显示全部楼层
今天己经测试过oracle，没有问题！你试着新建一个空的数据库，还有就是oracle的权限问题也要注意一下！
回复 支持 反对

使用道具 举报

shary 发表于 2011-7-28 13:54:12 | 显示全部楼层
你要确认一下你的用户权限。是有有创建表的权限。
回复 支持 反对

使用道具 举报

返回列表 发新帖

本版积分规则

QQ|手机版|天翎MyApps技术社区 ( 粤ICP备11093750号 )

GMT+8, 2026-8-12 12:35

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表