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.

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