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

weirongjia · 发表于 2008-9-3 10:40:32

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-3 10:34:39 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
2008-9-3 10:34:39 org.apache.catalina.core.StandardContext start
严重: Context [/transfile] startup failed due to previous errors
10:34:39,640 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-3 10:34:40 org.apache.coyote.http11.Http11AprProtocol start
信息: Starting Coyote HTTP/1.1 on http-8081
2008-9-3 10:34:40 org.apache.coyote.ajp.AjpAprProtocol start
信息: Starting Coyote AJP/1.3 on ajp-8009
2008-9-3 10:34:40 org.apache.catalina.storeconfig.StoreLoader load
信息: Find registry server-registry.xml at classpath resource
2008-9-3 10:34:40 org.apache.catalina.startup.Catalina start
信息: Server startup in 41188 ms

shangxy · 发表于 2008-9-3 10:43:57

取消oracle用户的DBA角色，分配resource角色和connect角色看看

weirongjia · 发表于 2008-9-3 11:00:02

还是有错误

weirongjia · 发表于 2008-9-3 11:01:55

修改以后仍然有错误
为什么会报一个表或视图不存在的错误啊？

weirongjia · 发表于 2008-9-3 11:24:47

谁给讲讲吧
谢谢了

shangxy · 发表于 2008-9-3 11:27:57

文档服务器使用的那个oracle用户的DBA角色去掉以后，错误还是1楼的那个么？
问题现象好像就是文档服务器的表没有创建成功，如果是DBA权限那么是不能创建成功的。

weirongjia · 发表于 2008-9-3 11:31:57

我用的是sys账号初始化的
中间没有报告错误
初始化好以后服务器就报告错误了
然后我有新建账号重启服务还是那个错误

shangxy · 发表于 2008-9-3 11:50:27

请不要用sys账号
你建立一个账号，那么这个账号要去掉DBA权限
检查一下你配置工具中系统数据库使用的数据源是那个？是你新建的么？

weirongjia · 发表于 2008-9-3 14:36:13

？？？
怎么解决呢？

weirongjia · 发表于 2008-9-3 15:09:04

我现在新建立了个数据库准备重新初始化
我是不是要新建立个用户名和密码然后不赋予dba角色
应该对这个账号都赋予那些角色呢？

		自动登录	找回密码
密码			立即注册