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
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.
Incoming Null data is being loaded to an Oracle table that has NOT NULL constraints.
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.
(Ask the Oracle DBA for the exact value.)
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.
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.
Attempt to schedule data intensive workflows for the weekends or late nights when network and VPN loads are minimal.
Alteryx Community Post