[opencms-dev] ORA-00903: invalid table name

[Daniel Hasler]

Hello there,

I'm very new to OpenCms, so this might be a silly question. I created a
new Group "XYZ" and suddenly, I'm not able to edit any group. I see a
fat error box that says: ORA-00903: invalid table name. It also comes
with the stack trace below. Other administration tasks can be done
without error messages. I even logged out and restarted tomcat as well
as my browser... no result! How can I administrate my user group again?
Why did this happen?

I would appreciate any help! Thanks,

Daniel


java.sql.SQLException: ORA-00903: invalid table name

	at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
	at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
	at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:880)
	at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2516)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2850)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:537)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
	at
org.opencms.db.generic.CmsUserDriver.readUsersOfGroup(CmsUserDriver.java:997)
	at
org.opencms.db.CmsDriverManager.getUsersOfGroup(CmsDriverManager.java:3690)
	at
org.opencms.db.CmsSecurityManager.getUsersOfGroup(CmsSecurityManager.java:2029)
	at
org.opencms.file.CmsObject.getUsersOfGroup(CmsObject.java:1445)
	at
com.opencms.workplace.CmsAdminGroups.getContent(CmsAdminGroups.java:296)
	at
com.opencms.template.CmsXmlTemplate.getContent(CmsXmlTemplate.java:136)
	at
com.opencms.template.CmsRootTemplate.getMasterTemplate(CmsRootTemplate.java:122)
	at
com.opencms.legacy.CmsXmlTemplateLoader.callCanonicalRoot(CmsXmlTemplateLoader.java:198)
	at
com.opencms.legacy.CmsXmlTemplateLoader.generateOutput(CmsXmlTemplateLoader.java:488)
	at
com.opencms.legacy.CmsXmlTemplateLoader.processXmlTemplate(CmsXmlTemplateLoader.java:715)
	at
com.opencms.legacy.CmsXmlTemplateLoader.load(CmsXmlTemplateLoader.java:631)
	at
org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:648)
	at
org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1346)
	at
org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:103)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
	at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
	at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
	at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
	at java.lang.Thread.run(Thread.java:534)




-------------------------------------------------------------------------
This message is intended for the addressee only and may
contain confidential or privileged information. If you
are not the intended receiver, any disclosure, copying
to any person or any action taken or omitted to be taken
in reliance on this e-mail, is prohibited and may be un-
lawful. You must therefore delete this e-mail.
Internet communications may not be secure or error-free
and may contain viruses. They may be subject to possible
data corruption, accidental or on purpose. This e-mail is
not and should not be construed as an offer or the
solicitation of an offer to purchase or subscribe or sell
or redeem any investments.
-------------------------------------------------------------------------