Error Message: "Cannot create marking. The external database table does not have a primary key" when using a Spotfire Connector
Article ID: KB0071053
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connectors | 7.5 and higher |
Description
While marking the data in a visualization that is sourced from a data connection(connector), you may get an error message "Cannot create marking. The external database table does not have a primary key".
This error indicates that a primary key is not defined/present for the desired data table. For making use of marking, the primary key should be present/defined for that data table.
This error indicates that a primary key is not defined/present for the desired data table. For making use of marking, the primary key should be present/defined for that data table.
Issue/Introduction
Error Message: "Cannot create marking. The external database table does not have a primary key" when using a Spotfire connector.
Environment
All
Resolution
TIBCO Spotfire Analyst 7.5 onwards, a new feature has been introduced which allows you to explicitly define a primary key when selecting the desired data table inside the data connection:
1) While making use of a custom query, define a primary key explicitly.
2) If the underlying data table does not have any predefined primary key, you can set the primary key inside the data connection window as per your requirement. Below is the screenshot for the reference:
1) While making use of a custom query, define a primary key explicitly.
2) If the underlying data table does not have any predefined primary key, you can set the primary key inside the data connection window as per your requirement. Below is the screenshot for the reference:
Additional Information
Details on Views in Connection, Spotfire Analyst User's Guide
Feedback
Yes
No
Powered by
