Fetch properties and relationships or Property Text is not available error in the SQL Server connector

Fetch properties and relationships or Property Text is not available error in the SQL Server connector

book

Article ID: KB0078218

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) -

Description

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. 

 
 

Issue/Introduction

This error can get generated in a SQL Server Query block when trying to preview data