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 Traces:
ERROR: invalid input syntax for integer: "ABCD"
CONTEXT: COPY tempignore_734_1538913789758_7271_1, line 56, column c_11960: "ABCD"
Execute the below sample query using Workspace Query Tool to know the Database Name, Table Name, and Affected Column Name.
select obj.id,obj.dbid,obj.displayname as TableName,col.display_name as ColumnName from columndetails col join zdbtable zdbt on col.table_id=zdbt.id join zdbdbobject obj on zdbt.objid=obj.id where col.column_name='column_id';
Fix:
1) Change the data type of the affected column to Text.
2) Once done, connect to Analytics Plus database and change the sync status to "Failure" of that particular table which is "In Progress".
Query Sample:
update zrclouddbsyncdetails set syncstatus=2 where objid=21628;
3) Initiate a re-sync by clicking on "Sync Now" button.
Before changing the data type please ensure if there are any reports created using that column. If so delete the particular text value from the Data Source with customer's permission.
New to ADSelfService Plus?
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 ...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 ...Filters getting duplicated when reports are saved and reopened
This issue is seen in Analytics Plus build 3800. Issue: When a filter is added/edited to a report and saved, the report shows up fine. But, when we close and reopen the report, the filter gets duplicated and causes issues in loading the right data. ...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. ...Initial Sync Failed Between ServiceDesk Plus Cloud and AnalyticsPlus Cloud due to Custom Field Names
Issue The initial synchronization between ServiceDesk Plus Cloud and AnalyticsPlus Cloud failed because custom field names in ServiceDesk Plus contained backslashes (\). Error screenshot for reference Cause This is due to a limitation in the SDPOD ...