Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-134693

SearchCTTest fails with HSQLDB: "org.hsqldb.HsqlException: data type cast needed for parameter or null literal"

    Details

      Description

      Steps:

      1. Edit portal-ext.properties
      2. Comment jdbc.default.url (so HSQLDB takes over as default database)
      3. Run the commands:
      cd modules/apps/change-tracking/change-tracking-test
      
      gw testIntegration --tests com.liferay.change.tracking.internal.search.test.SearchCTTest.testPublishAndUndoArticle
      

      Observed:

      com.liferay.change.tracking.internal.search.test.SearchCTTest > testPublishAndUndoArticle FAILED
          java.lang.AssertionError: {level=ERROR, loggerName=com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener, message=Unable to execute background task
          	at com.liferay.portal.test.rule.LogAssertionTestRule$LogAppender.append(LogAssertionTestRule.java:330)
          	at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:156)
          	at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:129)
          	at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:120)
          	at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:84)
          	at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:540)
          	at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:498)
          	at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:481)
          	at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:531)
          	at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:500)
          	at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:481)
          	at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:531)
          	at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:500)
          	at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:481)
          	at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:456)
          	at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:82)
          	at org.apache.logging.log4j.core.Logger.log(Logger.java:161)
          	at org.apache.logging.log4j.spi.AbstractLogger.tryLogMessage(AbstractLogger.java:2205)
          	at org.apache.logging.log4j.spi.AbstractLogger.logMessageTrackRecursion(AbstractLogger.java:2159)
          	at org.apache.logging.log4j.spi.AbstractLogger.logMessageSafely(AbstractLogger.java:2142)
          	at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:1994)
          	at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:1852)
          	at com.liferay.portal.log.Log4jLogImpl.error(Log4jLogImpl.java:58)
          	at com.liferay.portal.kernel.log.LogWrapper.error(LogWrapper.java:69)
          	at com.liferay.portal.log.LogContextLogWrapper.error(LogContextLogWrapper.java:61)
          	at com.liferay.portal.kernel.log.LogWrapper.error(LogWrapper.java:69)
          	at com.liferay.portal.kernel.log.SanitizerLogWrapper.error(SanitizerLogWrapper.java:114)
          	at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:182)
          	at com.liferay.portal.kernel.messaging.BaseMessageListener.doReceive(BaseMessageListener.java:48)
          	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:34)
          	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
          	at com.liferay.portal.kernel.test.rule.SynchronousDestinationTestRule$TestSynchronousDestination.send(SynchronousDestinationTestRule.java:444)
          	at com.liferay.portal.messaging.internal.DefaultMessageBus.sendMessage(DefaultMessageBus.java:265)
          	at com.liferay.portal.background.task.service.impl.BackgroundTaskLocalServiceImpl.triggerBackgroundTask(BackgroundTaskLocalServiceImpl.java:683)
          	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          	at java.lang.reflect.Method.invoke(Method.java:498)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
          	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
          	at com.sun.proxy.$Proxy631.triggerBackgroundTask(Unknown Source)
          	at com.liferay.portal.background.task.service.impl.BackgroundTaskLocalServiceImpl$3.call(BackgroundTaskLocalServiceImpl.java:746)
          	at com.liferay.portal.background.task.service.impl.BackgroundTaskLocalServiceImpl$3.call(BackgroundTaskLocalServiceImpl.java:742)
          	at com.liferay.portal.kernel.transaction.TransactionCommitCallbackUtil$1.doCommitted(TransactionCommitCallbackUtil.java:43)
          	at com.liferay.portal.kernel.transaction.NewTransactionLifecycleListener.committed(NewTransactionLifecycleListener.java:29)
          	at com.liferay.portal.kernel.transaction.TransactionLifecycleManager.fireTransactionCommittedEvent(TransactionLifecycleManager.java:34)
          	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:51)
          	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
          	at com.sun.proxy.$Proxy632.addCTProcess(Unknown Source)
          	at com.liferay.change.tracking.internal.search.test.SearchCTTest.testPublishAndUndoArticle(SearchCTTest.java:217)
          	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          	at java.lang.reflect.Method.invoke(Method.java:498)
          	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$3.evaluate(TestExecutorRunnable.java:353)
          	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
          	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
          	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$1.evaluate(TestExecutorRunnable.java:237)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
          	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
          	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:316)
          	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
          	at java.lang.Thread.run(Thread.java:748)
          Caused by: com.liferay.portal.kernel.dao.orm.ORMException: Unable to execute query: select DDMField.fieldId, ? from DDMField left join Company on DDMField.companyId = Company.companyId where Company.companyId is NULL and DDMField.companyId is not NULL and DDMField.companyId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? union select DDMField.fieldId, ? from DDMField left join DDMFieldAttribute layoutIdDDMFieldAttributeTable on layoutIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and layoutIdDDMFieldAttributeTable.attributeName = ? left join Layout on layoutIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(Layout.layoutId), ?) left join DDMFieldAttribute privateLayoutDDMFieldAttributeTable on privateLayoutDDMFieldAttributeTable.fieldId = DDMField.fieldId and privateLayoutDDMFieldAttributeTable.attributeName = ? and privateLayoutDDMFieldAttributeTable.smallAttributeValue = case when Layout.privateLayout = ? then ? else ? end left join DDMFieldAttribute groupIdDDMFieldAttributeTable on groupIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and groupIdDDMFieldAttributeTable.attributeName = ? and groupIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(Layout.groupId), ?) where Layout.plid is NULL and DDMField.fieldType = ? and DDMField.fieldId is not NULL and DDMField.fieldId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? and (Layout.ctCollectionId != ? or Layout.ctCollectionId != ? or Layout.plid is NULL) union select DDMField.fieldId, ? from DDMField left join DDMField aliasParentTable on DDMField.parentFieldId = aliasParentTable.fieldId where aliasParentTable.fieldId is NULL and DDMField.parentFieldId is not NULL and DDMField.parentFieldId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? and (aliasParentTable.ctCollectionId != ? or aliasParentTable.ctCollectionId != ? or aliasParentTable.fieldId is NULL) union select DDMField.fieldId, ? from DDMField left join DDMFieldAttribute groupIdDDMFieldAttributeTable on groupIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and groupIdDDMFieldAttributeTable.attributeName = ? left join DLFileEntry on groupIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(DLFileEntry.groupId), ?) left join DDMFieldAttribute fileEntryIdDDMFieldAttributeTable on fileEntryIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and fileEntryIdDDMFieldAttributeTable.attributeName = ? and fileEntryIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(DLFileEntry.fileEntryId), ?) where DLFileEntry.fileEntryId is NULL and DDMField.fieldType = ? and DDMField.fieldId is not NULL and DDMField.fieldId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? and (DLFileEntry.ctCollectionId != ? or DLFileEntry.ctCollectionId != ? or DLFileEntry.fileEntryId is NULL) union select DDMField.fieldId, ? from DDMField left join DDMFieldAttribute groupIdDDMFieldAttributeTable on groupIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and groupIdDDMFieldAttributeTable.attributeName = ? left join DLFileEntry on groupIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(DLFileEntry.groupId), ?) left join DDMFieldAttribute fileEntryIdDDMFieldAttributeTable on fileEntryIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and fileEntryIdDDMFieldAttributeTable.attributeName = ? and fileEntryIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(DLFileEntry.fileEntryId), ?) where DLFileEntry.fileEntryId is NULL and DDMField.fieldType = ? and DDMField.fieldId is not NULL and DDMField.fieldId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? and (DLFileEntry.ctCollectionId != ? or DLFileEntry.ctCollectionId != ? or DLFileEntry.fileEntryId is NULL) union select DDMField.fieldId, ? from DDMField left join DDMStructureVersion on DDMField.structureVersionId = DDMStructureVersion.structureVersionId where DDMStructureVersion.structureVersionId is NULL and DDMField.structureVersionId is not NULL and DDMField.structureVersionId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? and (DDMStructureVersion.ctCollectionId != ? or DDMStructureVersion.ctCollectionId != ? or DDMStructureVersion.structureVersionId is NULL) union select DDMField.fieldId, ? from DDMField left join DDMFieldAttribute classPKDDMFieldAttributeTable on classPKDDMFieldAttributeTable.fieldId = DDMField.fieldId and classPKDDMFieldAttributeTable.attributeName = ? left join JournalArticle on classPKDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(JournalArticle.resourcePrimKey), ?) left join DDMFieldAttribute classNameIdDDMFieldAttributeTable on classNameIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and classNameIdDDMFieldAttributeTable.attributeName = ? left join ClassName_ on classNameIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(ClassName_.classNameId), ?) and ClassName_.value = ? where JournalArticle.id_ is NULL and DDMField.fieldType = ? and DDMField.fieldId is not NULL and DDMField.fieldId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? and (JournalArticle.ctCollectionId != ? or JournalArticle.ctCollectionId != ? or JournalArticle.id_ is NULL) union select DDMField.fieldId, ? from DDMField left join DDMFieldAttribute classPKDDMFieldAttributeTable on classPKDDMFieldAttributeTable.fieldId = DDMField.fieldId and classPKDDMFieldAttributeTable.attributeName = ? left join JournalArticle on classPKDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(JournalArticle.resourcePrimKey), ?) left join DDMFieldAttribute classNameIdDDMFieldAttributeTable on classNameIdDDMFieldAttributeTable.fieldId = DDMField.fieldId and classNameIdDDMFieldAttributeTable.attributeName = ? left join ClassName_ on classNameIdDDMFieldAttributeTable.smallAttributeValue = CONCAT(?, CAST_TEXT(ClassName_.classNameId), ?) and ClassName_.value = ? where JournalArticle.id_ is NULL and DDMField.fieldType = ? and DDMField.fieldId is not NULL and DDMField.fieldId != ? and DDMField.fieldId in (?, ?, ?, ?) and DDMField.ctCollectionId = ? and (JournalArticle.ctCollectionId != ? or JournalArticle.ctCollectionId != ? or JournalArticle.id_ is NULL)
          	at com.liferay.change.tracking.internal.conflict.CTConflictChecker._checkMissingRequirements(CTConflictChecker.java:417)
          	at com.liferay.change.tracking.internal.conflict.CTConflictChecker._check(CTConflictChecker.java:154)
          	at com.liferay.dynamic.data.mapping.service.base.DDMFieldLocalServiceBaseImpl.updateWithUnsafeFunction(DDMFieldLocalServiceBaseImpl.java:423)
          	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          	at java.lang.reflect.Method.invoke(Method.java:498)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
          	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
          	at com.sun.proxy.$Proxy851.updateWithUnsafeFunction(Unknown Source)
          	at com.liferay.change.tracking.internal.conflict.CTConflictChecker.check(CTConflictChecker.java:110)
          	at com.liferay.change.tracking.service.impl.CTCollectionLocalServiceImpl.checkConflicts(CTCollectionLocalServiceImpl.java:196)
          	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          	at java.lang.reflect.Method.invoke(Method.java:498)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
          	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
          	at com.sun.proxy.$Proxy634.checkConflicts(Unknown Source)
          	at com.liferay.change.tracking.internal.background.task.CTPublishBackgroundTaskExecutor.execute(CTPublishBackgroundTaskExecutor.java:112)
          	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          	at java.lang.reflect.Method.invoke(Method.java:498)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
          	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80)
          	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
          	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
          	at com.sun.proxy.$Proxy677.execute(Unknown Source)
          	at com.liferay.portal.background.task.internal.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:63)
          	at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41)
          	at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72)
          	at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:136)
          	... 59 more
          Caused by: java.sql.SQLSyntaxErrorException: data type cast needed for parameter or null literal
          	at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:376)
          	at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:247)
          	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3888)
          	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:641)
          	at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:312)
          	at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
          	at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
          	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          	at java.lang.reflect.Method.invoke(Method.java:498)
          	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:385)
          	at com.sun.proxy.$Proxy24.prepareStatement(Unknown Source)
          	at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
          	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          	at java.lang.reflect.Method.invoke(Method.java:498)
          	at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74)
          	at com.sun.proxy.$Proxy325.prepareStatement(Unknown Source)
          	at com.liferay.change.tracking.internal.conflict.CTConflictChecker._getPreparedStatement(CTConflictChecker.java:635)
          	at com.liferay.change.tracking.internal.conflict.CTConflictChecker._checkMissingRequirements(CTConflictChecker.java:394)
          	... 99 more
          Caused by: org.hsqldb.HsqlException: data type cast needed for parameter or null literal
          	at org.hsqldb.error.Error.error(Error.java:136)
          	at org.hsqldb.error.Error.error(Error.java:106)
          	at org.hsqldb.ExpressionOp.resolveTypesForCaseWhen(ExpressionOp.java:652)
          	at org.hsqldb.ExpressionOp.resolveTypes(ExpressionOp.java:488)
          	at org.hsqldb.ExpressionLogical.resolveTypes(ExpressionLogical.java:648)
          	at org.hsqldb.ExpressionLogical.resolveTypes(ExpressionLogical.java:648)
          	at org.hsqldb.QuerySpecification.resolveExpressionTypes(QuerySpecification.java:962)
          	at org.hsqldb.QuerySpecification.resolveTypesPartOne(QuerySpecification.java:353)
          	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:434)
          	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:427)
          	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:427)
          	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:427)
          	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:427)
          	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:427)
          	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:427)
          	at org.hsqldb.QueryExpression.resolve(QueryExpression.java:217)
          	at org.hsqldb.ParserDQL.compileCursorSpecification(ParserDQL.java:6261)
          	at org.hsqldb.ParserCommand.compilePart(ParserCommand.java:147)
          	at org.hsqldb.ParserCommand.compileStatement(ParserCommand.java:64)
          	at org.hsqldb.Session.compileStatement(Session.java:933)
          	at org.hsqldb.StatementManager.compile(StatementManager.java:375)
          	at org.hsqldb.Session.execute(Session.java:1037)
          	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3885)
          	... 114 more
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.lee Brian Lee
              Reporter:
              andre.oliveira André Ricardo Barreto de Oliveira
              Participants of an Issue:
              Recent user:
              Rafaela Nascimento
              Engineering Assignee:
              Preston Crary
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                11 weeks, 3 days ago

                  Packages

                  Version Package
                  7.4.2 CE GA3 DXP 7,4
                  Master