CONXP: ORACLE DATES

Document ID : KB000053235
Last Modified Date : 14/02/2018
Show Technical Document Details

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.