MariaDB connection established, but schema is not expanding in metadata

Technical queries
, , , ,
#1

Hello Netta,

We are using the open-source BI tool Helical Insight version 6.1.0.852. The MariaDB connection is successfully established, but when we try to expand the schema in metadata, it throws the following error:

Error:
MalformedJsonException: Unterminated array at line 1 column 26 path $[2]

What could be the reason for this issue, and how can we fix it?

image

Thank You,
Netta.

#2

Hello,

This issue occurs when there are spaces in the table names, for example:

  • tabCustomer
  • tabOrder
  • tabInvoice
  • tabLoan
  • tabStock Entry
  • tabPayment Log
  • tabSales Info

To fix the issue, follow the steps below:

Download MariaDB.zip file and extract it.

  1. Go to the below Helical Insight installation path and remove the older MariaDB driver, then add the new driver:

..\hi\hi-repository\System\Drivers

mariadb-java-client-3.5.7.jar

  1. Copy the files mariadb.js and mariadb.xml to:

..\hi\hi-repository\System\Admin\SqlFunctions

  1. Copy mariadb.efwd to:

..\hi\hi-repository\System\Admin\DbConfig

  1. Open the file sqlFunctionsXmlMapping.properties and replace:

org.mariadb.jdbc.Driver=mysql

with

org.mariadb.jdbc.Driver=mariadb

  1. Restart the Helical Insight service.

Then clear the browser cache and test metadata creation, it works fine.

Thank You,
Helical Insight