We have recently migrated the SharePoint 2010 services to SharePoint 2016 using standard Microsoft SharePoint recommendations like content database backup and restore model. As part of it, we have migrated the Secure Store Service and Business Data Connectivity service.
External content types came across and they are working, however, whenever anyone tries to refresh the external content type from list's External Data column, it is saying "XX Item(s) could not be refreshed because you do not have permissions on the external content type".
I have verified all the configurations and permissions for BDC service and finally went to "Secure Store Service" and I am seeing "Unable to obtain master key" error message.
I do not know the old pass phrase to refresh the key. What is the right way to fix this problem?
What is the impact of creating a new "Secure Store Service"? What is the additional work that needs to be done if we create new secure store service?