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


Solutions on the web38

Solution icon of web
via liferay.com by Unknown author, 9 months ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns are not allowed

Solution icon of liferay
via Liferay Issues by Victor de Lima Soares, 3 months ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: Table 'XXXXX.EVENTS' doesn't exist

Solution icon of web
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalArticle#ADD_DISCUSSION

Solution icon of web
via liferay.com by Unknown author, 1 year ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE

Solution icon of web
via liferay.com by Unknown author, 1 year ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: org.hibernate.exception.SQLGrammarException: could not execute query

Solution icon of liferay
via Liferay Issues by Dennis Greiffenberg , 1 year ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalArticle#ADD_DISCUSSION

Solution icon of web
via liferay.com by Unknown author, 1 year ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE

Solution icon of web
via liferay.com by Unknown author, 1 year ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE

Solution icon of web
via liferay.com by Unknown author, 4 months ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE

Solution icon of web
via liferay.com by Unknown author, 1 year ago
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE

Stack trace

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)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 1 month ago
Once, 6 months ago
3 times, 8 months ago
Once, 9 months ago
70 more bugmates