Error ORA-01830: date format picture ends before converting entire input string when collecting a datetime object in RSA Identity Management and Governance
Originally Published: 2017-01-13
Article Number
Applies To
RSA Version/Condition: 6.9.1, 7.0.0
Issue
ORA-01830: date format picture ends before converting entire input string
This happens most often when the source is a non-Oracle database (e. g., Microsoft SQL Server).
Cause
To find the current datetime format in Oracle, use the following query:
SELECT * FROM T_SYSTEM_SETTINGS WHERE parameter ='DatabaseDateFormat'
You can convert to a proper datetime format using code similar to the following:
TO_CHAR(my_date_object, 'DD-MON-YYYY HH24:MI:SS') AS my_date_object
Related Articles
ORA-01840: Input value not long enough for date format error while setting the date type attribute filter in the review in… Number of Views False Positive - RSA Authentication Manager 8.1 SP1 P10 vulnerable to CVE 2016-0728, CVE-2015-8787 and CVE-2015-8709 (Open… Number of Views The audit.log is not logging to the proper location defined in the log4j.xml Number of Views Enterprise Manager Log settings: EM.log - log4j.xml Number of Views FIM - Log4j memory leak Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle RSA Authenticator 6.2.2 for Windows Administrator Guide RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
