various error

Sean Chang <[email protected]> Mon, 12 Jul 2010 15:10:29 -0700 (PDT)
Newsgroups gmane.comp.java.scarab.user
Message-ID <1995346949.35302.1278972629447.JavaMail.httpd@localhost>
Hi there,

After I installed scarab with sample data, I opened it.
However, it had been redirected to login page and  numerous errors occurred.

Can anyone tell me why 'table or view does not exist' error occurred?

Thanks a lot!



===============================================================================



[ERROR] ScarabUserImpl - -An exception prevented retrieving any modules <org.apache.torque.TorqueExc
eption: java.sql.SQLException: ORA-00942: table or view does not exist
>org.apache.torque.TorqueException: java.sql.SQLException: ORA-00942: table or view does not exist

        at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103)
        at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:899)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:740)
        at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:702)
        at org.tigris.scarab.om.BaseScarabModulePeer.doSelectVillageRecords(BaseScarabModulePeer.jav
a:449)
        at org.tigris.scarab.om.BaseScarabModulePeer.doSelectVillageRecords(BaseScarabModulePeer.jav
a:421)
        at org.tigris.scarab.om.BaseScarabModulePeer.doSelect(BaseScarabModulePeer.java:390)
        at org.tigris.scarab.om.ScarabUserImpl.getModules(ScarabUserImpl.java:498)
        at org.tigris.scarab.om.ScarabUserImpl.getPrivateModules(ScarabUserImpl.java:239)
        at org.tigris.scarab.om.ScarabUserImpl.access$600(ScarabUserImpl.java:100)
        at org.tigris.scarab.om.ScarabUserImpl$1.getModules(ScarabUserImpl.java:179)
        at org.tigris.scarab.om.ScarabUserImpl$1.getModules(ScarabUserImpl.java:169)
        at org.tigris.scarab.om.ScarabUserImpl.getNonGlobalModules(ScarabUserImpl.java:656)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:11
1)
        at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.j
ava:302)
        at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
        at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
        at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:51)
        at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:95)
        at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
        at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:70)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
        at org.apache.velocity.Template.merge(Template.java:256)
        at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:450)
        at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:419)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:317)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:273)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:263)
        at org.apache.fulcrum.template.TurbineTemplateService.handleRequest(TurbineTemplateService.j
ava:274)
        at org.apache.turbine.modules.Module.handleRequest(Module.java:177)
        at org.apache.turbine.pipeline.DirectRenderer.render(DirectRenderer.java:97)
        at org.apache.turbine.pipeline.Renderer.render(Renderer.java:123)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.j
ava:267)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
        at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
        at org.apache.velocity.Template.merge(Template.java:256)
        at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:450)
        at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:419)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:317)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:273)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:263)
        at org.apache.fulcrum.template.TurbineTemplateService.handleRequest(TurbineTemplateService.j
ava:274)
        at org.apache.turbine.modules.Module.handleRequest(Module.java:177)
        at org.apache.turbine.pipeline.DirectRenderer.render(DirectRenderer.java:97)
        at org.apache.turbine.pipeline.Renderer.render(Renderer.java:123)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.j
ava:267)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
        at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
        at org.apache.velocity.Template.merge(Template.java:256)
        at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:450)
        at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:419)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:317)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:273)
        at org.apache.fulcrum.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.j
ava:263)
        at org.apache.fulcrum.template.TurbineTemplateService.handleRequest(TurbineTemplateService.j
ava:274)
        at org.apache.turbine.modules.Module.handleRequest(Module.java:177)
        at org.apache.turbine.pipeline.DirectRenderer.render(DirectRenderer.java:97)
        at org.apache.turbine.pipeline.DirectTargetValve.render(DirectTargetValve.java:100)
        at org.apache.turbine.pipeline.DefaultTargetValve.execute(DefaultTargetValve.java:162)
        at org.apache.turbine.pipeline.DefaultTargetValve.invoke(DefaultTargetValve.java:124)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.RunModulesValve.invoke(RunModulesValve.java:115)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.DefaultActionValve.invoke(DefaultActionValve.java:108)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.DefaultACLCreationValve.invoke(DefaultACLCreationValve.java:1
27)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.SetLocaleValve.invoke(SetLocaleValve.java:112)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.FreshenUserValve.invoke(FreshenUserValve.java:189)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.DefaultSessionValidationValve.invoke(DefaultSessionValidation
Valve.java:131)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.DefaultLoginValve.invoke(DefaultLoginValve.java:109)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.AnonymousLoginValve.invoke(AnonymousLoginValve.java:63)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.NTLMLoginValve.invoke(NTLMLoginValve.java:70)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.DefaultSessionTimeoutValve.invoke(DefaultSessionTimeoutValve.
java:121)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.DetermineTargetValve.invoke(DetermineTargetValve.java:138)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.DetermineActionValve.invoke(DetermineActionValve.java:107)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.SetInfoMessageValve.invoke(SetInfoMessageValve.java:85)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.ResetCacheValve.invoke(ResetCacheValve.java:77)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.DetermineCharsetValve.invoke(DetermineCharsetValve.java:103)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.tigris.scarab.pipeline.TimingInfoValve.invoke(TimingInfoValve.java:131)
        at org.apache.turbine.pipeline.TurbinePipeline.invokeNext(TurbinePipeline.java:231)
        at org.apache.turbine.pipeline.TurbinePipeline.invoke(TurbinePipeline.java:213)
        at org.apache.turbine.Turbine.doGet(Turbine.java:298)
        at org.apache.turbine.Turbine.doPost(Turbine.java:343)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:247)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:641)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:641)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:641)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:641)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11P
rotocol.java:549)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
        at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:916)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1132)
        at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:968)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1475)
        at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
        at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:888)
        ... 146 more

------------------------------------------------------
http://scarab.tigris.org/ds/viewMessage.do?dsForumId=456&dsMessageId=2632454

To unsubscribe from this discussion, e-mail: [[email protected]].