SQL Server Performance Forum – Threads Archive

Problem with RT cubes

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.

---

try this link:
http://www.sqlmonster.com/Uwe/Misc/SR.aspx?p=internal query processor error

---

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

---

]]>