Analytics On-Premise
How to enable Progress OpenEdge DB connection
Steps to include Progress OpenEdge DB in our local DB import list: 1. Download and install OpenEdge JDBC driver from https://www.progress.com/jdbc/openedge in Analytics installed server. (It is a paid driver. No free drivers are available) 2. From ...
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 ...
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 ...
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) ...
Moving Zoho Analytics On Premise from one server/folder to another
Go to Start --> Services.msc and stop the Zoho Analytics Server service. Take a backup of the entire <Zoho Analytics On Premise_Home> directory and then move it to the new server. On the new server, navigate to <Zoho Analytics On Premise_Home>\bin ...
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 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 ...
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 ...
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 ...
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]: ...
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 ...
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 ...
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 ...
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 ...