AnalyticsPlus Startup issue

AnalyticsPlus Startup issue

Issue:

Unable to start the services when there is a formula column created with static data

Cause:

When a formula column holds static data (like 123 or 1*24)  then those data types are stored as INT4 or INT8 or float8 because of which the service doesn't start.

Error trace:

[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: java.lang.Exception: Module Loading Failed : ZohoUserDB|
[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: at com.zoho.mickey.startup.MEServer.populateModules(MEServer.java:835)|
[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|
[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)|
[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)|
[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: at java.lang.reflect.Method.invoke(Method.java:497)|
[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349)|
[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: at java.lang.Thread.run(Thread.java:745)|[23:43:32:811]|[06-18-2020]|[SYSERR]|[INFO]|[28]: Caused by: java.lang.IllegalArgumentException: Unknown data type:INT4|


Solution:

  1. Start the DB from <AnalyticsPlus home>/bin.
  2. Connect to the AnalyticsPlus database and execute the below query (add the datatype found the error trace - like'INT4' or 'INT8')
UPDATE columndetails set data_type='BIGINT' where data_type in ('INT4','INT','INT8');
or
UPDATE columndetails set data_type='DOUBLE' where data_type in ('FLOAT','FLOAT8');
  1. Stop the db.
  2. Place the patch (attached) in <AnalyticsPlus home>/fixes folder.
  3. Start the services.



Note: The given patch is compatible with 4500 and 4510 as the issue is experienced only from 4500 build (the fix will be available from 4550, however, the query has to be manually updated).

          • Related Articles

          • Upgrade issue in build 3200

            Upgrade issue in build 3200 The below cases were identified in local system and couple of customer's system during 3200 upgrade. Issue 1: PGSQL migration fails: Since this upgrade will upgrade pgsql version, pgsql has its own upgrade prior to ...
          • MSSQL DB Connection Password Special character issue

            Please find the steps below to resolve the issue 1. Download the patch from here 2. Stop Analytics Plus services and make sure all the related processes are terminated. 3. Extract the patch.zip file under ManageEngine/AnalyticsPlus/, the patch will ...
          • How to connect to Analytics Plus 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 ...
          • Auto start Analytics Plus in Linux

            Steps to auto start Analytics Plus in Linux environment:     1. Open "StartServer.sh" present in <AnalyticsPlus\bin> Add  '#!/bin/sh' as the first line of the code. Add  'cd <location to Analytics/bin>' before the line 'sh run.sh'  ex : ...
          • Sync issue in ServiceDesk Plus and Analytics Plus (after ServiceDesk Plus upgrade)

            Issue: After upgrading to the latest version of ServiceDesk the sync with Analytics might break halfway through with the below error msg. (Mostly when the Analytics is not upgraded) Error Trace: MESZ:Error is :: <nobr>[Line: 2,211 Field: 1] (-971) ...