Metadata reset failed message in SQL connection
Article ID: KB0077611
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | V2 |
Description
Issue: I have a SQL connection that is used in several Maps. After adding a new field in SQL, I select my SQL Connection from within the Map, choose “Reset Metadata” from the Gear menu, and the following message displays:
Metadata reset failed. Cannot reset metadata while another outstanding request is gathering metadata. Please retry.
Restarting the Agent did not resolve the issue. The Agent log contains the following error:
Resolution: Contact your SQL Database Administrator to assist, and confirm that user for the SQL Connection has adequate permissions to the database. For this example, re-adding the SQL user to the database resolved the permissions issue and “Reset Metadata” succeeded.
Scribe Online help reference: Connector For Microsoft SQL Server
Metadata reset failed. Cannot reset metadata while another outstanding request is gathering metadata. Please retry.
Restarting the Agent did not resolve the issue. The Agent log contains the following error:
Message: Fetch properties and relationships 1st retry error:
Exception Type : PropertyCannotBeRetrievedException
Message : Property Text is not available for DefaultConstraint '[xxxx_sample_connection]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
Resolution: Contact your SQL Database Administrator to assist, and confirm that user for the SQL Connection has adequate permissions to the database. For this example, re-adding the SQL user to the database resolved the permissions issue and “Reset Metadata” succeeded.
Scribe Online help reference: Connector For Microsoft SQL Server
Issue/Introduction
Attempt to reset the SQL connection metadata fails with message: Metadata reset failed. Cannot reset metadata while another outstanding request is gathering metadata.
Feedback
Yes
No
Powered by
