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
How to obtain the RSA Identity Governance & Lifecycle Application Last Modified Date, Creation Date and ID (Version) Number of Views Users migrated from RSA Authentication Manager 7.1 cannot request replacement tokens via the self service console after mi… Number of Views After upgrading to 8.0.0, migrated AFX Connectors show as "Not Deployed" in RSA Governance & Lifecycle Number of Views Error: Cannot connect to database. 'Access denied. The database cannot be accessed at this time. RSA ACE/Server database a… Number of Views RSA Authentication Manager 8.1 replica attachment fails with error with migrated primary Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
