CONXP: ORACLE DATES

book

Article ID: 53235

calendar_today

Updated On:

Products

DIRECTORY CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On SINGLE SIGN ON - LEGACY CA Data Protection (DataMinder) CA User Activity Reporting

Issue/Introduction

Description

Getting error message: invalid date format, when creating account on an Oracle DYN Namespace (created via Connector Express)

Need to know how to format a date for the Connector Express so that it can be inserted into an Oracle database.

Solution

Workaround: JCS expects date to be in the xml format yyyy-MM-ddThh:mm:ss. To get this format, we can simply change etaslapd's locale to match it:

  1. Logon to windows as etaslapd, and goto Control Panel -> Regional and Language Options. Under "Regional Options" tab, click on customize to change Short date format to yyyy-MM-dd. Make sure date separator is '-' and not '/'.

  2. In the policy, we still have to make some changes to add the time value. Change %D% to %D%T00:00:00. This means, the current date at zero hour (GMT).

  3. Restart provisioning and superagent services for changes to take effect.

Environment

Release:
Component: ETRADM