Unable to get geodatabase version history list.

[User35489]

Hello There,

I have encountered an error popup, while trying to look into properties of a geodatabase as an SDE user.

Unable to get geodatabase version history list. String '12/20/2024 02:30:15' was not recognized as a valid DateTime.
(attached snapshot)

Environment:
ArcGIS Pro 3.2, Oracle 19c, ArcGIS Enterprise 11.3

[MarceloMarques]

In SQLPlus or Oracle SQL Developer query the ArcSDE Repository table sde_version_history.

The record last_upgraded (null) can be missing.

With the following SQL command you can update the date to last_upgraded and the error shall stop appearing.

SELECT * FROM sde.version_history;

Example:
update sde.version_history set last_upgraded = '2024-12-20' where major = 10;

If this does not resolve the problem, then please open a ticket with Esri Technical Support.

Note: work with your Oracle Database Administrator and make sure you have an Oracle RMAN full backup of the database. Also, you can ask the Oracle Database Administrator to create an Oracle restore point, then you can make the change and test, and then if everything is fine you ask to drop the Oracle restore point. Otherwise, if have problems then you can ask to rollback the changes using the restore point. This is faster than using the Oracle RMAN backup to perform a point in time recovery.

[User35489]

I apologize for delay @MarceloMarques 

The field is not empty in the table. The error is stating that the below value is not a valid date

[MarceloMarques]

@User35489 - please open a ticket with Esri Technical Support to investigate this further, support might ask you for a database backup of your geodatabase to troubleshoot the issue.

How to Move the Oracle Enterprise Geodatabase with the Oracle Data Pump Utility