We are running a Forms/Reports 12c (12.2.1.19) application against a 19c database on AWS.
The database is multi-AZ, AWS version of dataguard, but transparent to Forms/Reports - we always connect to the same connect string, AWS directs it to the primary/standby database.
When we failover from primary to standby Forms raises an FRM-92103 as expected, as the database session does not exist on the new database.
However, Reports just hangs, as though there is a timeout set too high. There are no error messages for the end user. The WLS_REPORTS.out file contains lots of ‘WAITING’ logs.
Where can I add a timeout for the database connection used by the in-process Reports Server so that when the database it times out and gives an error, or times out and reconnects to the standby automatically?