Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
B B
Liferay 6.1 on Tomcat 7 with Oracle 11g
October 16, 2012 6:36 AM
Answer

B B

Rank: New Member

Posts: 8

Join Date: September 28, 2012

Recent Posts

Hi everyone,
I am trying to run Liferay 6.1 on Tomcat 7 with a new Oracle 11g database. Normally on a fresh install liferay cannot detect its tables in the DB and then creates them.
From my understanding Liferay should work with oracle 11g. I am using ojdbc6.jar.
I am getting the following error when Liferay attempts to automatically generate its tables in the DB

 121:43:02,741 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] ORA-00942: table or view does not exist
 2
 321:43:03,989 WARN  [pool-2-thread-1][ReleaseLocalServiceImpl:151] ORA-00942: table or view does not exist
 4
 521:43:03,990 INFO  [pool-2-thread-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
 621:43:15,395 INFO  [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
 721:43:15,986 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
 821:43:15,987 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
 921:43:16,037 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
1021:43:16,038 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
1121:43:16,038 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
1221:43:16,245 ERROR [pool-2-thread-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
13
14com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
15
16    at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
17    at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
18    at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
19    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
20    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
21    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
22    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
23    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
24    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
25    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
26    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
27    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
28    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
29    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
30    at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
31    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
32    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
33    at java.util.concurrent.FutureTask.run(Unknown Source)
34    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
35    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
36    at java.lang.Thread.run(Unknown Source)
37Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
38
39    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
40    at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
41    at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
42    at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
43    at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
44    at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
45    at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
46    at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
47    at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
48    at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
49    ... 20 more
50Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
51
52    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
53    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
54    at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
55    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
56    ... 29 more
57Caused by: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
58
59    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
60    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
61    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
62    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
63    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
64    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
65    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
66    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
67    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
68    at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
69    at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
70    at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
71    at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
72    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
73    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
74    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
75    at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
76    at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
77    at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
78    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
79    ... 32 more
80Stopping the server due to unexpected startup errors
László Csontos
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
October 16, 2012 11:55 AM
Answer

László Csontos

LIFERAY STAFF

Rank: New Member

Posts: 20

Join Date: June 15, 2012

Recent Posts

Hi,

Could you please attach your full log and portal-ext.properties?
Which Liferay version are your using?

Thanks,
Laszlo Csontos
B B
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
October 16, 2012 12:08 PM
Answer

B B

Rank: New Member

Posts: 8

Join Date: September 28, 2012

Recent Posts

Liferay version 6.1.20-ee-ga2

portal-ext.properties
1jdbc.default.url=jdbc\:oracle\:thin\:@localhost\:1521\:xe
2jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
3jdbc.default.username=NEWSERVER
4jdbc.default.password=NEWSERVER


Log
 114:23:24,556 INFO  [pool-2-thread-1][DialectDetector:71] Determine dialect for Oracle 11
 214:23:24,620 INFO  [pool-2-thread-1][DialectDetector:136] Found dialect org.hibernate.dialect.Oracle10gDialect
 314:23:51,215 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] ORA-00942: table or view does not exist
 4
 514:23:52,286 WARN  [pool-2-thread-1][ReleaseLocalServiceImpl:151] ORA-00942: table or view does not exist
 6
 714:23:52,287 INFO  [pool-2-thread-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
 814:24:12,297 INFO  [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
 914:24:12,896 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
1014:24:12,897 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
1114:24:12,920 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
1214:24:12,921 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
1314:24:12,921 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
1414:24:13,018 ERROR [pool-2-thread-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
15
16com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
17
18    at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
19    at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
20    at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
21    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
22    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
23    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
24    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
25    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
26    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
27    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
28    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
29    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
30    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
31    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
32    at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
33    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
34    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
35    at java.util.concurrent.FutureTask.run(Unknown Source)
36    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
37    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
38    at java.lang.Thread.run(Unknown Source)
39Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
40
41    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
42    at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
43    at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
44    at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
45    at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
46    at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
47    at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
48    at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
49    at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
50    at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
51    ... 20 more
52Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
53
54    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
55    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
56    at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
57    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
58    ... 29 more
59Caused by: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
60
61    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
62    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
63    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
64    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
65    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
66    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
67    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
68    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
69    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
70    at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
71    at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
72    at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
73    at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
74    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
75    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
76    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
77    at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
78    at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
79    at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
80    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
George Stafford
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
October 16, 2012 2:49 PM
Answer

George Stafford

Rank: Junior Member

Posts: 62

Join Date: October 1, 2012

Recent Posts

This happened to me today - it stemmed from the fact that I had other tables in the schema that Liferay tried to alter to fit it's schema. Try it with an empty Oracle schema..
B B
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
October 17, 2012 1:23 PM
Answer

B B

Rank: New Member

Posts: 8

Join Date: September 28, 2012

Recent Posts

This appears to have fixed my issue. Unfortunately I decided to just revert back to Oracle 10g.
pooja mahajan
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
June 19, 2013 5:03 AM
Answer

pooja mahajan

Rank: Junior Member

Posts: 45

Join Date: January 29, 2013

Recent Posts

Hi,
I am using Liferay 6.1.1 + jboss 7

Following are the entries in my portal-ext.properties :

dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
permissions.user.check.algorithm=6
########################################
# legacy 6.0 default properties
#######################################
verify.frequency=0
users.last.name.required=true
layout.types=portlet,panel,embedded,article,url,link_to_layout
editor.wysiwyg.portal-web.docroot.html.portlet.message_boards.edit_message.bb_code.jsp=bbcode
setup.wizard.enabled=false
discussion.subscribe.by.default=false
message.boards.subscribe.by.default=false
jdbc.default.jndi.name=java:jboss/jdbc/LiferayPool

and my eror log :


Unable to alter length of column FE_ID for table FORGOTPASWRD because it contains values that are larger than the new column length
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01723: zero-length columns are not allowed

and my FORGOTPASWRD contains :
FE_ID is varchar2
FE_ACTIVE varchar2(1)
George Stafford
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
June 19, 2013 6:50 AM
Answer

George Stafford

Rank: Junior Member

Posts: 62

Join Date: October 1, 2012

Recent Posts

Sounds like you had an aborted install or already have the schema? Try erasing the tables in the schema then starting liferay again.
pooja mahajan
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
July 9, 2013 11:05 PM
Answer

pooja mahajan

Rank: Junior Member

Posts: 45

Join Date: January 29, 2013

Recent Posts

Thanx,

I was trying to upgrade schema from LR5.2.3 to Liferay6.1.1
Vijay Gohil
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
August 1, 2014 12:29 PM
Answer

Vijay Gohil

Rank: New Member

Posts: 3

Join Date: September 7, 2010

Recent Posts

Hello Guys,

I am facing same issue which BB has faced. But in our requirement we need to use the DB which have already LR tables and with that LR tables we need to run plain tomcat with liferay bundle war file

Any help will appreciated..
Thanks,
Vijay