Missing Descriptions
Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).
The Problem: Missing descriptions on tables / fields with an InterSystems database.
The Solution:
The missing descriptions can be caused by two challenges:
1. The Connection Type to the database is Standard ODBC and is not InterSystems Cache or InterSystems IRIS. We only display the description for InterSystems databases and when those specific connection types are used.
2. Assuming the Connection Type is InterSystems, the user account in the Connection Profile does not have the permissions necessary to access the %Dictionary schema. %Dictionary is where the field definitions are stored and we're specifically executing this query to get the descriptions: SELECT PropertyDefinition.Description, PropertyDefinition.ID, PropertyDefinition.Name, PropertyDefinition.SqlFieldName FROM %Dictionary.PropertyDefinition PropertyDefinition
- If it is permissions related, you'll get an error trying to run this query using the Connection Profile's account. I believe we also log when there is a permissions issue getting the descriptions, so please review the logs as well.
Comments
0 comments
Please sign in to leave a comment.