search cancel

AddDate() doesn't seems to be working with new Version. We have tried it through Portal only.

book

Article ID: 238764

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After installing the latest TDM version 4.10, we executed a masking job for a small set of tables. The ADDDAYS() doesn't seems to be working. 

SOURCE DB: ORACLE

Cause

The issue is with the year. The algorithm doesn't recognize year 1 (0001) as a valid year.
 
According to Oracle's documentation:
 
Valid DATE Values
A valid DATE value must fall between January 1, 1000, and December 31, 9999. It must conform to one of three styles: numeric, packed numeric, or month name. You can mix these styles throughout a session
 

Environment

Release : 4.10

Component : Web Portal - Data Masking

Resolution

Below is a quick test with 2 rows of data:

2000-01-01 (01-JAN-00)
0001-01-03 (03-JAN-01)

When using the ADDDAYS masking function to add 10 days to the two dates, we see 10 days were added as expected to the first row, which is a valid date. However, nothing was added to the second date.

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=1hKg14uxAdbQZfCadeoZAg==

Try changing the date to a valid date, such as 2000-01-01, and you should find the masking work.

Attachments