Today is Halloween, so to scare me, Jitterbit threw a “FillDataElements” error when I tried to build a Salesforce Insert operation and it didn’t like something I’d tried to do with a date.
Luckily … I found a trick (rebuilding my Operation from scratch once I’d fixed the underlying problems) that brought me a treat (the error stopped appearing).
If Jitterbit gives you the following error:
FillDataElements() failed (bad data)
Which might possibly include some details along the lines of:
This occurs when constructing source data element “
YOUR_SOURCE_COLUMN_NAME_HERE” for target node “root$transaction…
You might run across one of these posts from GetSatisfaction.com:
Reading them, I decided perhaps Jitterbit wasn’t happy with some combination of:
- The fact that I’d declared the File Format for a column “
TEST_DATE” of a CSV file source as a Date
- The fact that some of the rows were NULL in the
- Some typo I may have made when playing with scripting against the columns of the
TEST_DATEcolumn in my Transformation “condition” logic
I was sure I’d fixed everything that could possibly be wrong, but the message just wouldn’t stop appearing every time I hit “Test the transformation.”
I decided to try:
- Rebuilding my File Format (copying it and changing all columns to String)
- Starting over with a fresh Salesforce Insert Operation Wizard that referenced the new File Format
I’m not sure which of those two things fixed the problem, but was _ sweet as candy _ to see the error disappear.
May your Jitterbit errors be less frightening this Halloween and every other day!