community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Error: "SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE')" when connecting to DB2 using the Input Data tool

gtorres8
Alteryx Alumni (Retired)
Created

‎07-22-2020 12:17 AM - edited ‎08-23-2021 08:49 AM

When trying to pull data from a DB2 database via the Input Data tool, the following error occurs:

 

Connection Error:
ERROR [08001] [IBM][CLI Driver] SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE'). SQLSTATE=08001.


 

idea Skyscrapers
 

  • Alteryx Designer
    • All Versions
  • DB2 ODBC Driver
    • Version 11.1


 

SQLSTATE = 08001 indicates the client is unable to establish connection due to:
  • Permissions issue.
  • Firewall issue.


1. Delete the existing DSN for DB2.

2. Re-open Alteryx Designer with the Run As Administrator option.

3. Create a new System DSN for DB2. If the DSN tests OK, re-test pulling data from the Input Data tool.

If the DSN doesn't test OK; reconfigure the Windows firewall on the DB2 server per the IBM KB article.

 

Additional Information

Appendix of ODBC error codes.


 

null
Labels