Unexpected error prompted for while accessing reports for Servicedesk Plus MSP integrated setup

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 = integer
Hint: 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); 
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • 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 ...

                      • Formula createdtime() function throws error

                        Issue: When we create a formula column using the 'createdtime()' function, it throws unexpected error occurred. Analytics Plus Builds affected : 4300 & 4310 This is found as an issue within Analytics Plus and found happening on build 4300 and 4310. ...

                      • Unable to integrate SDP MSP with Analytics Plus after applying SSL

                        Note: This problem occurs only with self signed certificates in Analytics Plus. Issue: [10:23:16:526]|[09-05-2020]|[SYSERR]|[INFO]|[68]|: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: ...

                      • Move Analytics Plus from one Server/folder

                        Go to Start --> Services.msc and stop the ManageEngine Analytics Plus service. Take a backup of the entire <Analytics Plus_Home> directory and then move it to the new server.  On the new server, navigate to (similar path) <Analytics Plus_Home>\bin ...

                      • Unable to sync between Servicedesk Plus and Analytics Plus - ATKey error

                        Issue: Unable to configure integration/sync between ServiceDesk Plus and Analytics Plus ERROR Message: FAILURE :Not able to get ATKey from Server. You can obtain the error log files from Support tab by clicking on the Support File link in the ...

                        Related Products