Skip to main content

Microsoft Dynamics NAV RTC The type 'Option' is unsupported for the min/max validation rule.


Hi all,

After an upgrade to NAV 2009 RTC from classic client, a client locked an wiered issue.

While accessing a page from Role center client he was getting the error message

"The type 'Option' is unsupported for the min/max validation rule". 





I checked the page, complied the page but no luck.

I checked the tables too that there might be an option field as the message says something about option
but no luck.I was not getting the resolution, so i started deleting the fields from page and i identified the field
which was giving error. To my surprise it was a Option type of field.

I went to properties and identified that the min value for the field have been set to Ship.

I don't know why but when i cleared these two values from field properties, the page started working.

Resolution -

1) Check the properties of Option Type Field In Table.
2) Check the fields in source table and remove the min & Max value for fields.
3) Remove the values for these properties and issue resolved as shown in image below.




Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Comments

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------