Neal Waterstreet

The product version and database version are not compatible.

by Leave a Comment

This isn’t a very comforting message the first time you see it:

It’s pretty simple to resolve though. The problem is that the MDS application (product) and repository (database) are on different versions and the repository needs to be upgraded. This is usually the result of a service pack being deployed to SQL Server.

1. RDP to the MDS application server and select “Master Data Services Configuration Manager”.

2. In the Configuration Manager, select “Database Configuration” on the left.

3.  You should see the error below in the the Database Configuration window.

 

 

 

4. Select “Upgrade Database…”.

5. Select “Next”.

6. Depending on the size of the repository, this may run for several minutes.

7. When the upgrade is complete, there will be a “Success” message under “Status”. Click “Finish”.

8. Your repository upgrade is complete.

SYSERR229

by Leave a Comment

SYSERR229|The EXECUTE permission was denied on the object ‘IdList’

Recently I ran into this error while validating a model on a new instance. I checked the SQL accounts that MDS is running under and one of them was incorrect. The ‘mds_schema_user’ no longer had lost access to the ‘mdm’ schema. I granted the account ownership of the schema the model was able to validate normally.

MDSERR310029

by Leave a Comment

MDSERR310029|The status of the specified batch is not valid.

This error occurs when using the entity-based staging process (leaf tables). If multiple entries of the same BatchTag value are executed concurrently, this error can appear. It can happen in the same entity or different entities or models.

The best solution I’ve found is to update mdm.tblStgBatch and set the status_id for the BatchTag to completed. You can then update the BatchTag name in the leaf and reset the ImportStatus_ID back to 0 and reprocess the batch.

An alternative is to append a timestamp to the BatchTag to make it unique. That should keep this from happening.

Credit on this to James Serra, who has a good post on this error, and to Microsoft.

MDSERR400038

by Leave a Comment

I had just finished deploying a model between environments and tried to validate when I got this message:

MDSERR400038|Unpublished business rules exist. Apply the business rules before running Business Rules or Validation again.

The error message on this one is pretty straightforward. I had a list of business rules to publish and tried to set them all as active with a SQL update instead of using Master Data Manager. It didn’t work. I updated the business rules manually and was then able to process the model.