Unexpected error prompted for while accessing reports for Servicedesk Plus MSP integrated setup
Issue :
Unexpected error prompt while accessing reports
Analysis:
The exception caused is due to a syntax problem faced in the query formed while the user filter drop down is used on the SLA deviation report. The logs shared helped us to find the problematic syntax and we have the solution now to rectify the problem faced.
Log Trace:
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integerHint: No operator matches the given name and argument type(s). You might need to add explicit type casts.Position: 72
Solution:
1. Launch cmd prompt as Administrator and browse to <AnalyticsPlus home\pgsql\bin>
2. Execute psql.exe -h localhost -p 33366 -U postgres to connect to the Postgres database.
For example: D:\MEReports\AnalyticsPlus\pgsql\bin>psql.exe -h localhost -p 33366 -U postgres
3. Execute \c zreportsdb; to connect to reports database.
For example: postgres=# \c zreportsdb;
4. Execute below queries one by one,
Query #1:
CREATE OR REPLACE FUNCTION pg_catalog.toequals_udf(boolean, integer) RETURNS boolean AS $$ DECLARE x boolean; BEGIN x = ($1::integer = $2); RETURN x; END; $$ STRICT LANGUAGE plpgsql IMMUTABLE;
Query #2:
CREATE OPERATOR pg_catalog.= (PROCEDURE = toequals_udf, LEFTARG=boolean, RIGHTARG=integer);
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Servicedesk Plus gets logged off after integrating with ManageEngine Reports
Problem: Servicedesk Plus logs off randomly. Problem occurs after setting up integration between ManageEngine Reports and Servicedesk Plus. Solution: If you have installed Servicedesk Plus and ManageEngine Analytics Plus on same server, please access ...Unable to integrate SDP /OPM with Analytics Plus after applying SSL in SDP/OPM
Note: This problem occurs only with self signed certificates in Analytics Plus. Issue: [10:23:16:526]|[09-05-2016]|[SYSERR]|[INFO]|[68]|: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: ...Compare Analytics Plus vs Zoho Reports
Please find the attachment[old]Procedure to move Analytics Plus installation from one server to another
Procedure to move Analytics Plus installation from one server to another: Please find the attached document with detailed steps for moving Analytics Plus installation from one server to another.Remove the configuration of Analytics Plus from Servicedesk Plus
Under Servicedesk Plus - Advanced Analytics section, Integration UI allows us to re-configure the host, port and username only after performing 'Remove' action. However, if you uninstall or change the host of Analytics Plus application, you can not ...
New to Zoho LandingPage?
Zoho LandingPage Resources