Error Message

In Clearwell GUI.  Image below is seen after clicking the Save button from within New Case creation:

From server log file:
 

ERROR [ui.servlet.ErrorMap] (https-jsse-nio2-443-exec-11-ADCZ26P:[]) CaseName:[] UserName:[ADCZ26P-842798489] Unexpected error: com.teneo.esa.esacase.CaseManagerException com.teneo.esa.ui.util.Error: [#80114] An unexpected error occurred . . Caused by: com.teneo.esa.common.exception.TeneoRuntimeException: [#156021] Unexpected error . Caused by: com.teneo.esa.common.exception.TeneoRuntimeException: [#80007] Unexpected exception encountered: creating databse: esadb_wwokpavclw03_lds_case_af8rctafow . Caused by: java.sql.BatchUpdateException: Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50643, now running 50735. Please use mysql_upgrade to fix this error.

This issue is not version specific and is an issue with MySQL databases.  When MySQL databases are not fully upgraded, MySQL will not allow any new databases to be created until the upgrade has been completed.  The error says to use mysql_upgrade to resolve the issue.
 

1) Stop Clearwell services on all appliance nodes so that no processes are accessing the MySQL server and databases. 

2) On the MySQL database server run the following command at the command prompt

mysql_upgrade -uroot -p

Type in the password, hit enter and let it run until completion.

3) Start Clearwell services and then try to create a new case to see if this action is now working as expected.

WARNING:  This issue can lead into another issue mentioned in the following technote 100052974.  Check for this next.