ORA-01878: Specified Field Not Found In Datetime Or Interval

(Doc ID 2336245.1)

Last updated on DECEMBER 11, 2017

Applies to:

Oracle Communications Unified Inventory Management - Version 7.2.5.0.0 and later
Information 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

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms