CONXP: ORACLE DATES

Products

• CA 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
• CA Security Command Center
• CA Data Protection (DataMinder)
• CA User Activity Reporting

Issue/Introduction

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.

Environment

Release:
Component: ETRADM

Resolution

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.