RC0 MDS Entity Name with Space Causing error in BR

Question

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;

 

Thanks, BVR.

Answer 1

Hi BVR,

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.

Thanks,

Mark

---

This posting is provided "AS IS" with no warranties, and confers no rights