6 Replies Latest reply on Jun 2, 2016 1:42 AM by Russell Christopher

    Getting an error while trying to create a simple dashboard using New Custom SQL

    satish.pandey

      Hi Team,

      I have a query which is running perfectly fine in Microsoft SQL Server. I am trying to create a dashboard using that sql however getting an error mentioned below.

       

      Error message - An error occured while communicating with data source 'Showdata'

       

      Below message is showing when i click on "Show details"

       

      [Microsoft][SQL Server Native Client 10.0][SQL Server]No column name was specified for column 13 of 'TableauSQL'.

      Unable to connect to the server "epm-pro-sqlreporting". Check that the server is running and that you have access privileges to the requested database.

       

      Query:

      =====

      SELECT

        AUSPEX_TB_WSSLIST_PROJECT_INFORMATION.PROJECT_CODE,

        AUSPEX_TB_WSSLIST_PROJECT_INFORMATION.DIVISION,

        AUSPEX_TB_WSSLIST_REVIEWS.REVIEW_ID,

        AUSPEX_TB_WSSLIST_REVIEWS.PERCENTAGE_NOT_COMPLIANT,

        AUSPEX_TB_WSSLIST_REVIEWS.PERCENTAGE_COMPLIANT,

        AUSPEX_TB_WSSLIST_APPROVAL_ROLES_RESULTS.APRESAPPROVEDDATE,

        AUSPEX_TB_WSSLIST_QUESTION_RESULTS.QRESSORTORDER,

        AUSPEX_TB_WSSLIST_QUESTION_RESULTS.QUESTION,

        AUSPEX_TB_WSSLIST_QUESTION_RESULTS.EXPECTEDANSWER,

        AUSPEX_TB_WSSLIST_QUESTION_RESULTS.ANSWER,

        AUSPEX_COMMENTS.CommentText,

        AUSPEX_TB_WSSLIST_QUESTION_RESULTS.ANSWEREDBY,

        CONVERT(DATETIME,AUSPEX_TB_WSSLIST_QUESTION_RESULTS.ANSWEREDDATE) ,

        AUSPEX_TB_WSSLIST_QUESTION_RESULTS.COMPLIANCESTATE

      FROM

        AUSPEX_TB_WSSLIST_PROJECT_INFORMATION LEFT OUTER JOIN AUSPEX_TB_WSSLIST_REVIEWS ON (AUSPEX_TB_WSSLIST_PROJECT_INFORMATION.PROJ_UID=AUSPEX_TB_WSSLIST_REVIEWS.PROJECT_GUID)

         LEFT OUTER JOIN AUSPEX_TB_WSSLIST_QUESTION_RESULTS ON (AUSPEX_TB_WSSLIST_REVIEWS.REVIEW_ID=AUSPEX_TB_WSSLIST_QUESTION_RESULTS.FORMID  AND  SUBSTRING(AUSPEX_TB_WSSLIST_QUESTION_RESULTS.FORMID,1,3) = 'REV')

         LEFT OUTER JOIN AUSPEX_COMMENTS ON (SUBSTRING(AUSPEX_TB_WSSLIST_QUESTION_RESULTS.FORMID,1,3) = 'REV'  AND  AUSPEX_TB_WSSLIST_QUESTION_RESULTS.FORMID=AUSPEX_COMMENTS.FormID and AUSPEX_TB_WSSLIST_QUESTION_RESULTS.QRES_ID=AUSPEX_COMMENTS.QuestionResultID)

         LEFT OUTER JOIN AUSPEX_TB_WSSLIST_APPROVAL_ROLES_RESULTS ON (AUSPEX_TB_WSSLIST_REVIEWS.REVIEW_ID=AUSPEX_TB_WSSLIST_APPROVAL_ROLES_RESULTS.APRESFORMID  AND  AUSPEX_TB_WSSLIST_APPROVAL_ROLES_RESULTS.APRESCONFIGURATIONTYPE='Review')

       

      WHERE

        (

         AUSPEX_TB_WSSLIST_REVIEWS.FORM_STATUS  IN  ( 'Signed Off'  )

         AND

         CASE WHEN AUSPEX_TB_WSSLIST_REVIEWS.WITHDRAWN = 1 THEN 'Y' ELSE 'N' END  IN  ( 'N'  )

        )