Synchronization error Resource

yiminghu · Post by **yiminghu** » Sun Feb 26, 2006 7:29 am

Hi,

I'm encountering a very strange warning message I have never seen before. I was running a job which reads from one table, and update existing rows/insert new rows of another table. The job finished OK with logs.

The log shows following message:

JObname..Trans1: Synchronization error Resource =
JobName..Insert_TableName.OutTable, CurWave = 6, LastWave = 6, Expected 0

Though the record count are correct. What does that mean?

Thanks,

Carol

chulett · Post by **chulett** » Sun Feb 26, 2006 7:51 am

I did a quick search for 'all terms' of curwave lastwave and got 12 hits, couting yours. Picked this one at random and it seemed like one of the normal Ray To The Rescue posts you'll find on pretty much any subject around here.

Try the search yourself and check out the other answers if you like as well, it's all good education. :D

yiminghu · Post by **yiminghu** » Sun Feb 26, 2006 8:46 am

Thanks. As I could see from past posts, reseting the job could fix the problem next time. My question is whether I need to re-run this time? All the record count looks fine to me.

chulett · Post by **chulett** » Sun Feb 26, 2006 8:53 am

No, I do not believe that you need to rerun the job after one of these problems crops up.