Products | Versions |
---|---|
TIBCO Cloud Integration - Connect ( Scribe ) | - |
Below is an example of the error you may receive.
The reason for the error is the user (or the role the user belongs to) does not have permissions to retrieve property or relationship information in SQL Server.
This could be at the database or table level.
TIBCO Scribe® Online requires View Definition permission in SQL Server in order to retrieve this information.
SQL Server usually grants this permission when creating a user so this may only be encountered where security is set at a more granular level.
Message: Fetch properties and relationships 1st retry error:
Exception Type : PropertyCannotBeRetrievedException
Message : Property Text is not available for DefaultConstraint '[DF__ACCOUNT__SUMMARY__108B795B]'.
This property may not exist for this object, or may not be retrievable due to insufficient access rights.