Page 1 of 1

Synchronization error Resource

Posted: Sun Feb 26, 2006 7:29 am
by yiminghu
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

Posted: Sun Feb 26, 2006 7:51 am
by chulett
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

Posted: Sun Feb 26, 2006 8:46 am
by yiminghu
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.

Posted: Sun Feb 26, 2006 8:53 am
by chulett
No, I do not believe that you need to rerun the job after one of these problems crops up.