Has anyone had problems with incorrect data definitions causing Copy stages to abort?
At the moment I have a job that reads from a column from a dataset and sends it to a copy stage . The column is written to the dataset as a varchar(20) but the problem job reads it as a char(4) (and warns about it too!) but then the job aborts with this error... (occasionally!)
does that sound like something you have seen?
I am going to fix up my job and see if it becomes more reliable
and post my results here!!
<additional>
the first failure since i have been taking notice was a Copy stage "terminated unexpectedly"
the next failure in this job, was a Lookup stage
which "terminated unexpectedly"
both of these failures did NOT re-occur after a simple "restart" of the sequence which executes the job
I have removed the data mismatch and will post if the (intermittent) failures stop happening .. More tomorrow
p.s. the error message ID is IIS-DSEE-TFPM-00281
intermittent "parallel process: terminating " erro
Moderators: chulett, rschirm, roy
intermittent "parallel process: terminating " erro
Last edited by grogash on Tue Feb 22, 2011 9:05 pm, edited 1 time in total.
Gene Rogash
gene@rogash.com +61 414 764 274
gene@rogash.com +61 414 764 274
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Or I could just split it.... <snip>... done.
grogash - please edit your post and set your particulars - O/S, version, etc - unless by some chance I guessed right.
Here is the original thread, by the way:
viewtopic.php?t=136594
grogash - please edit your post and set your particulars - O/S, version, etc - unless by some chance I guessed right.
Here is the original thread, by the way:
viewtopic.php?t=136594
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers

