Data mapping error occurred

Products

• CA 2E

Issue/Introduction

The VIRTUAL DT# value being retrieved is failing on a Coalesce function when opening a join logical in a RTVOBJ

The 2E Joblog contains the following error:

Description: * 
Message . . . . : Data mapping error on member XXXXX.
Cause . . . . . : A data mapping error occurred on field
Coalesce(R6KDREP_2.CREATED_DATE__ISO_,'1-01-01') in record number 0, record
format *FIRST, member number 1, in member XXXXX file XXXXXX in library
XXXXXX, because of error code 18. The error code meanings follow:
18 -- There is data in a date, time, or timestamp field that is not valid.

For some reason the default date in the access path is trying to replace a NULL value with '1-01-01' instead of '0001-01-01'.

Even when the logical build says :

DATE(IFNULL( X2.CREATED_DATE__ISO_,'0001-01-01'))  

Environment

CA 2E 8.7.x

Resolution

Need to set the Program Overrides (datfmt) for date and time to *ISO '-' and *ISO '.'

 

Additional Information

Using CA 2E Fields