Re: various error
Hussayn Dabbous <[email protected]> Tue, 13 Jul 2010 10:50:37 +0200
| Newsgroups | gmane.comp.java.scarab.user |
|---|---|
| Message-ID | <[email protected]> |
I am not sure if oracle is fully supported by scarab. It would be interesting to know: - which version of scarab you installed - which table does not exist - how you installed scarab - which Java-version - ... the more essential details you provide, the easier it will be to track down your problem. But as i said in frist place, i remember that oracle was never working out of the box in the past. However i may be wrong here ;-) I know Scarab works reliably with MySql (i have several productive instances) and with Postgress (i only know it was fully supported in the past) i am using the current trunk, while Johannes puts all his efforts into getting the next stable release done (or is it allready finished, johannes?) regards, hussayn Am 13.07.2010 00:10, schrieb Sean Chang: > 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]]. > ------------------------------------------------------ http://scarab.tigris.org/ds/viewMessage.do?dsForumId=456&dsMessageId=2632647 To unsubscribe from this discussion, e-mail: [[email protected]].