I’m having issues saving Measurement for Object for some specific records. It doesn’t happen to all. I click save and it takes a long time and finally errors out.
Context:
- I am using a BPA Workflow triggered by a custom event when a measurement is entered
- The workflow event action is set to run asynchronously.
- I disabled this event action and I’m still seeing the same issue for specific records.
- The workflow makes
- multiple IFS API calls
- a IFS Rest Call
- includes JavaScript scripting
- includes looping through a collection of objects
- The mutating operations in the workflow include:
- Creating web app notifications
- Creating push notifications for MWO applications
Any insight on this would be useful. It could be a data issue, or it could be a side effect of the custom event action with the workflow.
IFS Web Version: 24.2.5.20250402090305.0
Date: 2025-08-18T18:08:11.775Z
---------------------------------------------------------------------------
MeasurementsForObject/Form (server error)
Database error occurred. Contact administrator.
Error details: {"code":1878,"message":"ORA-01878: specified field not found in datetime or interval"}]
Request Id: b3a3f645-c620-4421-ba99-b1709dba3554
Url: https://irvingmaterials-cfg.ifs.cloud/main/ifsapplications/projection/v1/MeasurementsForObjectHandling.svc/EquipmentObjectMeasGroupSet(TestPntSeq=83,ParameterCode='1')?select-fields=ParamTypeDb,Contract,MchCode,ObjectDescription,ParameterCode,ParameterDescription,TestPointId,TestPntSeq,UnitOfMeasure,MeterIDRequired,Objgrants,ValuesSeq,ResourceSeq,EquipmentObjectSeq,TestPointDescription,MeasurementType,RecordedValue,LastDeltaValue,NewRecordedValue,DeltaValue,NewRegDate,MeasurementNote,Remark,NoteModified,NewConditionRating,IsIndicatorRating,MeterId,TotalValue,MinReadingLimit,MaxReadingLimit,MaxConditionRatingDetail,UpdateFromObject,Objsite,luname,keyref
---------------------------------------------------------------------------