Troubleshooting
Problem
User tries to insert a mapping row in an account lookup table. For example, user attempts to add a source account 3XXXXXXXXXX in a table which only contains 1XXXXXXXXX and 2XXXXXXXXX accounts. User receives error message.
Symptom
Arithmetic operation resulted in an overflow.
Cause
When you add a new lookup table in Controller it will create a new table in the database (e.g. fastnet.ltablename). The 'from' columns are created as a int 32 when you select them as a number. The limit for an int 32 column is 2,147,483,647. Therefore, when you add numbers above this it will appear as an error.
Resolving The Problem
Amend the lookup table definition, by unticking the "numeric" box.
- [This now should create the database column as an 'nchar' and resolve the issue].
Steps:
- Open the lookup table definition
- Locate the relevant section (e.g. 'From column')
- Untick the numeric box
- Tick the 'uppercase' box
- Save definition.
Historical Number
1037543
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21347543