ORA-07445: exception encountered: core dump [LdiDateDateConverti()+100 [Address not mapped to object
Good morning Oracle Community,
I receive the above error at random times throughout a day. Mostly in the a.m. hours. This error is generated when the application MAXIMO, issues the following command from the application server to the database;
select count(*) from sr where (reportedby = :"SYS_B_00" and ((status in (:"SYS_B_01",:"SYS_B_02",:"SYS_B_03") and statusdate >= current_timestamp - :"SYS_B_04") or (status in (:"SYS_B_05",:"SYS_B_06",:"SYS_B_07",:"SYS_B_08")))) and (((sr.siteid in (select defsite from maxuser where userid = :"SYS_B_09" ) or sr.siteid is null) and (sr.assetsiteid in (select defsite from maxuser where userid = :"SYS_B_10" ) or sr.assetsiteid is null)))