Accessing UI Gives Error ORA-01878: Specified Field not Found in Datetime or Interval
(Doc ID 2336245.1)
Last updated on FEBRUARY 07, 2024
Applies to:
Oracle Communications Unified Inventory Management - Version 7.2.5.0.0 and laterInformation in this document applies to any platform.
Goal
"ORA-01878: specified field not found in datetime or interval" when accessing UIM UI.
This happened because Database Server modified the timezone to DST(Day Light Saving). and Application server was on normal Timezone.
Error:
2017-10-15 17:19:12,966 DEBUG [<anonymous>] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [Tnadapter] Evaluando Rango 332450000--332459999
2017-10-15 17:19:13,602 DEBUG [<anonymous>] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [Tnadapter]
Internal Exception: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
Error Code: 1878
Call: SELECT t0.ENTITYID, t0.ENTITYCLASS, t0.ACTIVITY, t0.ADMINSTATE, t0.CREATEDDATE, t0.CREATEDUSER, t0.DESCRIPTION, t0.ENDDATE, t0.ENTITYVERSION, t0.ID, t0.LASTMODIFIEDDATE, t0.LASTMODIFIEDUSER, t0.NAME, t0.NATIVEEMSADMINSERVICESTATE, t0.NATIVEEMSNAME, t0.NATIVEEMSSERVICESTATE, t0.NOSPEC, t0.OBJECTSTATE, t0.OWNER, t0.PARTITION, t0.PERMISSIONS, t0.PHYSICALLOCATION, t0.STARTDATE, t0.CURRENTASSIGNMENT, t0.SPECIFICATION FROM TelephoneNumber t0, InvGroupRef t1 WHERE (((((((((((((to_number(t0.ID) >= ?) AND (to_number(t0.ID) <= ?)) AND (t0.ADMINSTATE = ?)) AND (t0.CURRENTASSIGNMENT IS NULL)) AND t0.ENTITYID NOT IN (SELECT t2.ENTITYID FROM TNConsumer t3, TelephoneNumber t2 WHERE ((t3.ADMINSTATE = ?) AND (t2.ENTITYID = t3.TELEPHONENUMBER)))) AND t0.ENTITYID NOT IN (SELECT t4.ENTITYID FROM TNCondition t7, TNConsumer t6, TNConsumer t5, TelephoneNumber t4 WHERE ((((t6.ENTITYID = t5.ENTITYID) AND (t5.ENDDATE > ?)) AND (t7.TYPE = ?)) AND (((t7.ENTITYID = t6.ENTITYID) AND (t6.ENTITYCLASS = ?)) AND (t4.ENTITYID = t5.TELEPHONENUMBER))))) AND t0.ENTITYID NOT IN (SELECT t8.ENTITYID FROM TNReservation t11, TNConsumer t10, TNConsumer t9, TelephoneNumber t8 WHERE ((((t10.ENTITYID = t9.ENTITYID) AND (t9.ENDDATE > ?)) AND NOT ((t11.RESERVATIONTYPE IS NULL))) AND (((t11.ENTITYID = t10.ENTITYID) AND (t10.ENTITYCLASS = ?)) AND (t8.ENTITYID = t9.TELEPHONENUMBER))))) AND (t0.SPECIFICATION = ?)) AND (t1.INVGROUP = ?)) AND t0.ENTITYID NOT IN (SELECT t12.LOCKEDENTITYID FROM TelephoneNumberRowLock t12 WHERE (t12.ENTITYCLASS = ?))) AND ((t0.OBJECTSTATE = ?) OR (t0.OBJE
2017-10-15 17:19:13,602 DEBUG [<anonymous>] [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [Tnadapter]
Internal Exception: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
Error Code: 1878
Call: SELECT t0.ENTITYID, t0.ENTITYCLASS, t0.ACTIVITY, t0.ADMINSTATE, t0.CREATEDDATE, t0.CREATEDUSER, t0.DESCRIPTION, t0.ENDDATE, t0.ENTITYVERSION, t0.ID, t0.LASTMODIFIEDDATE, t0.LASTMODIFIEDUSER, t0.NAME, t0.NATIVEEMSADMINSERVICESTATE, t0.NATIVEEMSNAME, t0.NATIVEEMSSERVICESTATE, t0.NOSPEC, t0.OBJECTSTATE, t0.OWNER, t0.PARTITION, t0.PERMISSIONS, t0.PHYSICALLOCATION, t0.STARTDATE, t0.CURRENTASSIGNMENT, t0.SPECIFICATION FROM TelephoneNumber t0, InvGroupRef t1 WHERE (((((((((((((to_number(t0.ID) >= ?) AND (to_number(t0.ID) <= ?)) AND (t0.ADMINSTATE = ?)) AND (t0.CURRENTASSIGNMENT IS NULL)) AND t0.ENTITYID NOT IN (SELECT t2.ENTITYID FROM TNConsumer t3, TelephoneNumber t2 WHERE ((t3.ADMINSTATE = ?) AND (t2.ENTITYID = t3.TELEPHONENUMBER)))) AND t0.ENTITYID NOT IN (SELECT t4.ENTITYID FROM TNCondition t7, TNConsumer t6, TNConsumer t5, TelephoneNumber t4 WHERE ((((t6.ENTITYID = t5.ENTITYID) AND (t5.ENDDATE > ?)) AND (t7.TYPE = ?)) AND (((t7.ENTITYID = t6.ENTITYID) AND (t6.ENTITYCLASS = ?)) AND (t4.ENTITYID = t5.TELEPHONENUMBER))))) AND t0.ENTITYID NOT IN (SELECT t8.ENTITYID FROM TNReservation t11, TNConsumer t10, TNConsumer t9, TelephoneNumber t8 WHERE ((((t10.ENTITYID = t9.ENTITYID) AND (t9.ENDDATE > ?)) AND NOT ((t11.RESERVATIONTYPE IS NULL))) AND (((t11.ENTITYID = t10.ENTITYID) AND (t10.ENTITYCLASS = ?)) AND (t8.ENTITYID = t9.TELEPHONENUMBER))))) AND (t0.SPECIFICATION = ?)) AND (t1.INVGROUP = ?)) AND t0.ENTITYID NOT IN (SELECT t12.LOCKEDENTITYID FROM TelephoneNumberRowLock t12 WHERE (t12.ENTITYCLASS = ?))) AND ((t0.OBJECTSTATE = ?) OR (t0.OBJE
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |