Hi all,
i have a job where the data is extracted from four sequential file undergoing joins and then the data is transformed and loaded into the Target.
In the transformer stage the following operations are done:
STAGE VAR:NEWCHABIM
If (IsNull(Ln_To_TRF.CHABIM) Or Trim(Ln_To_TRF.CHABIM, " ", "A") = '' Or Ln_To_TRF.CHABIM = "0") Then '2050-12-31' Else StringToDate(Ln_To_TRF.CHABIM,"%yyyy%mm%dd")
STAGE VAR:NEWOUVOR
If (IsNull(Ln_To_TRF.OUVOR) Or Trim(Ln_To_TRF.OUVOR, " ", "A") = '' Or Ln_To_TRF.OUVOR = "0") Then '2050-12-31' Else StringToDate(Ln_To_TRF.OUVOR,"%yyyy%mm%dd")
TARGET VARIABLE:DIFFERENCE
If (NEWCHABIM = '2050-12-31' Or NEWOUVOR = '2050-12-31') Then SetNull() Else Abs(JulianDayFromDate(NEWCHABIM) - JulianDayFromDate(NEWOUVOR))
When i run the job it is showing the error as
->Fatal Error: Invalid Julian day.
->Failure during execution of operator logic.
->The Section Leader on node node2 has terminated unexpectedly.
though it is showing job aborted in the director, the job is running and the data is loading into the target.
can anyone give me a solution to remove this error.
Fatal Error: Invalid Julian day
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Tue Jul 21, 2009 4:45 am
- Location: Chennai
- Contact:
Fatal Error: Invalid Julian day
Thanks & regards
Satish R
Satish R
-
- Participant
- Posts: 22
- Joined: Tue Jul 21, 2009 4:45 am
- Location: Chennai
- Contact:
What datatype is "NEWCHABIM" - if you look at your code your are treating it as a string in the THEN clause, but as a date in the ELSE clause.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 22
- Joined: Tue Jul 21, 2009 4:45 am
- Location: Chennai
- Contact: