Troubleshooting
Problem
One of the following errors occurs while data is being saved to the database: ORA-1841, ORA-01841, ORA-1843, ORA-01843, ORA-1858, ORA-01858
Symptom
Affected releases: Sterling SCA Releases 5x and 7x
You encounter one of
the following errors while saving a change in the Configurator or some other
data is being saved to the database:
ORA-01841: (full) year must be
between -4713 and +9999, and not be 0
ORA-01843: not a valid
month
ORA-01858: a non-numeric character was found where a numeric was
expected
Cause
Resolving The Problem
These errors can occur if you have created a custom data type in
$YFS_HOME/template/api/extn/YFSDataTypes.xml and defined the data type with
Type="TIMESTAMP" rather than Type="DATETIME".
Steps to
resolve
============
(1) Edit
$YFS_HOME/template/api/extn/YFSDataTypes.xml, changing Type="TIMESTAMP" to
Type="DATETIME".
(2) Rebuild yfsdbextn.jar
(3) Restart the app
server.
(4) Re-test your transaction or Configurator change.
Historical Number
PRI49769
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21523223