ORA-01866: the datetime class is invalid
Answers were Sorted based on User's Feedback
Answer / guest
Cause: This is an internal error.
Action: Please contact Oracle Worldwide Support.
Please add more information about this Error
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / wells dantas
We had the same error in an application running on Oracle Application Server version 10.1.3.5.0. The application ran without problems in Brazil and we had to migrate it to Mozambique (Africa).
After several unsuccessful attempts, we found that this problem only happened when we used a non-default TimeZone (GMT) and other than "America/Sao_Paulo" (in our case was set for TimeZone "Africa/Maputo"). We found that this problem did not occur in Oracle Application Server version 10.1.3.1.0 with the same settings in TimeZone.
We solve the problem by replacing two libraries of the BC4J version 10.1.3.5.0 to BC4J version 10.1.3.1.0: adfm.jar and bc4jmt.jar.
Our problem was solved by replacing these two libraries, but if replacement is not possible it is best that the matter be reported to Oracle that the problem is resolved.
Regards,
Wells Dantas / Renan Furtado
Accenture Brasil
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anonymous
If using Windows, try:
* In the system registry, go to
HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Controls/TimeZoneInf
ormation
* Remove the DisableAutoDaylightTimeSet property, or set it
to 0.
Is This Answer Correct ? | 1 Yes | 5 No |
TNS-12633: No shared authentication services
ORA-27026: skgfrls: sbtend returned error
ORA-18003: an outline already exists with this signature
QSM-00776: the user-defined workload string is missing the following column: string
ORA-29656: Invalid option for USING
DRG-50855: logoff fail
ORA-25297: The message options only make sense for buffered messages
ORA-28140: Invalid column specified
ORA-40103: invalid case-id column: string
ORA-36314: (PHYS01) workspace object must be a dimension, relation or variable.
DRG-10513: index string metadata is corrupt
ORA-23497: repgroup name cannot be null