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

liferay.com | 2 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Apply patch in liferay

    Stack Overflow | 3 years ago | Sai Gowthami
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-24005: Inappropriate utilities used to perform DDL on AQ table SYSMAN.AQ$_MGMT_LOADER_QTABLE_G
  2. 0

    Liferay: Migration from 6.0 to 6.1

    Stack Overflow | 2 years ago | June Sulaiman
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portlet.documentlibrary.NoSuchFileException: C:\barterfli\liferay_6.1.2\data\document_library\10112\128975\23\00\23005.afsh\23005_1.0.afsh
  3. 0

    Liferay 6.2+jboss-eap-6.2.3+db2 as400 ERROR!! - Forums | Liferay

    liferay.com | 11 months ago
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issue while upgrading from Liferay 6.0.1 to 6.1 - Forums | Liferay

    liferay.com | 2 years ago
    com.liferay.portal.kernel.events.ActionException: java.sql.SQLSyntaxErrorException: ORA-00904: "STATE_": invalid identifier_ 12:14:07,370 INFO (MSC service thread 1-3) at com.liferay.portal.events.StartupAction.run(StartupAction.java:74)

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-01723: zero-length columns are not allowed

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.executeUpdate
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
      8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
      10. oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
      11. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
      12. oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
      12 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyStatement.executeUpdate
      1. com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
      1 frame
    4. Liferay Portal Impl
      StartupAction.doRun
      1. com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
      2. com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
      3. com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
      4. com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
      5. com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
      6. com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
      7. com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
      8. com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
      9. com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
      10. com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
      11. com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      12. com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      13. com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      14. com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
      15. com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
      16. com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
      17. com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
      17 frames
    5. com.liferay.portal
      StartupAction.doRun
      1. com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
      1 frame
    6. Liferay Portal Impl
      MainServlet.init
      1. com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
      2. com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
      3. com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
      3 frames
    7. JavaServlet
      GenericServlet.init
      1. javax.servlet.GenericServlet.init(GenericServlet.java:160)
      1 frame
    8. Glassfish Core
      HostConfig$DeployDescriptor.run
      1. org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
      2. org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
      3. org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
      4. org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
      5. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
      6. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      7. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
      8. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
      9. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
      10. org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
      11. org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
      11 frames
    9. Java RT
      Thread.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      2. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      3. java.util.concurrent.FutureTask.run(Unknown Source)
      4. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      5. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      6. java.lang.Thread.run(Unknown Source)
      6 frames