Sample Header Ad - 728x90

Date getting truncated on PDI 7.1 for salesforce DB - Need workaround

1 vote
0 answers
19 views
We are working on transformation which inserts date into a salesforce DB and are seeing issues. Below are the issues: A transformation working in PDI CE 6.1 do not work in CE 7.1 or CE 8.3. Error : >2019/10/31 15:46:32 - Salesforce Insert.0 - :Errors were found on item 0 Error code is: INVALID_TYPE_ON_FIELD_IN_RECORD Error message: Job Start Time: value not of required type: 2019-10-31T15:46:29.211Z # On 6.1: The script was inserting a string variable into date field on SF DB and was working fine. # For 7.1: We changed string to date datatype using select values step and executed, the step now inserts data but we saw that the date is shown as one day prior and time as 8PM # For 8.3: We changed the date generation step to a javascript step, then changed the data type to date. here the insert works ok. Now if we run the transformation in 7.1 it again truncates the time field. This seems to be the defect - https://jira.pentaho.com/browse/PDI-16480 We would like to know If anyone have encountered this issues, or Is there any workaround for this issue in 7.1 ? i.e. can any Jar file for salesforce be copied from 6.1 or 8.3 version to 7.1 to make this work?
Asked by User2019 (15 rep)
Nov 4, 2019, 05:06 AM
Last activity: Nov 4, 2019, 04:44 PM