Error Example:An error occurred while executing connection '<connectionName>': No primary key information available: There is no primary key specified for the table '<entityName>'! Please define a primary key for the table to make the records identifiable. Cause:Generally, this error is due to one of the following situations:
Resolution/Workaround:Make sure to go through these questions:
If you don't have a key listed at all in the Cloud Connector UI for that data entity, you must define one. There's no way around this. If you don't have a good option for a single field, you can use a combination of fields, separated by commas, to make a unique key. If you have a key defined within the data source but it's not included in the select statement, you need to add it there. If you don't have a key defined within the data source, you will need to add one there. This commonly occurs with MS SQL Server as it is looking for the defined key. If you have everything properly set up but are still getting the error, then see Error Reading Back Keys Because Table 'X' No Longer Has a Primary Key Defined for resolution information as the Metabase itself may be corrupted and need to be rebuilt. |