9 Replies Latest reply on Jun 9, 2017 2:23 PM by vasudha.sripuram.0

    Error while loading the data

    vasudha.sripuram.0

      Hi All,

       

      I get the below message when I try to create a live connection .

       

      show details gives the below message:-

       

      Oracle database error 600: ORA-00600: internal error code, arguments: [15803], [16], [], [], [], [], [], [], [], [], [], []

       

      show query gives the below message:-

       

      SELECT *

      FROM (SELECT "TableauSQL"."f" AS "f",

        "TableauSQL"."f1" AS "f1",

        "TableauSQL"."f2" AS "f2",

        "TableauSQL"."f3" AS "f3",

        "TableauSQL"."f4" AS "f4

      FROM (

        select * from schema.view

      ) "TableauSQL")

      WHERE ROWNUM <= 10000

       

      The view has around 4 million records. But the other view with more records works fine.

      What does the error message mean and how can I resolve this?

       

      Thanks!!

       

       

        • 1. Re: Error while loading the data
          Hari Ankem

          Check if your query is working in Oracle. If yes, then see if you are doing any aggregations or using other functions and have not provided an alias for those columns.

          • 2. Re: Error while loading the data
            vasudha.sripuram.0

            Thank you for the response.

            Its a view and yes it does work perfectly when I execute a select * on that view in Toad?

            Are there any other options we can try?

            • 3. Re: Error while loading the data
              Hari Ankem

              Are you doing any aggregation or using a function and have not provided an alias for the column?

              Any column being fetched twice or 2 columns having the same alias?

               

              Share the query here.

              • 4. Re: Error while loading the data
                DEEPAK SADANAND

                Hello Vasudha,

                 

                I faced a similar issue while sourcing from a DB2 view when a column name in the view was changed at a later point of time. Not sure if your situation is the same still will share how I fixed my issue.

                 

                So when you initially loaded it Tableau would have assigned a field name to it and now though the column name may have changed/removed in the view it would still be mapped to the previous column name.

                 

                Click on the "Manage Metadata" icon in the data source tab, this will list the Field Name (used in Tableau), Table/View name and Remote Field Name (column names in the view). Review it to see if there is any Remote Field Name that can no longer be located in the view. Remove/Rename it and try refreshing again.

                 

                Thanks,

                Deepak

                • 5. Re: Error while loading the data
                  vasudha.sripuram.0

                  Thanks you for the response.

                  Although I was not able to find "Manage Metadata" icon in the data source I did try clicking on show query icon of the error message when trying to Preview results in tableau and it did show me the entire query with column names.I did a Desc of the view in toad and validate the data fields and they perfectly match??Any other thoughts why this might be the case?

                   

                  Thanks!!

                  • 6. Re: Error while loading the data
                    Hari Ankem

                    Do you have any issue with sharing the query here?

                    • 7. Re: Error while loading the data
                      vasudha.sripuram.0

                      Its a select * from V5 which is a nested view of 4 other views. Not complex but simple calculations inculcated within the view .Please find a sample below.

                       

                      CREATE OR REPLACE VIEW schema_V5

                      (

                      DATE,

                      ID,

                      CODE,

                      APPL,

                      CHANNEL,

                         CTYPE,

                         CID,

                         SID,

                         UID,

                         OID,

                         START_TIME,

                         END_TIME,

                         D_SEC,

                         O_SEC

                      )

                      AS

                         SELECT  DATE,

                        ID,

                         CODE,

                        APPL,

                         CHANNEL,

                         CTYPE,

                         CID,

                         SID,

                         UID,

                         OID,

                         START_TIME,

                         END_TIME,

                         D_SEC,

                                (CASE

                                    WHEN TRUNC (START_TIME, 'DD') = TRUNC (END_TIME, 'DD')

                                    THEN

                                       ROUND ( (END_TIME - START_TIME) * 86400, 3)

                                    ELSE

                                       NULL

                                 END)

                                   O_SEC

                           FROM ( (SELECT  DATE,

                                             ID,

                                              CODE,

                                               APPL,

                                          (CASE

                                              WHEN CHANNEL = '*' THEN NULL

                                              ELSE CHANNEL

                                           END)

                                            CHANNEL,

                                           CTYPE,

                                           CID,

                                           SID,

                                           UID,

                                           OID,

                                           START_TIME,

                                           END_TIME,

                                           D_SEC,

                                           O_SEC

                                     FROM (  SELECT MAX (DATE) DATE,

                                                    ID,

                                                    CODE,

                                                    MAX (APPL) APPL,

                                                    MAX (NVL (CHANNEL, '*')) CHANNEL,

                                                    MAX (CTYPE) CTYPE,

                                                    MAX (NVL (CID, '*')) CID,

                                                    MAX (NVL (SID, '*')) SID,

                                                    MAX (NVL (UID, '*')) UID,

                                                    OID,

                                                    MIN (START_TIME) START_TIME,

                                                    MAX (END_TIME) END_TIME,

                                                    MAX (D_SEC) D_SEC, O_SEC

                                               FROM VW4

                                              WHERE OID IS NOT NULL

                                           GROUP BY BID, CODE, OID))

                                 UNION ALL

                                 (SELECT  DATE,

                      ID,

                      CODE,

                      APPL,

                      CHANNEL,

                         CTYPE,

                         CID,

                         SID,

                         UID,

                         OID,

                         START_TIME,

                         END_TIME,

                         D_SEC,

                         O_SEC

                                    FROM VW4

                                   WHERE OID IS NULL));

                       

                      Thanks!!

                      • 8. Re: Error while loading the data
                        Hari Ankem

                        1. DATE is actually a keyword, so you should not be using it as is. That could be one of the causes.

                        2. You have union all, so hope you have the right data types in each of the columns being unioned.

                        3. When you are doing a CASE statement or using a function on a column name, the alias of the derived column is the column name itself. This is not recommended.