Hi,

Currently, we are testing a live application to migrate from V8.2 to V8.3 in new server. We are also migrating database from MySql v5.5 to MySQL v8.0.

We are getting following bugs in Awareim :
1)
Rule :
IF Asset.ob_Customer.NumberOfVehicles IS UNDEFINED OR Asset.AssetType WAS CHANGED TO 'Motor Vehicle' OR OLD_VALUE(Asset.AssetType) ='Motor Vehicle' Then
FIND Customer WHERE Customer IN Asset.ob_Customer
Customer.NumberOfVehicles = COUNT Asset WHERE (Asset IN Customer.om_Asset AND Asset.AssetType = 'Motor Vehicle')

Error log :
com.bas.shared.domain.operation.BuildQueryException: Unable to convert query condition OLD_VALUE(Asset.AssetType)='Motor Vehicle' in query FIND Asset WHERE OLD_VALUE(Asset.AssetType)='Motor Vehicle' to SQL
at com.bas.shared.domain.operation.SQLQueryStringBuilder.handlePredicate(SQLQueryStringBuilder.java:1643)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.handleQueryCondition(SQLQueryStringBuilder.java:825)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.buildSelectString(SQLQueryStringBuilder.java:589)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.buildQueryString(SQLQueryStringBuilder.java:395)
at com.bas.basserver.persistence.EntityDBPersister.buildQueryString(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.A(Unknown Source)

Error logs:
com.bas.shared.domain.operation.BuildQueryException: Undefined expression for list AStage.om_Tasks is not supported. Try to use COUNT expression instead
at com.bas.shared.domain.operation.SQLQueryStringBuilder.getUndefinedStringForList(SQLQueryStringBuilder.java:1936)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.getUndefinedString(SQLQueryStringBuilder.java:1867)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.access$7(SQLQueryStringBuilder.java:1836)
at com.bas.shared.domain.operation.SQLQueryStringBuilder$SQLHelper.getUndefinedExpression(SQLQueryStringBuilder.java:2635)
at com.bas.shared.ruleparser.ASTIsDefinedExpr.toSQL(ASTIsDefinedExpr.java:191)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.handlePredicate(SQLQueryStringBuilder.java:1618-)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.handleQueryCondition(SQLQueryStringBuilder.java:825)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.buildSelectString(SQLQueryStringBuilder.java:589)
at com.bas.shared.domain.operation.SQLQueryStringBuilder.buildQueryString(SQLQueryStringBuilder.java:395)
at com.bas.basserver.persistence.EntityDBPersister.buildQueryString(Unknown Source)

Can someone please confirm if these are known issues or bugs in AwareIm? If these are not bugs, how can this be fixed?

Thanks!