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
RSA Via Lifecycle and Governance Salesforce Account Data Collector does not allow configuration without a "Security Token" Number of Views 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 RSA Identity Governance & Lifecycle log message "Could not find new XAResource" in server.log file Number of Views How to apply patches from the local hard drive for RSA Authentication Manager 8.x Number of Views
Trending Articles
RSA Release Notes for RSA Authentication Manager 8.8 RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Upgrade Process Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
