Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Intermittent issue "Unknown Database 'dbname'" when connecting to an Amazon Aurora database via Oracle MySQL Connector

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Intermittent issue "Unknown Database 'dbname'" when connecting to an Amazon Aurora database via Oracle MySQL Connector


Solution:

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.

Related articles