Product: TIBCO Spotfire®
Error Message: "Cannot create marking. The external database table does not have a primary key".
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. 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: