I am having a parallel job that reads data from seq file and insert the data into the table through a transformer. That was running fine with sucess till date.But today it aborted with the following logs
There is only one Date field at the target table and I am mapping the CurrentTimestamp() to that particular field. So there is no possibility of invalid time as per my knowledge.Done a search on this issue,but not able to get things.
your help/suggestions would be greatly appreciated.
Hi ray,
Thanks for your response.
Ans to your question "nothing has been changed today".That job has been running once a day since january ,08.But today only got that error
Clearly that is not the correct answer, otherwise the job would have run successfully "today". The problem (the change) may be in your data, the problem may be in your hardware, operating system configuration, database configuration, and so on.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Do you have an intermediate file to which you are storing the derived results before loading into the target table?
If then did you open that file and look at what is the timestamp being generated today. Might give you some insight.
Hi , Did u find any solution to this issue. If yes,Please share it across.
We faced the same issue and when we changed the config file it ran successfully. But it reappeared after a few days.