Thursday, December 08, 2011 4:49 PM
Having Spaces in Entity name appears to cause errors in MDS RC0. I noticed the Staging table were getting created with spaces as well and when defining a new Business Rules. Following MDS Exception error: A database error has occurred. Contact your system administrator & MDS Trace produces this portion of error info.
MDS Error: 0 : SqlException message: A database error has occurred. Contact your system administrator.
at Microsoft.MasterDataServices.Core.DataAccess.DbHelper.HandleExceptions(Exception ex)
at Microsoft.MasterDataServices.Core.DataAccess.DbHelper.ExecuteNonQuery(String query, CommandType commandType, CloseConnectionBehavior closeBehavior)
at Microsoft.MasterDataServices.Core.DataAccess.BusinessRules.BusinessRulesExecuteScript(CloseConnectionBehavior closeBehavior, String script)
at Microsoft.MasterDataServices.Core.BusinessLogic.BusinessRulesPublish.Generation.RunGeneration(BusinessRules businessLogicLayer, Int32 entityId, BREntityMemberType ruleSubType, OperationResult result)
SQL Error Debug Info: Number: 102, Message: Incorrect syntax near '_XXX'., Server: SERVERNAME, Proc: udp_SYSTEM_9_75_CHILDATTRIBUTES_ProcessRules, Line: 290
And looking at this "udp_SYSTEM_9_75_CHILDATTRIBUTES_ProcessRules", MDS produces, the code block within does not appear to qualify the object name within 
--Process the staging batch
EXECUTE stg.udp_XXX_Leaf @VersionName, @LogFlag, NULL, @NewBatchID;
Thursday, December 08, 2011 7:12 PM
Thanks very much for the detailed report. We have an open bug for this issue -- I will add your extra info to the bug report.
This posting is provided "AS IS" with no warranties, and confers no rights