APT_CombinedOperatorController(7),0: -help needed urgently
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
APT_CombinedOperatorController(7),0: -help needed urgently
Hi
DS 7.5.2
DB: oracle 10g
I have a job that has a dataset as source, and several look ups and all of them are joined using a merge stage and then load it to a dataset. now if i run this job i get the following warning message and it says job aborted.
warning message:
APT_CombinedOperatorController(7),0: Field 'AMOUNT_TYPE_KEY' from input dataset '0' is NULL. Record dropped.
can anybody hepl me fix this.
DS 7.5.2
DB: oracle 10g
I have a job that has a dataset as source, and several look ups and all of them are joined using a merge stage and then load it to a dataset. now if i run this job i get the following warning message and it says job aborted.
warning message:
APT_CombinedOperatorController(7),0: Field 'AMOUNT_TYPE_KEY' from input dataset '0' is NULL. Record dropped.
can anybody hepl me fix this.
Thanks
Karthick
Karthick
Not sure why something like this would be "urgent".
First thing you'd find searching here would be an error from "CombinedOperator" gives you no clue as to the stage giving the error. Disable Operator Combinality and then post the error. In the meantime, search for a generic portion of your message, something that's not specific to you but is enough to find other people with similar postings. For example, an exact search for "is NULL. Record dropped." returned 50 matches. The truth is out there.
First thing you'd find searching here would be an error from "CombinedOperator" gives you no clue as to the stage giving the error. Disable Operator Combinality and then post the error. In the meantime, search for a generic portion of your message, something that's not specific to you but is enough to find other people with similar postings. For example, an exact search for "is NULL. Record dropped." returned 50 matches. The truth is out there.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Hi
Thank you so much for the suggestion, i really appreciate that. im sorry i was in a hurry thats why, I still have the warning message. but when i tested the same job by running from the designer it ran, but when i run the sequence from the DS director it aborts, so i removed the limits for the warning messages (which was set to 50) and my job didnt abort. I know this is not the right solution, but for time being i was able to handle this.
i will work on this and find the solution and will keep u updated.
thank you so much.
Thank you so much for the suggestion, i really appreciate that. im sorry i was in a hurry thats why, I still have the warning message. but when i tested the same job by running from the designer it ran, but when i run the sequence from the DS director it aborts, so i removed the limits for the warning messages (which was set to 50) and my job didnt abort. I know this is not the right solution, but for time being i was able to handle this.
i will work on this and find the solution and will keep u updated.
thank you so much.
Thanks
Karthick
Karthick
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
Re: APT_CombinedOperatorController(7),0: -help needed urgent
Is the Field 'AMOUNT_TYPE_KEY' defined as Not NULL?
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
It surely seems to be transformer where there are some transformations applied on 'AMOUNT_TYPE_KEY'. avoid using transformation on null values.Scope wrote:Are you using any transformer stage in the job?
you can use syntax like:
Code: Select all
If IsNull('AMOUNT_TYPE_KEY') Then SetNull() Else Trim('AMOUNT_TYPE_KEY')
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 7
- Joined: Wed Aug 13, 2008 2:35 am
- Location: kuala lumpur