Start a new topic

Error message: Column name 'Number_Of_Installments' appears more than once in the result column list.

 If importing to a gift batch and using a gift default set, you might encounter this error:

Line 1: Error saving batch on data row # 1. Error = 'General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'Number_Of_Installments' appears more than once in the result column list.

If you experience this, open your gift default set and check out the schedule fields. If you haven't changed the frequency at all the "No. Installments" field will be blank, but if you select any value in the frequency drop-down box this field will become populated with a numeric value that you cannot remove when it is set to "Single installment". This value causes IOM to add another field to the gift batch that is not necessary. If this happens to you, and you are not working with gifts that require a schedule, you'll want to create a new default set record and (I've always wanted to say this) be sure NOT to touch that frequency dial!

image

 

This will be corrected in the forthcoming 1.8.5 release.

 

Login or Signup to post a comment