Product: TIBCO Spotfire®
Intermittent issue "Unknown Database 'dbname'" when connecting to an Amazon Aurora database via Oracle MySQL Connector
When connecting to an Amazon Aurora database instance using the TIBCO Spotfire Oracle MySQL connector, the following error may get displayed intermittently:
External error: Unknown database 'dbname' Data connection: Connection(number of connections open)
This is a common issue with Oracle MySQL in general and may have many root causes. But when it comes to an Amazon Aurora database and when this error is seen only intermittently, then this error is most often caused when you have the maximum number of connections open or if the Aurora instance CPU is at 100%.
To resolve the issue close the active connections that are previously open or increase the size of the Amazon Aurora instance.