Portal publish having problems with Oracle Date Fields
Article ID: 130846
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.
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.
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.
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.
Feedback
Yes
No
Powered by
