Problem:

Receiving SQL Error 117 on load to XDB Table.

SQL message equates to 'THE NUMBER OF VALUES ASSIGNED IS NOT THE SAME AS THE NUMBER OF SPECIFIED OR IMPLIED COLUMNS'

Resolution:

This error can be generated if Old Alias names are being used in your Project.
Within your project change the following Aliases if they exist.
Alias Name - DSNUTILB, Program Name needs to change from MFDB2LOA to XUTILB
Alias Name - DSNTEP2, Program Name needs to change from MFDSNTEP to XTEP2.