Local or cloud db sync gets stuck in in-progress state

Local or cloud db sync gets stuck in in-progress state

Note:      This KB is specific for the sync issue with the below log traces.

Log traces:

[13:58:01:141]|[12-03-2019]|[SYSERR]|[INFO]|[118]: 
ERROROCCURED,'NOSESSIONID',13,'CLOUDDB_IMP_SCHEDULE_DETAILS',400,1575381481000,-1,'SCHEDULE_MORE_THAN_ALLOWED_COUNT',108,'','','','Sorry_ upload process failed for the table. Only 5 simultaneous uploads are allowed on the same table. Kindly try after sometime.','-NA-','-','10.15.33.107','10.15.33.107_sas','-Not Provided-','-Error Code not 500-','NONE'
OtherDetails:[]
com.adventnet.zoho.db.common.ZDBException: SCHEDULE_MORE_THAN_ALLOWED_COUNT
at com.adventnet.zoho.db.batchimport.DataUploadHandler.<init>(DataUploadHandler.java:174)
at com.adventnet.zoho.db.batchimport.DataUploadHandler.<init>(DataUploadHandler.java:164)
at com.adventnet.zoho.db.clouddb.ZRCloudDBAPI$WriteData$2.executeCode(ZRCloudDBAPI.java:2889)

Analysis:

The zdbimportsyncstatus table contains the sync details of tables. The entries in the table did not clear and accumulated to the limit of 5.

The entries in 'zdbimportsyncstatus' will be deleted once the sync is completed or the sync time exceeds the threshold time. Any occurrence of connection interruption or abrupt shutdown during the import, this can happen.




Note:
Viewid is the objid of the table.



Troubleshooting:

1.      Connect to the database
2.      Execute the below commands,

To clear the entries from zdbimportsyncstatus table
Delete from zdbimportsyncstatus where syncstatus in (0,1) and  viewid=<objid of the table>

To update the sync status from in-progress and inqueue to failed
update ZRCloudDBSyncDetails set SYNCSTATUS='2' where SYNCSTATUS in (0,1) and objid=<objid of the table>

INQUEUE state = 0 (Sync started for the table, but is in queue)
INPROGRESS state = 1 (Sync is in progress)

3.      Initiate the sync.





    • Related Articles

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

    • How to enable Progress OpenEdge DB connection

      Steps to include Progress OpenEdge DB in our local DB import list: 1. Download and install OpenEdge JDBC driver from https://www.progress.com/jdbc/openedge in Analytics installed server. (It is a paid driver. No free drivers are available) 2. From ...

    • Create extensions using Zoho Sigma cloud editor

      Sigma has introduced a cloud editor where users can build extensions for Zoho services . Upon selecting a Zoho service, the corresponding service’s plug-in manifest file will be pre-populated into Sigma’s editor as a new project, eliminating the need ...

    • WorkDrive Sync - Installation Guide

      Overview Zoho WorkDrive app for desktop lets you sync files in Zoho WorkDrive web to your computer, and vice versa. With the help of the desktop app, you can work on your files offline which will get updated to Zoho WorkDrive as soon as you go ...

    • Attaching from Local Drive

      You can use this feature to attach documents, spreadsheets, and presentations to the records from your local drive. To attach files from local drive Click the [Module] tab. Module refers to Temps, Clients, etc. In the [Module] Home page, select a ...