Sync issue between SDP MSP and Aplus

Sync issue between SDP MSP and Aplus

Issue:
Sync fails between ServiceDesk Plus MSP and AnalyticsPlus, after upgrading the SDP to 14730.
Cause:
An example of a case mismatch issue is when Analytics Plus seeks column alias names such as BillID, but MSP returns BILLID instead. This is a flaw in the SDP code-level changes.
Error Trace:

[11:20:45:051]|[07-02-2024]|[com.manageengine.zrmeinteg.framework.ZRSDPFrameWorkImpl_1]|[INFO]|[132]: Generating CSV File...|
[11:20:48:630]|[07-02-2024]|[com.manageengine.zrmeinteg.framework.ZRSDPFrameWorkImpl_1]|[INFO]|[132]: Exception occured while advanced analytics data upload| 
java.lang.Exception: No select column(s) found.

As the changes are being done in the SDP installed directory, If this error arises we need to forward this case to the SDP team to perform the below action.
Reference: (Action done by SDP to resolve the issue):

* Update the pkcolumn name from BILLID to BillID ( as shown in the below images) in the ZRMEModules.xml file under <ServiceDesk MSP Home>/ zreport/1/sync/conf .

1) From BILLID


2) To BillID


* Restart the SDP MSP service and initiate the sync for the changes to take .
Note:
The above issue will be fixed post SDP MSP 14730, in one of their upcoming hot fix.



          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?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    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 ...

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

                      • Steps to perform Repopulation for sync issue

                        Symptoms:  [SYSERR]|[INFO]|[61]: java.lang.NullPointerException| [SYSERR]|[INFO]|[61]:  at com.manageengine.framework.sqlbuilder.AQBManager.updateColumnDetailCache(AQBManager.java:488)| Cause: The mismatch between ZRMEModules.xml and SDP UI. ...

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

                      • Troubleshooting ServiceDesk Plus and Analytics Plus Sync Issues

                        This document provides troubleshooting guidance for common synchronization and connectivity issues between ServiceDesk Plus and Analytics Plus. Ref: ...
                      Related Products