2 Replies Latest reply on Sep 17, 2012 9:17 AM by Prashanth Shenoy

    Error while creating an Extract

    Prashanth Shenoy

      Hi,

       

      I am trying to create and extract, but the creation fails with the below error.

       

      Looks like Tableau is writing a SQL with a big Nested Case expression due to which it fails, since 'Case expressions may only be nested to level 10.'

       

      SQL Server database error 0x80040E14: Incorrect syntax near 'TableauSQL'.

      SQL Server database error 0x80040E14: Incorrect syntax near the keyword 'CASE'.

      SQL Server database error 0x80040E14: Case expressions may only be nested to level 10.

       

       

      Error retrieving collation for [sqlserver.41088.764154317134].[Compliance_Filter].

      Unable to create extract

       

      Has anyone encountered this error or has any idea about how to resolve this ? Please help

       

      Thanks,

      Prashanth