Details
-
Type:
Bug
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Galileo
-
Component/s: Reseller UI
-
Labels:None
-
Environment:
Reseller UI - aml-ui-reseller-gwt-2.9.1-RC4.war
Merchant UI - aml-ui-merchant-gwt-2.9.1-RC1.war
Distribution - aml-distribution-service-war-1.0.1-RC2.war
Data Tool - aml-data-tool-2.9.1.jar
SAPI - aml-sapi-2.9.0-RC3.war
Bid Manager - bidmgr-distribution-2.9.2-RC3-bin.tar.gz
Core - smb-ear-2.9.1-RC2.ear
Ops Scripts - ops-scripts-3.0.0-RC3-bin.zipReseller UI - aml-ui-reseller-gwt-2.9.1-RC4.war Merchant UI - aml-ui-merchant-gwt-2.9.1-RC1.war Distribution - aml-distribution-service-war-1.0.1-RC2.war Data Tool - aml-data-tool-2.9.1.jar SAPI - aml-sapi-2.9.0-RC3.war Bid Manager - bidmgr-distribution-2.9.2-RC3-bin.tar.gz Core - smb-ear-2.9.1-RC2.ear Ops Scripts - ops-scripts-3.0.0-RC3-bin.zip
Description
Exceptions are observed while running produce-error-report-from-orders.groovy .
Steps
1. Go to the momman server (/home/amlops/groovy) and run the below groovy script .
groovy produce-error-report-from-orders.groovy -e qa2 -h aq-qa2-mysql1 -uspike -p tar63t -o /tmp/
Expected Behavior
It should create csv(content-rejections.csv) for all the rejected contents.
Actual Behavior
Exceptions are observed in the log.
because: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
Caught: java.sql.SQLException: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
java.sql.SQLException: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
Note
Kindly find the attached log.
