Error pop ups when click on Publish button in MDS excel addins

Category: sql server masterdata


Nagarjuna.kt on Mon, 22 Aug 2016 21:17:58


I have an MDS application where plenty of users enters the data. I have an AD group which have all these users and everyone have the same permissions.

Some of the users can not able to publish the data(inserting new data or updating the existing data ) using their Excel addins or web UI  and its happening very frequently and its only for 2 entities only.

When the user click on publish button in excel addins its showing the below error

"Conversion failed when converting 'ANY ENTERED VALUE' to data type int " and the all of my columns are varchar columns.

I did try by running the Business Rules and republishing the business rules for those two entitles.

I am not sure what's the process behind the 'Publish' button.

Can some one please help me what to do when its happening only for few users ??


Smartysanthosh on Thu, 01 Sep 2016 03:25:40

Hi Nagarjuna,

Are you sure about those 2 users have full Member level permissions on those entities ? also could you post the log information for better call stack trace which will help in understanding issue .