Sync failure between ServiceDesk Plus and Analytics Plus

Sync issue in ServiceDesk Plus and Analytics Plus (after ServiceDesk Plus upgrade)

Issue:

After upgrading to the latest version of ServiceDesk the sync with Analytics might break halfway through with the below error msg. (Mostly when the Analytics is not upgraded)



Error Trace:
MESZ:Error is :: <nobr>[Line: 2,211 Field: 1] (-971) -ERROR: Invalid POSITIVE NUMBER value</NOBR><br><nobr>The data found at the row 2,211 has invalid data for the given configuration</NOBR><BR> 

Cause:
When the project module was introduced in 3800 (later reverted in 3900) the column's datatype was created in the template as 'Positive number'. 

But in the latest build (in A+ 3950) datatype of 'TimeSpent in Minutes' in the tables 'Status History','Technician History' and 'Support Group History' created as 'Number' datatype.


This issue is more likely to happen with Latest SDP (9422 and above).

Fix:

Follow the below steps to change the datatype to Number in the problematic tables. 

  Run the query "update zdbdbobjectprops set propvalue='false' where objid=<OBJID> and propkey='zdb.system.table'" by connecting database
  • Place the jar under AnalyticsPlus\lib
  • Restart the AnayticsPlus Service
  • Change the Datatype to 'Number' in the tables 'Status History','Technician History' and 'Support Group History'.
  • Run the query "update zdbdbobjectprops set propvalue='true' where objid=<OBJID> and propkey='zdb.system.table'" by connecting database
  • Stop the AnalyticsPlus service
  • Remove the jar
  • Start the AnalyticsPlus
  • Re-sync
        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

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

                      • 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 integrate ServiceDesk Plus 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-2016]|[SYSERR]|[INFO]|[68]|: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: ...

                      • 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: <AnalyticsPlus>/pgsql/data/pg_log/ Check for the error trace by searching "ERROR:  invalid input syntax for" Sample ...

                      • Why does Analytics plus import less number of tickets from Servicedesk Plus?

                        While integrating Servicedesk Plus with Analytics Plus, only few rows/tickets are imported into Analytics Plus, while the Servicedesk Plus actually has more number of tickets. The primary reason for this behavior is that the date chosen to ...

                        Related Products