Portal publish having problems with Oracle Date Fields
book
Article ID: 130846
calendar_today
Updated On:
Products
CA Test Data Manager (Data Finder / Grid Tools)
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.