Generated query too big for SQL to handle RRS feed

  • Question

  • Hi All,

    All of a sudden, I cannot process a cube as a result of this error message:  

    OLE DB error: OLE DB or ODBC error: Incorrect syntax near the keyword 'AS'.; 42000; The character string that starts with '

        SELECT [AverageAnnualValue] AS [dbo_ContractsAverageAnnualValue0_0],[AverageGuaranteed] AS [dbo_ContractsAverageGuaranteed' is too long. Maximum length is 8000.; 42000.

    It appears that the string MSAS creates to process the cube is too big for SQL to handle. Any ideas on how to fix something like this?  I'm using the UDM in a big way and can't really reduce the amount of code.



    Friday, January 30, 2009 8:52 PM

All replies

  • Was the "]" not copied from the error message here or is actually missing in the error message itself? I mean, it should be "[dbo_ContractsAverageGuaranteed]" and not "[dbo_ContractsAverageGuaranteed" ?
    Saturday, January 31, 2009 7:32 AM