locked
Error publishing business rule, operator: must contain the pattern RRS feed

  • Question

  • Hello,

    They help me with an error that shows me the Master Data Services of SQL Server 2016, when trying to create a business rule with the operator must contain the pattern. When you publish the business rule, it displays the error: 102: A database error has occurred. Contact your system administrator.

    Reviewing the Master Data Service log shows the error:

    --proc, server , database MDS. Error: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ','.
    Incorrect syntax near ')'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.MasterDataServices.Core.DataAccess.DbHelper.<>c__DisplayClasse.<>c__DisplayClass11.<ExecuteNonQuery>b__d()
       at Microsoft.MasterDataServices.Core.DataAccess.MdsDbUtilities.ExecuteMethodWithRecoverableErrorRetry(MethodDelegate method)
       at Microsoft.MasterDataServices.Core.DataAccess.DbHelper.<>c__DisplayClasse.<ExecuteNonQuery>b__c(SqlConnection connection)
    ClientConnectionId:b1eb6dee-06d1-4a4e-82bc-d9990c518845

    Ing. Allen Quiros SQL Server MCP

    Wednesday, November 30, 2016 11:02 PM

Answers

All replies