[opencms-dev] Oracle Missing Tables

Jack Gibson jack.gibson at brulant.com
Fri Dec 10 00:56:39 CET 2004 

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.

119:		at com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
118:	java.lang.NullPointerException
117:	
116:	>>>	at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
115:	>>>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
114:	>>>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
113:	>>>	at java.lang.Class.newInstance(Class.java:232)
112:	>>>	at java.lang.Class.newInstance0(Native Method)
111:	>>>	at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
110:	>>>	at com.opencms.core.OpenCms.<init>(OpenCms.java:245)
109:	>>>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
108:	>>>	at com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
107:	>>>	at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
106:	>>>	at com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
105:	>>>	at com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:76)
104:	>>>	at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:304)
103:	>>>	at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2784)
102:	>>>	at com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1553)
101:	>>>	at com.opencms.file.genericSql.CmsDbAccess.nextId(CmsDbAccess.java:4861)
100:	>>>	at com.opencms.dbpool.CmsIdGenerator.nextId(CmsIdGenerator.java:104)
99:	>>>	at com.opencms.dbpool.CmsIdGenerator.generateNextId(CmsIdGenerator.java:125)
98:	>>>	at com.opencms.dbpool.CmsIdGenerator.readId(CmsIdGenerator.java:167)
97:	>>>	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
96:	>>>	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
95:	>>>	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
94:	>>>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)
93:	>>>	at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513)
92:	>>>	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877)
91:	>>>	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
90:	>>>	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
89:	>>>	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
88:	>>>	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
87:	>>>java.sql.SQLException: ORA-00942: table or view does not exist
86:	>>>Root cause:
85:	>>>-----------
84:	>>	at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
83:	>>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
82:	>>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
81:	>>	at java.lang.Class.newInstance(Class.java:232)
80:	>>	at java.lang.Class.newInstance0(Native Method)
79:	>>	at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
78:	>>	at com.opencms.core.OpenCms.<init>(OpenCms.java:245)
77:	>>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
76:	>>	at com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
75:	>>	at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
74:	>>	at com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
73:	>>	at com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:76)
72:	>>	at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:304)
71:	>>	at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2784)
70:	>>	at com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1553)
69:	>>	at com.opencms.file.genericSql.CmsDbAccess.nextId(CmsDbAccess.java:4861)
68:	>>	at com.opencms.dbpool.CmsIdGenerator.nextId(CmsIdGenerator.java:104)
67:	>>	at com.opencms.dbpool.CmsIdGenerator.generateNextId(CmsIdGenerator.java:125)
66:	>>	at com.opencms.dbpool.CmsIdGenerator.readId(CmsIdGenerator.java:174)
65:	>>root cause was java.sql.SQLException: ORA-00942: table or view does not exist
64:	>>. 
63:	>>com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.dbpool.CmsIdGenerator]ORA-00942: table or view does not exist
62:	>>Root cause:
61:	>>-----------
60:	>	at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
59:	>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
58:	>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
57:	>	at java.lang.Class.newInstance(Class.java:232)
56:	>	at java.lang.Class.newInstance0(Native Method)
55:	>	at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
54:	>	at com.opencms.core.OpenCms.<init>(OpenCms.java:245)
53:	>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
52:	>root cause was java.sql.SQLException: ORA-00942: table or view does not exist
51:	>. 
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
49:	>com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker. 
48:	>Root cause:
47:	>-----------
46:		at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
45:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
44:		at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
43:		at java.lang.Class.newInstance(Class.java:232)
42:		at java.lang.Class.newInstance0(Native Method)
41:		at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
40:		at com.opencms.core.OpenCms.<init>(OpenCms.java:249)
39:	
38:	root cause was java.sql.SQLException: ORA-00942: table or view does not exist
37:	. 
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
35:	root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker. 
34:	com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Database init failed. 
33:	. Critical init error/3: com.opencms.core.CmsException: Critical error while loading resourcebroker
32:	[CmsRbManager] Critical error while loading resourcebroker


Any help would be appreciated.

Jack

---------------------------------------------
Jack M. Gibson II
Thought Leader - J2EE Architect
jack.gibson at brulant.com

Brulant, Inc.
216.518.7921 phone
330.328.5368 mobile
216.518.7991 fax
www.brulant.com
---------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041209/077f4f70/attachment.htm>

More information about the opencms-dev mailing list