Unable to connect with MYSQL database.

Unable to connect with MYSQL database.

Error:


Unknown character set index for field '255' received from server. (or)
Unknown initial character set index '255' received from server.

Note:
  1. This is not specific to any build of Zoho Analytics Onpremise.
  2. This fix is for MYSQL version 8 and below.

Analysis:
The customer's MySQL version to be higher than the version which is in our product.

Solution:
  1. Stop the Zoho Analytics Server service.
  2. Move the <Zoho Home>/Analytics/lib/mysql_connector.jar to <Zoho Home>/Analytics/Backup/
  3. Download the latest MySQL jar from this link.
  4. Extract it and rename mysql-connector-java-8.0.17.jar to mysql_connector.jar.
  5. Move the renamed jar file to  <Zoho Home>/Analytics/lib/ folder.
  6. Start the service.
If the above still does not fix the issue and throws below error, check the log for the mentioned trace.


Log traces:

  2. [14:00:11:936]|[11-26-2019]|[SYSERR]|[INFO]|[91]: 
  3. ERROROCCURED,'3470D4D513AC92FAA6AC922C4BAD16E8',54,'TESTANDFETCHTABLES',500,1574730011000,-1,'COMMON_INTERNAL_SERVER_ERROR',108,'','','','An unexpected error occurred while performing this operation.','https://l-adrien:8443/ZRCloudDBAction.ma','-','172.30.10.216','169.254.26.169_sas','-Not Provided-','ClassNotFoundException:org.gjt.mm.mysql.Driver at URLClassLoader.findClass(LN:381) at ClassLoader.loadClass(LN:424) at ClassLoader.loadClass(LN:357) at Class.forName0(LN:-2) at Class.forName(LN:264) at DirectDBConnection.getDBConnection(LN:34) at DirectDBConnection.<init>(LN:30) at ZRCloudDBAPI.getDBConnection(LN:3007) at ZRCloudDBAPI.getConnection(LN:1313) at ZRCloudDBAPI.getConnection(LN:1254) at ZRCloudDBAPI.getCloudDBTableNamesAsList(LN:1742) at ZRCloudDBAction.getTablesFromCloudDB(LN:291) at ZRCloudDBAction.execute(LN:89)','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36'
Analysis:
The classpath used is not present in the latest mysql_connector.jar. 

Solution:
  1. Stop the Zoho Analytics Onpremise service.
  2. Replace this file (dbtypes.json) under <Zoho Home>/Analytics/conf/ZohoDB/ 
  3. Start the service.
Note: 
  1. This fix can be used for Zoho Analytics Onpremise version 4300 and below.

    • Related Articles

    • How to connect to Zoho Analytics database

      This article will help you with the steps to connect to Analytics Plus database(Postgres) Note: Analytics Plus is bundled with Postgres and it cannot be changed to any other database due to reliability and chart rendering. Steps for Windows: 1. Open ...

    • Unable to Integrate with Jira

      Issue: The authentication fails while we try to integrate with the Jira Error trace: #ERROR: Unable to obtain request token. Please check Jira Server Url and application link created properly and try again.]','ZDBException:JIRA_RT_ERR at ...

    • I get this error - 'Sorry, problem in connecting to your database server.' How do I overcome this?

      This error occurs in the following scenario: Incorrect connection settings are specified - Ensure that the correct Endpoint, Port and user credentials are specified.  Your cloud database service does not recognise Zoho Reports as an authenticated ...

    • Why am I unable to add a Google My Business listing on Zoho Social?

      Only a verified business listing can be added to Zoho Social. If you're unable to connect a business listing please make sure you have completed the verification process, or contact the account owner to verify this listing.

    • Why am I unable to connect a Facebook Group managed by my Facebook Page?

      You can connect a Facebook Group if yourFacebook account is an admin of the Page. That's why you may not see the group when you try to connect it to Zoho Social. This is due to API restrictions you can only connect Facebook Groups that are managed by ...