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.

Document ID : KB000050617
Last Modified Date : 14/02/2018
Show Technical Document Details

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.