[
https://issues.apache.org/jira/browse/OFBIZ-12021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17206681#comment-17206681
]
Jacques Le Roux commented on OFBIZ-12021:
-----------------------------------------
Here is a list of the error found locally:
{noformat}
Unit Test Results.
Designed for use with JUnit and Ant.
All Errors
Class Name Status Type Time(s)
ecommercetests testSendOrderConfirmation Error assert
ServiceUtil.isSuccess(serviceResult) | | false ['errorMessage':'Service
exception; see logs', 'responseMessage':'error']
Assertion failed:
assert ServiceUtil.isSuccess(serviceResult)
| |
false ['errorMessage':'Service exception; see logs', 'responseMessage':'error']
at
org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415)
at
org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670)
at
org.apache.ofbiz.ecommerce.OrderNotificationTests.testSendOrderConfirmation(OrderNotificationTests.groovy:37)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
2.376
entitytests testStoreByCondition Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID,
DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons
between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must
be comparable. String types must also have matching collation. If collation
does not match, a possible solution is to cast operands to force them to the
default collation (e.g. SELECT tablename FROM sys.systables WHERE
CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the
following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID,
DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons
between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must
be comparable. String types must also have matching collation. If collation
does not match, a possible solution is to cast operands to force them to the
default collation (e.g. SELECT tablename FROM sys.systables WHERE
CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the
following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468)
at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397)
at
org.apache.ofbiz.entity.test.EntityTestSuite.testStoreByCondition(EntityTestSuite.java:655)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID,
DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons
between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must
be comparable. String types must also have matching collation. If collation
does not match, a possible solution is to cast operands to force them to the
default collation (e.g. SELECT tablename FROM sys.systables WHERE
CAST(tablename AS VARCHAR(128)) = 'T1'))
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown
Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.020
entitytests testEntityCache Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT
TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?)
(Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT
TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?)
(Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468)
at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397)
at
org.apache.ofbiz.entity.test.EntityTestSuite.testEntityCache(EntityTestSuite.java:244)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1'))
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown
Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.058
entitytests testFindDistinct Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM
OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between
'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT
DISTINCT TESTING_SIZE, COMMENTS FROM OFBIZ.TESTING WHERE ((COMMENTS = ? AND
TESTING_SIZE = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM
OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between
'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT
DISTINCT TESTING_SIZE, COMMENTS FROM OFBIZ.TESTING WHERE ((COMMENTS = ? AND
TESTING_SIZE = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468)
at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397)
at
org.apache.ofbiz.entity.test.EntityTestSuite.testFindDistinct(EntityTestSuite.java:528)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM
OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between
'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1'))
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown
Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.019
entitytests testCryptoSubSelect Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID
ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception
while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID
ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID
ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception
while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID
ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468)
at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397)
at
org.apache.ofbiz.entity.test.EntityCryptoTestSuite.testCryptoSubSelect(EntityCryptoTestSuite.java:196)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID
ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown
Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.107
entitytests testCryptoLookup Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID =
?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception
while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID =
?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID =
?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception
while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID =
?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468)
at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397)
at
org.apache.ofbiz.entity.test.EntityCryptoTestSuite.testCryptoLookup(EntityCryptoTestSuite.java:145)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID,
UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID =
?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown
Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.014
entitytests testOrderBy Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC
(Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY,
UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not
supported for that type.) (SQL Exception while executing the following:SELECT
TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID
LIKE ?) ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC
(Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY,
UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not
supported for that type.) (SQL Exception while executing the following:SELECT
TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID
LIKE ?) ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616)
at
org.apache.ofbiz.entity.test.EntityQueryTestSuite.testOrderBy(EntityQueryTestSuite.java:250)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC
(Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY,
UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not
supported for that type.)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX,
ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.006
entitytests testWhere Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC
(Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC
(Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC
(Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC
(Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616)
at
org.apache.ofbiz.entity.test.EntityQueryTestSuite.testWhere(EntityQueryTestSuite.java:77)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC
(Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not
supported. Types must be comparable. String types must also have matching
collation. If collation does not match, a possible solution is to cast operands
to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB
(UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown
Source)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown
Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.005
entitytests testQueryList Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616)
at
org.apache.ofbiz.entity.test.EntityQueryTestSuite.testQueryList(EntityQueryTestSuite.java:104)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX,
ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.005
entitytests testFetchSize Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616)
at
org.apache.ofbiz.entity.test.EntityQueryTestSuite.testFetchSize(EntityQueryTestSuite.java:352)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX,
ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.004
entitytests testMaxRows Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.) (SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616)
at
org.apache.ofbiz.entity.test.EntityQueryTestSuite.testMaxRows(EntityQueryTestSuite.java:326)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX,
ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.003
entitytests testDistinctAndSelect Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.) (SQL Exception while
executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.) (SQL Exception while
executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616)
at
org.apache.ofbiz.entity.test.EntityQueryTestSuite.testDistinctAndSelect(EntityQueryTestSuite.java:224)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT DISTINCT DESCRIPTION FROM
OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be
used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX,
ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.005
entitytests testSelect Error
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY
DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER
BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.) (SQL Exception while executing
the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION
ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP
BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not
supported for that type.))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY
DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER
BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.) (SQL Exception while executing
the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION
ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP
BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not
supported for that type.))
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616)
at
org.apache.ofbiz.entity.test.EntityQueryTestSuite.testSelect(EntityQueryTestSuite.java:197)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER
BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX,
ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419)
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806)
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157)
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600)
at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648)
Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in
CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT
statements because comparisons are not supported for that type.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401)
Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX,
ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because
comparisons are not supported for that type.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown
Source)
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
0.005
invoicetests testGlPostingOnCancelCheckRun Error assert
ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception
thrown while performing entity find: Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
Assertion failed:
assert ServiceUtil.isSuccess(serviceResult)
| |
false ['errorMessageList':['Exception thrown while performing entity find:
Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
at
org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415)
at
org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670)
at
org.apache.ofbiz.accounting.AutoInvoiceTests.testGlPostingOnCancelCheckRun(AutoInvoiceTests.groovy:258)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
0.056
invoicetests testGlPostingOnCancelInvoice Error assert
ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception
thrown while performing entity find: Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
Assertion failed:
assert ServiceUtil.isSuccess(serviceResult)
| |
false ['errorMessageList':['Exception thrown while performing entity find:
Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
at
org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415)
at
org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670)
at
org.apache.ofbiz.accounting.AutoInvoiceTests.testGlPostingOnCancelInvoice(AutoInvoiceTests.groovy:186)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
0.010
paymenttests testGlPostingsOnVoidPayment Error assert
ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception
thrown while performing entity find: Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
Assertion failed:
assert ServiceUtil.isSuccess(serviceResult)
| |
false ['errorMessageList':['Exception thrown while performing entity find:
Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
at
org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415)
at
org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670)
at
org.apache.ofbiz.accounting.AutoPaymentTests.testGlPostingsOnVoidPayment(AutoPaymentTests.groovy:355)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
0.564
paymenttests testGlPostingOnCheckRun Error assert
ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception
thrown while performing entity find: Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
Assertion failed:
assert ServiceUtil.isSuccess(serviceResult)
| |
false ['errorMessageList':['Exception thrown while performing entity find:
Error doing find by condition:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID,
ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE,
ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID,
ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID,
ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID,
ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID,
ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT,
ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID,
ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE,
GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT DISTINCT
ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID,
ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID,
ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID,
ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID,
ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID,
ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID,
ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT,
ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID,
GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID,
ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM
(((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON
ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT
ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN
OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID =
GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND
ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type
\'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.))'], 'responseMessage':'error']
at
org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415)
at
org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670)
at
org.apache.ofbiz.accounting.AutoPaymentTests.testGlPostingOnCheckRun(AutoPaymentTests.groovy:432)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
0.021
{noformat}
And a list of the failures:
{noformat}
Unit Test Results.
Designed for use with JUnit and Ant.
All Failures
Class Name Status Type Time(s)
partytests party-tests-0.testFindPartyWithSearchParameters Failure Error
looking up RoleTypes: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE,
DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type
'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID,
PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.))
junit.framework.AssertionFailedError: Error looking up RoleTypes:
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE,
DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type
'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID,
PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.))
at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
0.098
partytests party-tests-0.testFindPartyWithNoSearchParameters Failure
Error looking up RoleTypes: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE,
DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type
'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID,
PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.))
junit.framework.AssertionFailedError: Error looking up RoleTypes:
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE,
DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type
'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,
EXCEPT or DISTINCT statements because comparisons are not supported for that
type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID,
PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE
ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE
INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements
because comparisons are not supported for that type.))
at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
0.003
scrumtests product-tests.testAddProductTimeToNewInvoice Failure ERROR:
Could not complete the add all reported time on all completed timesheets from
all workefforts for a product
[file:/C:/projectsASF/Git/ofbiz-framework/plugins/scrum/minilang/ScrumServices.xml#addProductTimeToNewInvoice]
process [problem invoking the [scrumAddWorkEffortTimeToInvoice] service with
the map named [addTaskToInvoice] containing [{workEffortId=DEMO-TASK-4,
userLogin=[GenericEntity:UserLogin][createdStamp,2020-10-03
12:51:58.833(java.sql.Timestamp)][createdTxStamp,2020-10-03
12:51:58.523(java.sql.Timestamp)][currentPassword,null()][disabledBy,null()][disabledDateTime,null()][enabled,N(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,Y(java.lang.String)][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2020-10-03
12:52:03.31(java.sql.Timestamp)][lastUpdatedTxStamp,2020-10-03
12:52:03.094(java.sql.Timestamp)][partyId,system(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,system(java.lang.String)],
invoiceId=CI1, combineInvoiceItem=Y, locale=en, thruDate=2010-11-01
00:00:00.0}]: Service [scrumAddWorkEffortTimeToInvoice] Failed (null)]
junit.framework.AssertionFailedError: ERROR: Could not complete the add all
reported time on all completed timesheets from all workefforts for a product
[file:/C:/projectsASF/Git/ofbiz-framework/plugins/scrum/minilang/ScrumServices.xml#addProductTimeToNewInvoice]
process [problem invoking the [scrumAddWorkEffortTimeToInvoice] service with
the map named [addTaskToInvoice] containing [{workEffortId=DEMO-TASK-4,
userLogin=[GenericEntity:UserLogin][createdStamp,2020-10-03
12:51:58.833(java.sql.Timestamp)][createdTxStamp,2020-10-03
12:51:58.523(java.sql.Timestamp)][currentPassword,null()][disabledBy,null()][disabledDateTime,null()][enabled,N(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,Y(java.lang.String)][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2020-10-03
12:52:03.31(java.sql.Timestamp)][lastUpdatedTxStamp,2020-10-03
12:52:03.094(java.sql.Timestamp)][partyId,system(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,system(java.lang.String)],
invoiceId=CI1, combineInvoiceItem=Y, locale=en, thruDate=2010-11-01
00:00:00.0}]: Service [scrumAddWorkEffortTimeToInvoice] Failed (null)]
at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
Exception thrown while performing entity find: Error doing find by and:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID,
INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, OVERRIDE_ORG_PARTY_ID,
INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, PARENT_INVOICE_ID,
PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY, AMOUNT,
DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_AUTHORITY_RATE_SEQ_ID,
SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM WHERE ((AMOUNT IS NULL AND DESCRIPTION
= ? AND INVOICE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))
(SQL Exception while executing the following:SELECT INVOICE_ID,
INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID,
OVERRIDE_ORG_PARTY_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID,
PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY,
AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID,
TAX_AUTHORITY_RATE_SEQ_ID, SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM
WHERE ((AMOUNT IS NULL AND DESCRIPTION = ? AND INVOICE_ID = ?)) (Comparisons
between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must
be comparable. String types must also have matching collation. If collation
does not match, a possible solution is to cast operands to force them to the
default collation (e.g. SELECT tablename FROM sys.systables WHERE
CAST(tablename AS VARCHAR(128)) = 'T1')))
junit.framework.AssertionFailedError: Exception thrown while performing entity
find: Error doing find by and:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID,
INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, OVERRIDE_ORG_PARTY_ID,
INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, PARENT_INVOICE_ID,
PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY, AMOUNT,
DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_AUTHORITY_RATE_SEQ_ID,
SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM WHERE ((AMOUNT IS NULL AND DESCRIPTION
= ? AND INVOICE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB
(UCS_BASIC)' are not supported. Types must be comparable. String types must
also have matching collation. If collation does not match, a possible solution
is to cast operands to force them to the default collation (e.g. SELECT
tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))
(SQL Exception while executing the following:SELECT INVOICE_ID,
INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID,
OVERRIDE_ORG_PARTY_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID,
PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY,
AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID,
TAX_AUTHORITY_RATE_SEQ_ID, SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM
WHERE ((AMOUNT IS NULL AND DESCRIPTION = ? AND INVOICE_ID = ?)) (Comparisons
between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must
be comparable. String types must also have matching collation. If collation
does not match, a possible solution is to cast operands to force them to the
default collation (e.g. SELECT tablename FROM sys.systables WHERE
CAST(tablename AS VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
1.222
workefforttests workeffort-tests.testCreateTimesheets Failure Exception
thrown while performing entity find:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID,
FROM_DATE, THRU_DATE, STATUS_ID, APPROVED_BY_USER_LOGIN_ID, COMMENTS,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND PARTY_ID = ?)) (Comparisons between
'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT
TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID, FROM_DATE, THRU_DATE, STATUS_ID,
APPROVED_BY_USER_LOGIN_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND
PARTY_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)'
are not supported. Types must be comparable. String types must also have
matching collation. If collation does not match, a possible solution is to cast
operands to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
junit.framework.AssertionFailedError: Exception thrown while performing entity
find: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID,
FROM_DATE, THRU_DATE, STATUS_ID, APPROVED_BY_USER_LOGIN_ID, COMMENTS,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND PARTY_ID = ?)) (Comparisons between
'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be
comparable. String types must also have matching collation. If collation does
not match, a possible solution is to cast operands to force them to the default
collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS
VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT
TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID, FROM_DATE, THRU_DATE, STATUS_ID,
APPROVED_BY_USER_LOGIN_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND
PARTY_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)'
are not supported. Types must be comparable. String types must also have
matching collation. If collation does not match, a possible solution is to cast
operands to force them to the default collation (e.g. SELECT tablename FROM
sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')))
at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96)
at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90)
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77)
at
org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146)
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70)
at org.apache.ofbiz.base.start.Start.main(Start.java:89)
{noformat}
> "description" and "comment" datatypes unnecessarily limited to 255 char
> ------------------------------------------------------------------------
>
> Key: OFBIZ-12021
> URL: https://issues.apache.org/jira/browse/OFBIZ-12021
> Project: OFBiz
> Issue Type: Improvement
> Components: datamodel, framework/entity
> Reporter: ddev
> Priority: Minor
> Fix For: Upcoming Branch
>
> Attachments: documentation-first-draft.diff, field-types-v2.diff
>
> Original Estimate: 10m
> Remaining Estimate: 10m
>
> "description" and "comment" fields are restricted to 255 char. However after
> some research I found that all the supported databases support longer then
> 255 char
> I would expect users to want to write more then 255 char in a comment (I know
> I personally can).
> I have included diff of my proposed solution as a attachment (I am
> unfamiliar with the procedures for submitting patches here)
> A discussion has been started on dev ML:
> https://markmail.org/message/7utrgejc2c44i37u
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
