IBM Support

Numeric fields do not error when the length is greater than the max length *|* -B468CA861DBCC6BB8525791700808DAC- *|*

Question & Answer


Question

Numeric fields do not error when the length is greater than the max length *|* -B468CA861DBCC6BB8525791700808DAC- *|*

Answer

Technote (troubleshooting)


Problem(Abstract)

Numeric fields do not error when the length is greater than the max length

Symptom

Numeric data that the total has more characters than what is set as the Max Length in the Validation tab does not issue Translation Error. This issue seems to be only when the total number of characters to the left of the decimal are less than the max length.
FOR EXAMPLE
data = 123456.789
Validation tab is set for R3 min0 max8
-Will not throw an error for Data Too Long.

data = 123456789.999
same validation as above
-Will throw error 112 Data Too Long.

The difference is in the first example there are 6 characters to the left of the decimal and in the second 9.

This occurs when format is delimited as well as either the INPUT or OUTPUT side of the map.
The issue only occurs when the format of the field is R if it were implied (N3) the error would generate as it should.

Error Message

112 Data Too Long error should be issued in each of the above examples specified not only when the number of characters to the left of the decimal are greater than the max length of the Validation tab.


Resolving the problem

Please apply Gentran Integration Suite Release 4.3 Build 4322 or later.
Please apply Sterling Integrator Release 5.0 Build 5006 or later.
After the patch has been applied please download and re-install the Map Editor.
Please apply Sterling Integrator Release 5.1 Build 5101 or later.

Historical Number

NFX6924

Product Alias/Synonym

Function Area


Map Editor

Escalation ID


85471

Fix ID


198369 200413 233295

Severity


Normal

Type


NormalFix

Build


4322 5006 5101

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 October 2021

UID

ibm10769717