Migration
Unable to use Zoho mail SMTP server in Zoho Analytics Onpremise
Issue: Unable to configure zoho mail server in ZAOP Cause: Zoho Mail has now applied certificates [15:58:32:717]|[03-31-2021]|[SYSERR]|[INFO]|[55]: org.apache.commons.mail.EmailException: Sending the email to the following server failed : ...
Unable to start or access the application after upgrading to 4600 or 4610
Issues: Unable to start or access the application after upgrading to 4600 or 4610 version. Case 1: The application fails to start. Case 2: The application was started successfully, but couldn't access the UI Root cause: A few files were missing in ...
Data sync issue - Live connect
Issue: The data level changes and row addition at the DB level is not getting updated in Zoho Analytics Onpremise even after performing "Sync Design" from data source. Analysis: Tried to remove the table from the data source and re-add it again, the ...
Disable verification emails when a new user is added
Follow below steps to disable the verification emails when a new user is added. It is applicable to 4570, 4580, and 4590 of all builds. 1. Stop the Zoho Analytics Onpremise service 2. Download the below files to <Zoho>/Analytics/fixes ...
Certificate error while connecting with MongoDB ATLAS
Added certificates to Zoho Analytics Onpremise to connect with Mongodb Atlas Downloaded the attached files (isrgrootx1.pem.txt,trustid-x3-root.pem.txt) to Zoho/Analytics/jre/lib and rename it as below, isrgrootx1.pem trustid-x3-root.pem Run below ...
Enable cookies in Chrome
Unable to access Ask Zia using below link in Chrome https://localhost:8443/askzia/%3CWorkspace-ID> It throws below error, Cookies are enabled. This is a limitation in the chrome browser. Here are the steps to overcome this. 1. Open the chrome browser ...
Application fails to start on 443 even after changing the port successfully - LINUX environment
The attempt to change the host port to 443 fails in Linux environment. The port is not being used by any other application. To overcome it, we can use AUTHBIND. 1. Download AUTHBIND using below command ...
How to remove unused AuthTokens?
There might be some rare situations where you have to remove unused AuthTokens from your Zoho Analytics Onpremise account. Please follow the steps below: 1. Launch Zoho Analytics Onpremise in a web-browser. The web address used to access the ...
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 ...
Startup issue - Applicable for all Linux platforms
Error trace [08:41:49:231]|[04-09-2020]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[19]: ErrorStream ::: /home/zoho/Analytics/pgsql/bin/psql: error while loading shared libraries: libtinfo.so.5: cannot open shared object ...
Steps to generate Unique Machine ID on Windows and Linux
For Windows (for builds above 4350) 1. Open command prompt and go to this location Zoho\Analytics\bin 2. Execute the file UniqueID.exe and get the machine ID. 3. Please share the machine ID to the support team at ...
Local or cloud db sync gets stuck in in-progress state
Note: This KB is specific for the sync issue with the below log traces. Log traces: [13:58:01:141]|[12-03-2019]|[SYSERR]|[INFO]|[118]: ...
Auto start Zoho Analytics On-Premise in Linux
1. Open "StartServer.sh" present in <Zoho/Analytics/bin> and add the below content nohup sh app_ctl.sh run & 2. Execute the below commands $ sudo chmod +x /etc/rc.local $ sudo vi /etc/rc.local 3. Add the file path (StartServer.sh) that ...
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: This is not specific to any build of Zoho Analytics Onpremise. This fix is for MYSQL version 8 and ...
Moving Zoho Analytics On Premise from one server/folder to another
1. Go to Start --> Services.msc and stop the Zoho Analytics Server service. Note: On Linux installations, to stop the application use, sh app_ctl.sh shutdown 2. Take a backup of the entire <Zoho Analytics On Premise_Home> directory and then ...
How to Change Webserver port in Zoho Analytics On Premise:
Zoho Analytics On Premise is installed by default on port 8443 (Unless changed during installation). Now if you wish to change the port Zoho Analytics On Premise uses, Please follow the below steps. Stop the Zoho Analytics On Premise services (using ...
Sync getting stuck in In-progress state
Issue: Sync getting stuck in In-progress state. Usually, when the data type mismatch is present, this issue occurs. Logs required: <Zoho/Analytics>/pgsql/data/pg_log/ Check for the error trace by searching "ERROR: invalid input syntax for" Sample ...
Applying an SSL Certificate(WildCard)
Please Note: These are general guidelines, It is always advised to refer the instructions published by respective CAs to import SSL certificate into tomcat server. Importing WildCard SSL certificate (PEM format) ...
How to activate the Personal Edition of Zoho Analytics Onpremise?
I have installed Zoho Analytics and I don't see an option to activate Personal Edition. How do I get a personal Edition of Zoho Analytics? Zoho Analytics now has a download setup where you will be on the Professional Edition for the first 30 days. ...
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 ...
ZAOP 4000 fails to start in Ubuntu 16
Issue: ZAOP version 4000 fails to start in Ubuntu 16. Analysis: Manually starting the DB works fine. Found that<Zoho Home>/Analytics/pgsql/bin/libreadline.so.6 was missing. Solution: Copy the .zip file and extract in the location. Note: It will be ...
Creating New SSL Certificate
Import third party SSL Certificate in Zoho Analytics On Premise This procedure is common to both editions of Zoho Analytics On Premise - Professional Edition and Personal Edition. In order to implement SSL, a web server must have an associated ...