HELP: Cannot insert the value NULL into column 'MUID', table 'mbm.tblAttribute'

Question

I am encountering the following error message with MDS 2012 (web) with SQL Server 2008 R2 (SQL):

ERROR: Cannot insert the value NULL into column 'MUID', table 'MDM.mdm.tblAttribute'; column does not allow nulls. INSERT Fails.

This issue occurs when:

• Creating a new entity using the Excel add-in for MDS (New model and new entity).
• Using MDSModelDeploy through the command prompt to deploy both model and data.
• Using MDS Web UI to deploy an empty model.

The mdm.tblAttributes table has not been altered outside of MDS and the table structures are the same between QA and Production environments.

The process works as expected in other environments like QA. However, once I get to Production this error is keeping me from moving forward.

I have checked permissions (both for service account and my AD account) and they are in sync between staging and production.

Answer 1

Hi,

I am assuming that you have upgraded the SQL Server 2008 R2 MDS database to 2012 and are using 2012 web services and administration website. This is an allowed configuration.

Are you sure that your production server has been upgraded properly? Are you sure your database in the production server has been upgraded/repaired it? Are you sure that your web services have been upgraded?

Also, when do you get the problem in production, using MDSModelDeploy through the command prompt to deploy both model and data or using MDS Web UI to deploy an empty model, or both?

Lastly, have you ever successfully deployed a model to production using this method or any other?

Kind regards,

M