Invalid value <Year: 0000> for date <00000101>. How to solve

[Former Member]

Dear Experts,

I am beginner in DS & monitoring jobs , RTs in production environment.

Today one of the production job had in warning status, below is the screen shot.

I had opened the Data flow DF_MDCT_TP_Pxx_Get_Data in DS Designer and I don't know next.

How fix this issue ?

reg, Avinash

[Former Member · Accepted solution]

This is a data issue and no issue in the Data service job.

reg, avinash

[Former Member]

Seems like a Data issue , Check the data in DF_MDCT_TP_XYZ_GET_DATA.

Thanks,

AJ.

[Former Member]

I opened the DF, below is the screen shot.

where & what I have to check here ?

[Former Member]

Run this DF in debugger mode and you would be able to see the data between each query transforms. I would use the template tables to check the data as the debugger would give limited amount of data where as template tables will give all the data.

[Former Member]

Hello Alex,

What is the procedure and How to run DF in debugger mode ?

reg, avinash

[Former Member]

You cannot run the DF alone, you need to create a separate job and place the DF there, then run it in debugger mode. also you can replicate the DF so that the original DF will not be changed. meanwhile since the warning is not showing the column name, you may want to check each query for date columns

[mageshwaran_subramanian]

Looks like the job receiving invalid date value.Check the data.