KNOWLEDGE BASE

Error "ORA-03137 malformed TTC packet from client rejected" When Connecting to an Oracle Database v12.2


Published: 12 Feb 2018
Last Modified Date: 28 Dec 2018

Issue

When Tableau Desktop and Tableau Server are connected to an Oracle Database v12.2, the following errors occur in the database logs:

"ORA-03137: malformed TTC packet from client rejected.
Bad TTC Packet Detected."

Environment

  • Tableau Desktop
  • Tableau Server
  • Oracle 12.2.0.1

Resolution

If you see this error, you must install the latest maintenance release on the Tableau computer connecting to the Oracle database and customize the TDC file hosted on the Tableau computer.

STEP 1
Upgrade Tableau to one of these versions: 10.3.13, 10.4.9, 10.5.6, 2018.1.3, or 2018.2.1 - or later. To install the latest releases, go here.

STEP 2  
Customize the TDC file hosted on Tableau, by adding the following mark up to the attached TDC file:  oracle2.tdc

 <connection-customization class='oracle' version='10.00' enabled='true'>

   <vendor name='oracle' />

  <driver name='oracle' />

   <customizations>

      <customization name='CAP_ORACLE_SUPPRESS_TTC_PACKET_ERROR' value='yes' />

      </customizations>

   </connection-customization>

STEP 3
The .tdc file should be copied to one of the following locations
, depending on both product and OS:

Tableau Desktop on Windows:
  • C:\Users\[user]\Documents\My Tableau Repository\Datasources\oracle2.tdc
Tableau Desktop on Mac:
  • /Users/[user]/Documents/My Tableau Repository/Datasources/oracle2.tdc
Tableau Server on Windows:
  • C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources\oracle2.tdc
Tableau Server on Linux:
  • /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/oracle2.tdc          

Cause

RPC calls in Tableau's Oracle OCI based connectors have been deprecated in Oracle 12.2.

Additional Information

Check for the TTC protocol internal error in the alert_orcl.log on the source database server: "ORA-03137: malformed TTC packet from client rejected. Bad TTC Packet Detected."

Discuss this article... Feedback Forum
Did this article resolve the issue?