TRIRIGA

We are having an issue with date/time fields in editable queries after upgrading to Platform 4.2

The issue is that the date does not get saved when it is entered on the editable query. 
There is an exception in the server log file where it appears that te parsing of the date field is failing.

Has anyone else seen this ?

Steps to Reproduce 

1. Create an editable query with a date time field ( triWorkTask :: triActualStartDT )
2. On the Advance tab of the query use the "Import State Actions" button and import the "Save" state transition for the business object used in the query
3. Run the query.
4. Enter a date time value and select the record
5. Click on the "Save" action
6. The query will refresh and the date will disappear
7. In the server.log file there will be an exception

2022-11-15 07:50:35,194 ERROR [com.tririga.architecture.web.html.query.QueryActions](WebContainer : 9) EXCEPTION

java.lang.NumberFormatException: For input string: "11/17/2022 09:00:00"

                at java.lang.NumberFormatException.forInputString(NumberFormatException.java:76) ~[?:2.9 (05-11-2022)]

                at java.lang.Long.parseLong(Long.java:601) ~[?:2.9 (05-11-2022)]

                at java.lang.Long.valueOf(Long.java:815) ~[?:2.9 (05-11-2022)]

                at com.tririga.design.web.process.smartrecord.SmartRecordActions.saveField(SmartRecordActions.java:2722) ~[ibm-tririga.jar:?]

                at com.tririga.design.web.process.smartrecord.SmartRecordActions.saveField(SmartRecordActions.java:2679) ~[ibm-tririga.jar:?]

                at com.tririga.architecture.web.html.query.QueryActions.saveTempAA(QueryActions.java:317) ~[ibm-tririga.jar:?]

                at com.tririga.architecture.web.html.query.QueryActions.saveQuerySectionTempAA(QueryActions.java:181) ~[ibm-tririga.jar:?]

                at com.tririga.architecture.web.html.query.QueryActions.saveQuerySectionTemp(QueryActions.java:157) ~[ibm-tririga.jar:?]

                at com.tririga.design.web.process.smartrecord.SmartRecordActions.saveQSData(SmartRecordActions.java:5993) ~[ibm-tririga.jar:?]

                at com.tririga.design.web.process.smartrecord.SmartRecordActions.doTempSave(SmartRecordActions.java:3544) ~[ibm-tririga.jar:?]

                at com.tririga.design.web.process.smartrecord.SmartRecordActions.saveRecord(SmartRecordActions.java:3139) ~[ibm-tririga.jar:?]

                at com.tririga.design.web.process.SmartRecordProcess.processRequest(SmartRecordProcess.java:298) ~[ibm-tririga.jar:?]

                at com.tririga.web.process.ProcessRouter.route(ProcessRouter.java:36) ~[ibm-tririga.jar:?]

                at com.tririga.web.servlet.DispatcherServlet.service(DispatcherServlet.java:49) ~[ibm-tririga.jar:?]

------------------------------
Robert Nenne
------------------------------

#TRIRIGA
#AssetandFacilitiesManagement