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.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
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]: ...Data sync issue - Live connect
Issue: The data level changes and row addition at the DB level is not getting updated in Zoho Analytics Onpremise even after performing "Sync Design" from data source. Analysis: Tried to remove the table from the data source and re-add it again, the ...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 ...Import data from Progress OpenEdge
If you have your data stored in Progress OpenEdge local database, you can easily import the data into Zoho Analytics for advanced reporting and analysis. Data Import 1. How do I import data from the Progress OpenEdge database into Zoho Analytics? 2. ...Getting started with Zoho Analytics Dashboards app
The Zoho Analytics Dashboards app allows you to access analytics whenever required with an intuitive and immersive mobile app. You can view and access the reports and dashboards created in Zoho Analytics, and gain insights on the go. Installing the ...
New to Zoho LandingPage?
Zoho LandingPage Resources