起步软件技术论坛-X3

 找回密码
 立即注册
搜索
楼主: weirongjia

【结贴】服务器报的错误**

[复制链接]
发表于 2008-9-4 09:10:53 | 显示全部楼层
跟oracle是那个版本没有关系
回复 支持 反对

使用道具 举报

 楼主| 发表于 2008-9-4 09:17:42 | 显示全部楼层
早上网有问题  刚看到十七楼的内容
正在修改
applied_patch
child_assoc
externalKeys
node
node_aspects
node_assoc
node_perm_entry
node_permission
node_properties
node_status
permission_ref
recipient
store
version_count这几个是数据库的表么?
回复 支持 反对

使用道具 举报

发表于 2008-9-4 09:18:29 | 显示全部楼层
是的文档服务器用到的数据表
回复 支持 反对

使用道具 举报

 楼主| 发表于 2008-9-4 09:24:36 | 显示全部楼层
全删除了
还是报错
错误如下:
回复 支持 反对

使用道具 举报

 楼主| 发表于 2008-9-4 09:27:06 | 显示全部楼层
at $Proxy3.exists(Unknown Source)
        at org.alfresco.repo.importer.ImporterBootstrap.performBootstrap(Importe
rBootstrap.java:483)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootst
rap.java:271)
        ... 48 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
        at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:12
55)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2391)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2672)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:527)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:92)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
137)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
        at org.hibernate.loader.Loader.doQuery(Loader.java:662)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:223)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1782)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:47)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:41)
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractE
ntityPersister.java:2705)
        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(D
efaultLoadEventListener.java:365)
        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEv
entListener.java:346)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEven
tListener.java:123)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultL
oadEventListener.java:177)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEv
entListener.java:87)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:774)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:714)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:707)
        at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(
HibernateTemplate.java:451)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:365)
        ... 78 more
2008-9-4 9:22:57 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
2008-9-4 9:22:57 org.apache.catalina.core.StandardContext start
严重: Context [/transfile] startup failed due to previous errors
09:22:57,546 ERROR [[Catalina].[localhost].[/transfile]] Exception sending conte
xt destroyed event to listener instance of class org.alfresco.web.app.ContextLis
tener
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'descriptorComponent' defined in class path resource [alfresco/core-servi
ces-context.xml]: Can't resolve reference to bean 'systemBootstrap' while settin
g property 'systemBootstrap'; nested exception is org.springframework.beans.fact
ory.BeanCreationException: Error creating bean with name 'systemBootstrap' defin
ed in class path resource [alfresco/core-services-context.xml]: Initialization o
f bean failed; nested exception is org.alfresco.error.AlfrescoRuntimeException:
Bootstrap failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'systemBootstrap' defined in class path resource [alfresco/core-services-
context.xml]: Initialization of bean failed; nested exception is org.alfresco.er
ror.AlfrescoRuntimeException: Bootstrap failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootst
rap.java:364)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:363)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:147)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:176)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:824)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:345)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:147)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
getBeansOfType(DefaultListableBeanFactory.java:203)
        at org.springframework.context.support.AbstractApplicationContext.getBea
nsOfType(AbstractApplicationContext.java:614)
        at org.springframework.context.support.AbstractApplicationContext.regist
erListeners(AbstractApplicationContext.java:496)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:317)
        at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3692)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
127)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73
9)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:910)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:873)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
50)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:680
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation:
could not load an entity: [org.alfresco.repo.domain.hibernate.StoreImpl#compone
nt[protocol,identifier]{protocol=system, identifier=system}]; bad SQL grammar [s
elect storeimpl0_.protocol as protocol6_1_, storeimpl0_.identifier as identifier
6_1_, storeimpl0_.root_protocol as root3_6_1_, storeimpl0_.root_identifier as ro
ot4_6_1_, storeimpl0_.root_guid as root5_6_1_, nodeimpl1_.protocol as protocol0_
0_, nodeimpl1_.identifier as identifier0_0_, nodeimpl1_.guid as guid0_0_, nodeim
pl1_.type_qname as type4_0_0_, properties2_.protocol as protocol3_, properties2_
.identifier as identifier3_, properties2_.guid as guid3_, properties2_.actual_ty
pe as actual4_3_, properties2_.multi_valued as multi5_3_, properties2_.persisted
_type as persisted6_3_, properties2_.boolean_value as boolean7_3_, properties2_.
long_value as long8_3_, properties2_.float_value as float9_3_, properties2_.doub
le_value as double10_3_, properties2_.string_value as string11_3_, properties2_.
serializable_value as seriali12_3_, properties2_.qname as qname3_ from store sto
reimpl0_, node nodeimpl1_, node_properties properties2_ where storeimpl0_.root_p
rotocol=nodeimpl1_.protocol(+) and storeimpl0_.root_identifier=nodeimpl1_.identi
fier(+) and storeimpl0_.root_guid=nodeimpl1_.guid(+) and nodeimpl1_.protocol=pro
perties2_.protocol(+) and nodeimpl1_.identifier=properties2_.identifier(+) and n
odeimpl1_.guid=properties2_.guid(+) and storeimpl0_.protocol=? and storeimpl0_.i
dentifier=?]; nested exception is java.sql.SQLException: ORA-00942: 表或视图不存


        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.t
ranslate(SQLErrorCodeSQLExceptionTranslator.java:223)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAcces
sException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernate
AccessException(HibernateAccessor.java:411)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:370)
        at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTem
plate.java:445)
        at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTem
plate.java:439)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getSt
ore(HibernateNodeDaoServiceImpl.java:171)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:335)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:181)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
        at org.alfresco.repo.transaction.NodeDaoServiceTransactionInterceptor.in
voke(NodeDaoServiceTransactionInterceptor.java:61)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy1.getStore(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.exists(DbNodeServiceImpl.
java:107)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:335)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:165)
        at $Proxy2.exists(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvoc
ationHandler.invoke(StoreRedirectorProxyFactory.java:212)
        at $Proxy3.exists(Unknown Source)
        at org.alfresco.repo.importer.ImporterBootstrap.performBootstrap(Importe
rBootstrap.java:483)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootst
rap.java:271)
        ... 48 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
        at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:12
55)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2391)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2672)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:527)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:92)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
137)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
        at org.hibernate.loader.Loader.doQuery(Loader.java:662)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:223)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1782)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:47)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:41)
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractE
ntityPersister.java:2705)
        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(D
efaultLoadEventListener.java:365)
        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEv
entListener.java:346)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEven
tListener.java:123)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultL
oadEventListener.java:177)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEv
entListener.java:87)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:774)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:714)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:707)
        at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(
HibernateTemplate.java:451)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:365)
        ... 78 more
2008-9-4 9:22:57 org.apache.coyote.http11.Http11AprProtocol start
信息: Starting Coyote HTTP/1.1 on http-8081
2008-9-4 9:22:58 org.apache.coyote.ajp.AjpAprProtocol start
信息: Starting Coyote AJP/1.3 on ajp-8009
2008-9-4 9:22:58 org.apache.catalina.storeconfig.StoreLoader load
信息: Find registry server-registry.xml at classpath resource
2008-9-4 9:22:58 org.apache.catalina.startup.Catalina start
信息: Server startup in 31422 ms
回复 支持 反对

使用道具 举报

 楼主| 发表于 2008-9-4 09:42:13 | 显示全部楼层
我现在把那个服务端卸载了
重现安装重新连接数据库试试
回复 支持 反对

使用道具 举报

发表于 2008-9-4 09:43:05 | 显示全部楼层
好的
回复 支持 反对

使用道具 举报

 楼主| 发表于 2008-9-4 11:26:08 | 显示全部楼层
服务器现在不报错了
但是我导入自己建立的资源的时候  有错误  说的是initial区创建失败  
是不是因为权限不够啊
我现在有的权限就是connection  resources  还有create table和createview
还有为什么我导入组织机构后  组织机构没有啊?
回复 支持 反对

使用道具 举报

发表于 2008-9-4 11:27:32 | 显示全部楼层
把错误贴出来看看,是不是表空间的大小不够了呢?
回复 支持 反对

使用道具 举报

 楼主| 发表于 2008-9-4 15:31:07 | 显示全部楼层
对 业务模型\物资管理数据库\资金来源代码表(BIZ2:\ZKJTWZGLXT\WZGLSJK.DATABASE\ZJLYDMB.TABLE) 执行数据迁移任务时发生了错误。错误信息: 错误类型:Exception
错误信息:建表错误: 在执行SQL语句的过程中出现错误:
CREATE  TABLE ZJLYDMB(ZJLYBM VARCHAR(3) NOT NULL  , ZJLYMC VARCHAR(200) NULL ,PRIMARY KEY(ZJLYBM))错误信息:ExecuteSQL error: ORA-01658: 无法为表空间ZBM中的段创建 INITIAL 区

详细信息:   创建数据表ZJLYDMB.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

小黑屋|手机版|Justep Inc.

GMT+8, 2025-7-22 01:47 , Processed in 0.040434 second(s), 12 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

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