Hi
we have a production environment which contains server and parallel jobs ,out of all jobs one PX job is aborting with this error
When checking operator: When binding output schema variable "outRec": When binding output interface field "DISPLAY_SEQ" to field "DISPLAY_SEQ": Converting a nullable source to a non-nullable result;
could any body relpy me why this is happening
Fatal error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Mon Oct 10, 2005 10:11 am
- Location: u.s.a
- Contact:
Fatal error
hi
i want to learn datastage which was use ful for emprove my skills
i want to learn datastage which was use ful for emprove my skills
Its occuring because in one of your stages:
the mapping from input to output column is such that DISPLAY_SEQ which is nullable in the input column but is defined as not nullable in the output of the mapping.
You need to handle null values check for nulls may you need to some thing like this
the mapping from input to output column is such that DISPLAY_SEQ which is nullable in the input column but is defined as not nullable in the output of the mapping.
You need to handle null values check for nulls may you need to some thing like this
Code: Select all
If IsNotNull(DISPLAY_SEQ) Then DISPLAY_SEQ Else NullTovalue().
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
If you are using a transformer you simply need to use
NullToValue(DISPLAY_SEQ, new_value). The If Then Else is not required.
Alternatively if you are not already using a transformer use the handle_null function in a Modify stage (see the video tech tip).
In your original post have you truncated the warning message you received? It probably adds something along the lines of 'a fatal runtime error could occur'.
And it did.
NullToValue(DISPLAY_SEQ, new_value). The If Then Else is not required.
Alternatively if you are not already using a transformer use the handle_null function in a Modify stage (see the video tech tip).
In your original post have you truncated the warning message you received? It probably adds something along the lines of 'a fatal runtime error could occur'.
And it did.