Troubleshooting: Activity saves a DateTime value in a Date property (Oracle schema issue)
In the following activity, a property defined as a
Date type incorrectly returned a
DateTime value to the clipboard instead of a
This activity references the following:
- A property called DueOutDate defined as a
- A property called DateReceived defined as a
- A map value rule called GlobalSLATiming. This map value returns a value using the standard function rule @AddToDate()::
When the activity runs:
- DueOutDate is set by the GlobalSLATiming.
- GlobalSLATiming returns a value from @AddToDate to adjust DateReceived by a pre-determined number of days.
The @AddToDate() function should return a
Date value (for example, 04/17/2007), but instead it returns a
DateTime value (for example, 04/17/2007 11:04:47).
This issue also arises when reports are run using the DueOutDate as an option. DueOutDate is exposed in the database as a
Date type. When a report is run, the following error is displayed:
Customize summary criteria ** There was a problem getting a list: code: 1861 SQLState: 22008 Message: ORA-01861: literal does not match format string
This error occurs because the database returns a column type of TIMESTAMP.
Update the database schema so that every date column has a type of VARCHAR(8), never TIMESTAMP.
Date properties, regardless of the database software hosting your PegaRULES database, must be of the type VARCHAR(8).