Some things I've learned about Data Warehousing, Business Intelligence and other stuff too
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|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.
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.
We recently upgraded a clustered server to MDS 2016. I went to go verify the upgrade and ran into this strange error when viewing all of the entities:
After troubleshooting for a while, the cause became painfully obvious. It turned out that I needed to clear the cache in IE since it still had the previous 2012 version in cache.
I hope this saves someone some time.