Error: "ORA-12592: TNS:Bad Packet Error" occurs when running a workflow

[gtorres8]

Environment Details

When running a workflow, intermittently the following error occurs:
 

ORA-12592: TNS:Bad Packet Error
 

The error seems to be more prominent while on VPN.
 

• Alteryx Designer + Scheduler
  • All versions
• Oracle
  • 11g +

Cause

Cause 1

ORA-12592 is an Oracle network error that could be related to the network or the amount of data that is running through the workflow or both.

Cause 2

Incoming Null data is being loaded to an Oracle table that has NOT NULL constraints.

Resolution

Solution 1

Adjust Oracle parameters on the Oracle server. Contact the organization's IT team to help with any network monitoring and/or the Oracle DBA to adjust the following Oracle parameter in the SQLnet.ora file.

SQLNET.SEND_TIMEOUT=

(Ask the Oracle DBA for the exact value.)

Example:
SQLNET.SEND_TIMEOUT=600

 

Solution 2

If data coming into the workflow has null values and the Oracle table(s) constraints are set to NOT NULL; change the constraints to the table(s) to nullable. Please consult the Oracle DBA to make the change. See the Alteryx Community post for more information.

Workaround 1

Add the throttle tool to the workflow to control the amount of data that can pass through to downstream tools by dictating how many records are sent per minute; in case too much data is coming in at once. See the throttle tool help file for more information.
 

Workaround 2

Attempt to schedule data intensive workflows for the weekends or late nights when network and VPN loads are minimal.
 

Additional Information

Oracle documentation
Alteryx Community Post