1 Reply Latest reply on Jan 24, 2018 8:57 AM by lenaic.ridinger

    Tableau Refresh error

    Dilpreeth P

      Hi All,

       

      I am getting an error as shown below while trying to create an extract in Tableau connected to Oracle database.

       

        • 1. Re: Tableau Refresh error

          Hi Dilpreeth,

           

          ORA-03113 is a catch-all type error for any problem interrupting an Oracle session.

          To solve this, please refer to the steps below and let me know if you need further assistance

           

          Step 1

          From the Tableau Desktop start page, select Connect to Data.

          Step 2

          On the Connect page, click Oracle, then click OK.

          For more information about completing the connection steps, refer to the Oracle Database topic in the Desktop Help.

          Step 3

          1. In the join area, hover over the Custom SQL table until the edit icon displays, and then click the icon.
          2. Copy the query in the Edit Custom SQL dialog box.

          SELECT "NumericBins", "Key" as "Key",
          "NumericBins", "Measure E-2" AS "Measure E-2",
          "NumericBins", "Measure E-1" AS "Measure E-1",
          "NumericBins", "Measure E+0" AS "Measure E+0",
          "NumericBins", "Measure E+1" AS "Measure E+1",
          "NumericBins", "Measure E+4" AS "Measure E+4",
          "NumericBins", "Measure E+7" AS "Measure E+7"
          FROM "TestV1", "NumericBins" "NumericBins"

          Where "TestV1" is the name of your connection in Tableau.

          Step 4

          In a SQL session connected to this database, paste and run the query. The expected response is error ORA-7445: exception encountered: core dump, which confirms that the problem is ORA-3113, as expected.

           

          More details: Troubleshooting Oracle Connection Errors | Tableau Software

           

          ----------

          Lénaïc RIÉDINGER, Global Community Engineer Tableau

          Tableau Community Forums | Knowledge Base

          If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!