This issue manifests as incorrect truncation of date-times. It is therefore difficult to detect, but can be anticipated and avoided as detailed below.

This issue does not affect your OpenROAD applications or require changes to them. However, it may affect the rollout of the OpenROAD 5.1 upgrade to client machines in OpenROAD client/OpenROAD Server architectures, if you are upgrading from versions prior to OpenROAD 4.1 Service Pack 3.

ISSUE: OpenROAD 4.1 SP3 and OpenROAD 5.1 use different versions of the Ingres shared libraries and Ingres Net from OpenROAD 4.1 SP2 or previous versions. The newer libraries and Ingres Net contain changes to how they handle certain data types and functions to conform to ANSI database standards. In particular, the handling of “date without time” has changed.

Because OpenROAD is built and installed with a particular version of Ingres Net, OpenROAD clients and application servers can only communicate dates without time to each other if they are both pre-OpenROAD 4.1 SP3, or both post-OpenROAD 4.1 SP2.

RESOLUTION: All OpenROAD clients and servers that inter-communicate must be upgraded together, and rolled back together.

Remember to preserve an application maintenance capability in both current and target OpenROAD versions, so that both rollout and rollback can be handled successfully.