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

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

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

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

                      Related Products