ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.



Article ID: 53235


Updated On:


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



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.


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.


Component: ETRADM