This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 85%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
ADF Pipeline sometimes does not work as it should be, records not tallying between source and destination where pipeline record shows all records transferred.
Pipeline run ID4d4aee59-b63f-4804-ab36-704b28df333b
Activity run id: 416f206c-6d7a-439b-8267-9efafc4c5a65
enclosed is the snapshot of it. Kindly assist in figuring out why sometimes pipeline does not work as it should be.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Hi, not able to see your screenshots. Pls check.
Please provide us some more information so we can assist.
as per screenshot, 234,369 records transferred however in the destination table only 233,270 records reflecting, some records for couple of days were not added completely.
Hi, did you check the answer provided below? We suspect some other process or step deleting the record from table after it is inserted. If this is not happening in case, and the issue still persists please let us know.
there is no further step and I checked personally, this is an odd issue but its difficult to explain to management why sales not reflected as it should be. Its like Bank account one day showing USD 1,000, next day USD 350 and after a fix again USD 1,000
After the issue, I again manually rerun the pipeline, it worked fine and since then its working fine till date touch wood
Hmm. Good to know. Request you to accept the answer provided below if it had helped, to close the thread and it would be beneficial to community too.
HiHiThis seems to be one odd case which normally doesn't occur. So kind of puzzled. If there is no other process that works on the same data, we should not be seeing this kind of issue.
May be you can try to clean the table and re running the activity and see if that loads correctly?
Kindly check.