# CRP Gateway
## RELEASE NOTES
> v2.3.1

### Upgrade Steps
* Refer to CRP Gateway Patching Guide v2.0 or above

### New Features

### Bug Fixes

* Fixed non-deterministic SFTP file routing where a structured Credit Report Enquiry file (`ENQIR`) could be picked up by the PMDS Credit Report Enquiry channel (or vice versa) when the unstructured TUEF default was enabled. The unstructured `.tuef` / `.tudf` fallback now skips any file whose name already matches another channel's structured pattern.
* Fixed Symmetric Key Enquiry Request in File Management always reporting missing required fields even when File Names and Original Message ID were filled. The form now correctly updates the store when File Names is edited, and the request type label uses title case ("Symmetric Key Enquiry Request").
* Fixed certificate **Valid From** / **Valid Until** not displaying in the List Certificate API (Account Management) after upgrading from v1.x. Legacy certificate dates stored as epoch milliseconds inside the encrypted secret were misread as epoch seconds once the datetime fields migrated from `java.util.Date` to `java.time.Instant`, producing out-of-range values. The shared `ObjectMapper` now reads integer timestamps as milliseconds, so legacy and newly created certificate dates display correctly with no data migration required.
* Fixed datetime handling on **Microsoft SQL Server** that caused Activity Logs to fail to persist and timestamps to be returned with an incorrect `Z` (UTC) offset after upgrading from v1.x. Hibernate 6 maps `Instant` to `TIMESTAMP_UTC` (resolving to `datetimeoffset` on SQL Server), which is incompatible with the existing `DATETIME` columns. The gateway now forces the Hibernate 5 compatible plain `TIMESTAMP` binding (`hibernate.type.preferred_instant_jdbc_type=TIMESTAMP`) for SQL Server only, applied automatically from the datasource detected at startup; this requires no schema change and leaves MySQL behaviour unchanged.

### Improvements