locked
Error: The query processor could not produce a query plan RRS feed

  • Question

  • Hi,

    We have a issue with a MDS server that have been over us for a couple of days, the original error msg from SQL Server Engine is the one "The query processor could not produce a query plan" but the ones we get on the Excel-Addin are "Sequece contains no elements" or "The value cannot be null"

    Thank you in advance for all the help you can provide :P

    Using Microsoft SQL Server 2012 (SP1) - 11.0.3393.0 (X64) for 6months on this server without issues
    Two weeks ago we started to have 2 errors: "Sequence Contains No Elements" | "The Value Cannot Be Null"
    We are using the last version of Excel Add-in
    We try to reinstall the MDS feature
    If I backup/restore MDS database to other server it works
    We updated to SQL 2012 SP2 + CU4 but the error persisted ...


    Looking at the MDSTraceLog we are routed to the this msg

    SQL Error Debug Info: Number: 8624, Message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services., Server: bbdvsql03\inst01, Proc: udpMetadataEntityGetDetailsXML, Line: 28

    At line 28 udpMetadataEntityGetDetailsXML is calling udfMetadataEntityGetDetailsXML … and here is where we stopped

    ** Error found when try to get data from a entity using Excel add-in **
    ===================================

    Sequence contains no elements

    ------------------------------
    Program Location:

       at Microsoft.MasterDataServices.AsyncEssentials.AsyncResultBase.EndInvoke()
       at Microsoft.MasterDataServices.ExcelAddInCore.AsyncProviderBase`1.EndOperation(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.DataView.<>c__DisplayClass53.<LoadData>b__51(IAsyncResult ar)
       at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)


    ** From SQL Server Profile using a Trace we can see this sp been called **
    exec mdm.udpObjectInformationLookup 
    exec mdm.udpEntityMembersGet 


    ** Log from the MdsTraceLog **

    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.ExecuteXmlDeserializer[T](String sprocName, CloseConnectionBehavior closeBehavior, Object[] parameterValues)
       at Microsoft.MasterDataServices.Core.DataAccess.DbHelper.ExecuteXmlDeserializer[T](String sprocName, Object[] parameterValues)
       at Microsoft.MasterDataServices.Core.DataAccess.MdmDataAccess.GetList[T](Int32 userId, MemoryStream searchCriteria, MemoryStream resultOptions)
       at Microsoft.MasterDataServices.Core.BusinessLogic.MdmBusinessLogic`3.GetList(MetadataSearchCriteria searchCriteria, MetadataResultOptions resultOptions)
    SQL Error Debug Info: Number: 8624, Message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services., Server: bbdvsql03\inst01, Proc: udpMetadataEntityGetDetailsXML, Line: 28

    ** Error found then we try to create a new entitie using Excel Add-in **
    ===================================

    The value cannot be null.

    ------------------------------
    Program Location:

       em Microsoft.MasterDataServices.ExcelAddInCore.PublishEntity.CreateEntityImpl(CreateEntityInfo info)
       em Microsoft.MasterDataServices.ExcelAddInCore.PublishEntity.<>c__DisplayClass3.<CreateEntity>b__0(CreateEntityInfo createEntityInfo)

    ===================================

    The value cannot be null. (Microsoft.MasterDataServices.ExcelAddInCore)

    ------------------------------
    Program Location:

       em Microsoft.MasterDataServices.ExcelAddInCore.PublishEntity.<>c__DisplayClasse.<CreateEntityImpl>b__9()

       
    ** Log from the MdsTraceLog **
       
        DateTime=2015-07-09T11:19:42.3647755Z
    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.ExecuteXmlDeserializer[T](String sprocName, CloseConnectionBehavior closeBehavior, Object[] parameterValues)
       at Microsoft.MasterDataServices.Core.DataAccess.DbHelper.ExecuteXmlDeserializer[T](String sprocName, Object[] parameterValues)
       at Microsoft.MasterDataServices.Core.DataAccess.MdmDataAccess.GetList[T](Int32 userId, MemoryStream searchCriteria, MemoryStream resultOptions)
       at Microsoft.MasterDataServices.Core.BusinessLogic.MdmBusinessLogic`3.GetList(MetadataSearchCriteria searchCriteria, MetadataResultOptions resultOptions)
    Informações de Depuração de Erro de SQL: Número: 8624, Mensagem: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services., Servidor: bbdvsql03\inst01, Proc: udpMetadataAttributeGroupGetDetailsXML, Linha: 27

    Sunday, July 19, 2015 9:23 PM

Answers

All replies