Foren
Liferay 6.1 on Tomcat 7 with Oracle 11g
B B, geändert vor 11 Jahren.
Liferay 6.1 on Tomcat 7 with Oracle 11g
New Member Beiträge: 7 Beitrittsdatum: 28.09.12 Neueste Beiträge
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
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
21:43:02,741 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] ORA-00942: table or view does not exist
21:43:03,989 WARN [pool-2-thread-1][ReleaseLocalServiceImpl:151] ORA-00942: table or view does not exist
21:43:03,990 INFO [pool-2-thread-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
21:43:15,395 INFO [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
21:43:15,986 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
21:43:15,987 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
21:43:16,037 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
21:43:16,038 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
21:43:16,038 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
21: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
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
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
... 29 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
... 32 more
Stopping the server due to unexpected startup errors
László Csontos, geändert vor 11 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
New Member Beiträge: 20 Beitrittsdatum: 15.06.12 Neueste Beiträge
Hi,
Could you please attach your full log and portal-ext.properties?
Which Liferay version are your using?
Thanks,
Laszlo Csontos
Could you please attach your full log and portal-ext.properties?
Which Liferay version are your using?
Thanks,
Laszlo Csontos
B B, geändert vor 11 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
New Member Beiträge: 7 Beitrittsdatum: 28.09.12 Neueste Beiträge
Liferay version 6.1.20-ee-ga2
portal-ext.properties
Log
portal-ext.properties
jdbc.default.url=jdbc\:oracle\:thin\:@localhost\:1521\:xe
jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.username=NEWSERVER
jdbc.default.password=NEWSERVER
Log
14:23:24,556 INFO [pool-2-thread-1][DialectDetector:71] Determine dialect for Oracle 11
14:23:24,620 INFO [pool-2-thread-1][DialectDetector:136] Found dialect org.hibernate.dialect.Oracle10gDialect
14:23:51,215 ERROR [pool-2-thread-1][JDBCExceptionReporter:76] ORA-00942: table or view does not exist
14:23:52,286 WARN [pool-2-thread-1][ReleaseLocalServiceImpl:151] ORA-00942: table or view does not exist
14:23:52,287 INFO [pool-2-thread-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
14:24:12,297 INFO [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
14:24:12,896 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
14:24:12,897 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
14:24:12,920 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
14:24:12,921 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
14:24:12,921 INFO [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
14: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
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
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
... 29 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
George Stafford, geändert vor 11 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
Junior Member Beiträge: 62 Beitrittsdatum: 01.10.12 Neueste Beiträge
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, geändert vor 11 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
New Member Beiträge: 7 Beitrittsdatum: 28.09.12 Neueste Beiträge
This appears to have fixed my issue. Unfortunately I decided to just revert back to Oracle 10g.
pooja mahajan, geändert vor 10 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
Junior Member Beiträge: 45 Beitrittsdatum: 30.01.13 Neueste Beiträge
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)
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, geändert vor 10 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
Junior Member Beiträge: 62 Beitrittsdatum: 01.10.12 Neueste Beiträge
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, geändert vor 10 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
Junior Member Beiträge: 45 Beitrittsdatum: 30.01.13 Neueste Beiträge
Thanx,
I was trying to upgrade schema from LR5.2.3 to Liferay6.1.1
I was trying to upgrade schema from LR5.2.3 to Liferay6.1.1
Vijay Gohil, geändert vor 9 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
New Member Beiträge: 3 Beitrittsdatum: 07.09.10 Neueste Beiträge
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
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
Pietro Santoro, geändert vor 9 Jahren.
RE: Liferay 6.1 on Tomcat 7 with Oracle 11g
New Member Beitrag: 1 Beitrittsdatum: 28.07.10 Neueste Beiträge
If you see the source of com.liferay.portal.verify.VerifyOracle, there are lines:
******************************
ps = con.prepareStatement(
"select table_name, column_name, data_length from " +
"user_tab_columns where data_type = 'VARCHAR2' and " +
"char_used = 'B'");
rs = ps.executeQuery();
while (rs.next()) {
String tableName = rs.getString(1);
String columnName = rs.getString(2);
int dataLength = rs.getInt(3);
if ((buildNumber >= ReleaseInfo.RELEASE_5_2_9_BUILD_NUMBER) &&
(buildNumber < ReleaseInfo.RELEASE_6_1_20_BUILD_NUMBER)) {
if (dataLength != 4000) {
dataLength = dataLength / 4;
}
}
try {
runSQL(
"alter table " + tableName + " modify " + columnName +
" varchar2(" + dataLength + " char)");
}
catch (SQLException sqle) {
if (sqle.getErrorCode() == 1441) {
if (_log.isWarnEnabled()) {
StringBundler sb = new StringBundler(6);
sb.append("Unable to alter length of column ");
omit...
******************************
Therefore, verification process is an "alter column" on all columns varchar2(byte) with dataLength different from 4000 dividing them by 4 ... For columns with less than 4 bytes, the new width would be 0. This generate exception "ORA-01723: zero-length columns are not allowed".
What is this change over?
I am migrating from 6.0.6 to 6.1.1...
******************************
ps = con.prepareStatement(
"select table_name, column_name, data_length from " +
"user_tab_columns where data_type = 'VARCHAR2' and " +
"char_used = 'B'");
rs = ps.executeQuery();
while (rs.next()) {
String tableName = rs.getString(1);
String columnName = rs.getString(2);
int dataLength = rs.getInt(3);
if ((buildNumber >= ReleaseInfo.RELEASE_5_2_9_BUILD_NUMBER) &&
(buildNumber < ReleaseInfo.RELEASE_6_1_20_BUILD_NUMBER)) {
if (dataLength != 4000) {
dataLength = dataLength / 4;
}
}
try {
runSQL(
"alter table " + tableName + " modify " + columnName +
" varchar2(" + dataLength + " char)");
}
catch (SQLException sqle) {
if (sqle.getErrorCode() == 1441) {
if (_log.isWarnEnabled()) {
StringBundler sb = new StringBundler(6);
sb.append("Unable to alter length of column ");
omit...
******************************
Therefore, verification process is an "alter column" on all columns varchar2(byte) with dataLength different from 4000 dividing them by 4 ... For columns with less than 4 bytes, the new width would be 0. This generate exception "ORA-01723: zero-length columns are not allowed".
What is this change over?
I am migrating from 6.0.6 to 6.1.1...