<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Oracle Missing Tables</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>I am trying to install OpenCMS on Tomcat 4.1.31 with Oracle and Oracle errors stating that the view or table does not exist. I saw this same error posted a while back with no solution.<BR>
<BR>
119: at com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)<BR>
118: java.lang.NullPointerException<BR>
117: <BR>
116: >>> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>
115: >>> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>
114: >>> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)<BR>
113: >>> at java.lang.Class.newInstance(Class.java:232)<BR>
112: >>> at java.lang.Class.newInstance0(Native Method)<BR>
111: >>> at com.opencms.core.CmsShell.<init>(CmsShell.java:105)<BR>
110: >>> at com.opencms.core.OpenCms.<init>(OpenCms.java:245)<BR>
109: >>> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)<BR>
108: >>> at com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)<BR>
107: >>> at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)<BR>
106: >>> at com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)<BR>
105: >>> at com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:76)<BR>
104: >>> at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:304)<BR>
103: >>> at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2784)<BR>
102: >>> at com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1553)<BR>
101: >>> at com.opencms.file.genericSql.CmsDbAccess.nextId(CmsDbAccess.java:4861)<BR>
100: >>> at com.opencms.dbpool.CmsIdGenerator.nextId(CmsIdGenerator.java:104)<BR>
99: >>> at com.opencms.dbpool.CmsIdGenerator.generateNextId(CmsIdGenerator.java:125)<BR>
98: >>> at com.opencms.dbpool.CmsIdGenerator.readId(CmsIdGenerator.java:167)<BR>
97: >>> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)<BR>
96: >>> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)<BR>
95: >>> at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)<BR>
94: >>> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)<BR>
93: >>> at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513)<BR>
92: >>> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877)<BR>
91: >>> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)<BR>
90: >>> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)<BR>
89: >>> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)<BR>
88: >>> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)<BR>
87: >>>java.sql.SQLException: ORA-00942: table or view does not exist<BR>
86: >>>Root cause:<BR>
85: >>>-----------<BR>
84: >> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>
83: >> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>
82: >> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)<BR>
81: >> at java.lang.Class.newInstance(Class.java:232)<BR>
80: >> at java.lang.Class.newInstance0(Native Method)<BR>
79: >> at com.opencms.core.CmsShell.<init>(CmsShell.java:105)<BR>
78: >> at com.opencms.core.OpenCms.<init>(OpenCms.java:245)<BR>
77: >> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)<BR>
76: >> at com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)<BR>
75: >> at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)<BR>
74: >> at com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)<BR>
73: >> at com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:76)<BR>
72: >> at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:304)<BR>
71: >> at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2784)<BR>
70: >> at com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1553)<BR>
69: >> at com.opencms.file.genericSql.CmsDbAccess.nextId(CmsDbAccess.java:4861)<BR>
68: >> at com.opencms.dbpool.CmsIdGenerator.nextId(CmsIdGenerator.java:104)<BR>
67: >> at com.opencms.dbpool.CmsIdGenerator.generateNextId(CmsIdGenerator.java:125)<BR>
66: >> at com.opencms.dbpool.CmsIdGenerator.readId(CmsIdGenerator.java:174)<BR>
65: >>root cause was java.sql.SQLException: ORA-00942: table or view does not exist<BR>
64: >>.<BR>
63: >>com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.dbpool.CmsIdGenerator]ORA-00942: table or view does not exist<BR>
62: >>Root cause:<BR>
61: >>-----------<BR>
60: > at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>
59: > at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>
58: > at com.opencms.boot.CmsMain.begin(CmsMain.java:155)<BR>
57: > at java.lang.Class.newInstance(Class.java:232)<BR>
56: > at java.lang.Class.newInstance0(Native Method)<BR>
55: > at com.opencms.core.CmsShell.<init>(CmsShell.java:105)<BR>
54: > at com.opencms.core.OpenCms.<init>(OpenCms.java:245)<BR>
53: > at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)<BR>
52: >root cause was java.sql.SQLException: ORA-00942: table or view does not exist<BR>
51: >.<BR>
50: >root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.dbpool.CmsIdGenerator]ORA-00942: table or view does not exist<BR>
49: >com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker.<BR>
48: >Root cause:<BR>
47: >-----------<BR>
46: at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>
45: at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>
44: at com.opencms.boot.CmsMain.begin(CmsMain.java:155)<BR>
43: at java.lang.Class.newInstance(Class.java:232)<BR>
42: at java.lang.Class.newInstance0(Native Method)<BR>
41: at com.opencms.core.CmsShell.<init>(CmsShell.java:105)<BR>
40: at com.opencms.core.OpenCms.<init>(OpenCms.java:249)<BR>
39: <BR>
38: root cause was java.sql.SQLException: ORA-00942: table or view does not exist<BR>
37: .<BR>
36: root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.dbpool.CmsIdGenerator]ORA-00942: table or view does not exist<BR>
35: root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker.<BR>
34: com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Database init failed.<BR>
33: . Critical init error/3: com.opencms.core.CmsException: Critical error while loading resourcebroker<BR>
32: [CmsRbManager] Critical error while loading resourcebroker<BR>
<BR>
<BR>
Any help would be appreciated.<BR>
<BR>
Jack<BR>
<BR>
---------------------------------------------<BR>
Jack M. Gibson II<BR>
Thought Leader - J2EE Architect<BR>
jack.gibson@brulant.com<BR>
<BR>
Brulant, Inc.<BR>
216.518.7921 phone<BR>
330.328.5368 mobile<BR>
216.518.7991 fax<BR>
www.brulant.com<BR>
---------------------------------------------<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>