Problem Summary: F_JD2245: Upgrade issue encountered while converting to Ingres ansidate column
While upgrading from 5.1.3 to 5.5.0/20 below issue was encountered.
F_JD2245: Date ‘2019-06-02 08:07:37.000+00:00’ containing time information encountered while converting to Ingres ansidate column [CREATEDDATE] of table [payment__c]. Use action TableProperties /CoerceErrorPolicy=SILENT /CoerceErrorType=ROUNDING to silently ignore time part.
During the upgrade of the Hub and Target/Source machines from an earlier version of HVR to HVR release 5.5.0/20, customers can encounter an error with the datatype used in one of our channels where Salesforce is the source, and SQL Server is the Target.
One way to handle this is by changing the data type on the target table as well as in the table definition in the HVR channel.
Answer:
For this case, the source/targets are both Sql*Server. We had originally suspected that they may have an action in their channel and HVR is trying to map it to Ingres ansidate datatype which isn’t a Sqlserver datatype. We have remedied this defect in HVR 5.5.0 releases with our enhanced data type checking though some customers still encounter this issue when upgrading with earlier releases. We no longer allow a selection of a target data type that there is not a suitable data type.
The action taken to correct this by the customer was to modify the data type to a suitable data type mapping for the target endpoint to ansidate column [CREATEDDATE] of table [payments__c] to ‘date or datetime’ datatype.