When running automations, if a routine accesses a database where the password
expired, you get the normal popup window indicating that you must change your
password. Normally, this window appears when connecting ad-hoc to a database,
thus you know which password you need to change.
If Automations are running and they encounter a password expired, 2 things
happen which must be addressed:
- The automation hangs (you have to dig to figure out which automation is
- need to create a log entry in the automation log indicating that a password
change was requested by the database, this was we can externall monitor the log
and send a notification if the log contains an entry “waiting for Password
2)The user has no idea which database is requesting the password change, hence
when returning to the screen, the popup is there, but which database password is
it requesting to change?
- need to identify the Connection Name in the Window Bar of the popup.