Portal publish having problems with Oracle Date Fields

Issue/Introduction:

Portal publish having problems with standard Oracle Date Fields. I cannot find the correlation as to why some date fields are working and others of the same type are failing?

Error reported in the logs:

java.lang.Exception: Value for CLNT_EVENT_DT is invalid for datatype, value:1989-04-01 00:00:00.0 INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.utils.TDMPublishUtils.formatSQLParms(TDMPublishUtils.java:318) INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.store.TDMPublishStoreTable.insertRow(TDMPublishStoreTable.java:387) INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.model.TDMPublishJobStart.checkRow(TDMPublishJobStart.java:1403) INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.model.TDMPublishJobStart.publishFromRow(TDMPublishJobStart.java:1447) INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.model.TDMPublishJobStart.publishFromView(TDMPublishJobStart.java:1373) INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.model.TDMPublishJobStart.doPublishTables(TDMPublishJobStart.java:1111) INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.model.TDMPublishJobStart.doPublish(TDMPublishJobStart.java:568) INFO | jvm 2 | 2019/04/05 09:39:57 | at com.ca.tdm.publ.publthread.TDMPublishThread.run(TDMPublishThread.java:46) INFO | jvm 2 | 2019/04/05 09:39:57 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) INFO | jvm 2 | 2019/04/05 09:39:57 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) INFO | jvm 2 | 2019/04/05 09:39:57 | at java.lang.Thread.run(Thread.java:748) INFO | jvm 2 | 2019/04/05 10:02:49 | java.lang.Exception: Value for CNTRBT_DUE_DT is invalid for datatype, value:1989-04-01 00:00:00.0 INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.utils.TDMPublishUtils.formatSQLParms(TDMPublishUtils.java:318) INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.store.TDMPublishStoreTable.insertRow(TDMPublishStoreTable.java:387) INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.model.TDMPublishJobStart.checkRow(TDMPublishJobStart.java:1403) INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.model.TDMPublishJobStart.publishFromRow(TDMPublishJobStart.java:1447) INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.model.TDMPublishJobStart.publishFromView(TDMPublishJobStart.java:1373) INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.model.TDMPublishJobStart.doPublishTables(TDMPublishJobStart.java:1111) INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.model.TDMPublishJobStart.doPublish(TDMPublishJobStart.java:568) INFO | jvm 2 | 2019/04/05 10:02:49 | at com.ca.tdm.publ.publthread.TDMPublishThread.run(TDMPublishThread.java:46) INFO | jvm 2 | 2019/04/05 10:02:49 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) INFO | jvm 2 | 2019/04/05 10:02:49 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) INFO | jvm 2 | 2019/04/05 10:02:49 | at java.lang.Thread.run(Thread.java:748)

Business Impact:
---------------------------------------------------
Can't use portal publish without knowing when it will fail. It seems to be getting the wrong format with an extra zero dot zero in the time for Date fields.

Cause:

This issue was happening was when you have date field and have a primary/unique constrain on it. Now its Fixed.

Environment:

4.7

Resolution:

Here is the patch the error:

Portal publish having problems with Oracle Date Fields.

Please download TDMWeb-4.7.92.0.zip. Contact BC Support for this patch or later GA after 4.8.

NOTE:

This Patch/Fix will NOT be in the 4.8 GA Release. The reason is that it was fixed after code cut off for TDM 4.8 GA. Please contact BC support to ensure it is in the first patch of 4.8 AND all subsequent GA versions of TDM.

Additional Information:

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://comm.support.ca.com/kb/How-to-Download-Test-Data-Manager/KB000009671.
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.