SQL Server Performance

Problem with RT cubes

Discussion in 'Analysis Services/Data Warehousing' started by jorge27, Nov 28, 2005.

  1. jorge27 New Member

    Hi experts!

    I have designed a ROLAP cube with real-time updates option enabled. The cube is correctly processed but now I have a problem when inserting new records on the source database. SQL Server returns me the following error:

    Server: Msg 8623, Level 16, State 1, Line 1 Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.

    I have realized that when designing the storage with very few aggregations (less than 50) the error is not raised and inserts are correctly processed. But I cannot set such a low number of aggregations because the performance is very poor.

    I am using SQL Server 2000 SP4. SP4 for AS is also installed. I have searched on MSDN but there is not a lot of information about this error.

    Any idea? Thanks

    Regards,
    Jorge.
  2. ranjitjain New Member

  3. jorge27 New Member

    Ranjit

    I have checked all the information on the link you refer and there is nothing similar to my current problem. But there I have found a topic about a reported Microsoft's bug that is probably related:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;310714

    It describes a bug about using DBCC DBREINDEX on indexed views, that produces the error I get. I am not sure if when I try to insert a record on a table, the indexes on views are rebuilt and how. But if SQL Server is internally using DBCC DBREINDEX, then this could be cause of the error I get.

    I will go on doing some more testing about the issue.

    Thanks,
    Jorge

Share This Page