Hi all
I have migrated the job from 7.5 version to 8.1 version and the job runs fine in 7.5 but when i am trying to run the job in 8.1 it shows the following error message. Can any one help me to resolve this error message, below is the error message
TRN_Sales_Check,3: Job aborting due to row limit being reached on output link: LNK_Write_Sales
Error msg
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 15
- Joined: Wed Feb 24, 2010 6:37 pm
- Location: United States
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This particular error has nothing directly to do with a target table, size or otherwise. It is strictly a DataStage message for an output link with the 'Abort after rows' property set to something other than zero... when that number of rows have been sent down it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
How is this property set
Could someone please let me know how this property is set. I could not find any place to set the link properties. I have checked the output tab of the upsteam stage (in my case a transformer)
Thanks
Thanks
Open the Transformer stage properties then click the Constraints icon (yellow chain links) or double click on the Constraints section of the output link (above Derivation), then check under "Abort After Rows." The default value is 0. If the value is not zero, then it means somebody set it to non-zero on purpose.
Choose a job you love, and you will never have to work a day in your life. - Confucius