Pages

Monday, January 13, 2020

"The number is not valid" error - SQL Server 2019 Master Data Services (MDM 2019 Web UI)

In Master Data Services/MDM 2019 version
You cannot filter on a Number type attribute
within an Entity view on the MDM web interface

You will get "The number is not valid." error message in red
Once you have selected an attribute filter that has Numeric data type.
You can type a value in the Criteria box, but the “Apply” button
Is not clickable.






If you press F12 in Chrome and enter a numeric value in the 
Criteria text box and press tab, you will see the exception below:

KoFilterView.js:459 Uncaught ReferenceError: isInteger is not defined
    at filterLine.checkValue (KoFilterView.js:459)
    at dbaPicker.self.onfocusout (KoDbaPicker.js:555)
    at HTMLInputElement. (knockout.js:79)
    at HTMLInputElement.dispatch (jquery.js:4409)
    at HTMLInputElement.elemData.handle (jquery.js:4095)
filterLine.checkValue @ KoFilterView.js:459
self.onfocusout @ KoDbaPicker.js:555
(anonymous) @ knockout.js:79
dispatch @ jquery.js:4409
elemData.handle @ jquery.js:4095


To overcome this issue you can edit the file below
...\Master Data Services\Web Application\Scripts\UserControls\KoFilterView.js
Replace
           if (isInteger(value - 0)) { 
with
           if (Number.isInteger(value - 0)) {

afterward, clear the browser cache. 

The fix works only for Chrome and doesn't work in Internet Explorer

In my case, you will still see the red error message
but the “Apply” button will become clickable and you will be able
to filter on numeric values.

Enjoy :)

1 comment:

  1. Hi, thanks a lot for this fix!
    But, I still have a problem with filtering numeric values by 'is NULL' and 'is NOT NULL'. Do you by any chance know the solution to this issue as well?

    ReplyDelete