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 static data (like 123 or 1*24) then those data types are stored as INT4 or INT8 or float8 because 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:
- Start the DB from <AnalyticsPlus home>/bin.
- Connect to the AnalyticsPlus database and execute the below query (add the datatype found the error trace - like'INT4' or 'INT8')or
UPDATE columndetails set data_type='BIGINT' where data_type in ('INT4','INT');
UPDATE columndetails set data_type='DOUBLE' where data_type='float8';
- Stop the db.
- Place this patch in <AnalyticsPlus home>/fixes folder.
- Start the services.
Note: The given patch is compatible with 4500 and 4510 as the issue is experienced only from 4500 build (will be fixed in the future release),
New to ADSelfService Plus?
Related Articles
Upgrade to AnalyticsPlus 5400 Fails for Users with Missing zsoid Values
Issue Upgrading from builds between 5301 and 5360 to build 5400 fails because the zsoid field for some users is null. Error Trace java.sql.SQLException: This column [ZSOID] has some null values, hence it cannot be modified as not-null. Cause The ...Troubleshooting SSL Issues During ServiceDesk Plus Integration with AnalyticsPlus
This guide helps troubleshoot SSL-related issues when integrating ServiceDesk Plus (SDP) with AnalyticsPlus. Scenario 1: No Valid SSL Certificate Applied in AnalyticsPlus If you have not applied a valid SSL certificate in AnalyticsPlus: Check ...Initial Sync Failed Between ServiceDesk Plus Cloud and AnalyticsPlus Cloud due to Custom Field Names
Issue The initial synchronization between ServiceDesk Plus Cloud and AnalyticsPlus Cloud failed because custom field names in ServiceDesk Plus contained backslashes (\). Error screenshot for reference Cause This is due to a limitation in the SDPOD ...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 ...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 ...