Datamaker- Error in data scale too long

Document ID : KB000009098
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When creating a subsetting pool using Sybase ASE as the Data Source, the extract is generated by Subset. Out of 20 tables, only two tables are erroring out. In two identical columns when validating the data in these fields, the error message generated is:

"ERROR IN DATA / SCALE TOO LONG / Go back and edit the data". 

After clicking okay, it shows

"51.0600<CR><LF><CR><LF> - Scale too long" on the result field, to the right of the button.

Environment:
Datamaker 4.3Sybase ASE
Cause:

The error message explicitly states the error and the resolution.

Resolution:

The error message indicates there are two carriage returns at the end of the value. These are typically white spaces and could easily not be seen. 

"51.0600<CR><LF><CR><LF> - Scale too long" 

In the screenshot that accompanied this error (see below - not shown in its entirety due to privacy), the cursor is two lines below the last of the function. Simply backspacing twice and trying again resolved the issue.

ScaleTooLong.JPG