Using the JDBC operator in ITPAM and connecting to an AS400 database, if the database password is invalid, the ITPAM process hangs and never returns an error.

book

Article ID: 50617

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Process Automation Base

Issue/Introduction

Description:

If you pass an invalid password to an AS400 database via a JDBC driver, a dialog box appears saying an invalid password was given. This dialog box is behind the scenes in an ITPAM process so the process will sit waiting for the user to click ok on a dialog that they cannot see.

Solution:

To avoid this hanging ITPAM process when an invalid password is given, add the option "prompt=false" to the JDBC URL in the JDBC operator.

Environment

Release:
Component: ITPAM