Sync getting stuck in In-progress state

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 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 Zoho Analytics On-premise 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.

    • Related Articles

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

    • Getting Started

      Before you start using Zoho Motivator, we recommend configuring your account settings and exploring the interface a bit. Be sure to check out Dashboards , Targets , Contests , TV Channels , and Live Dashboards to get a better understanding of the ...

    • Set up sync with Zoho CRM

      You can set up your sync settings to schedule periodic syncing of all your contacts and leads between Zoho CRM and Zoho MarketingHub on a daily, weekly, or monthly basis. Types of sync There are two types of sync that you can setup. They are: ...

    • Sync leads from Google

      Zoho MarketingHub enables you to import contacts from Google Contacts. Google Contacts are the contacts associated to your Gmail account. All you have to do is integrate your Zoho MarketingHub account with Google and create a sync. Then contacts in ...

    • Sync leads from Zendesk

      Zoho MarketingHub enables you to import end users from Zendesk as contacts. You can import verified and unverified emails from your account. There are options to import end-users from specific organization or tags.  There are two steps to sync your ...