Summary:

When switching Servers for TIBCO Scribe® Insight, or restoring to a previous version of the Internal Database, you may come across the error below
“An unexpected error occurred. There is no site key and only the Server_Owner can generate a new one. “



This is usually the result of the Internal Database trying to start services that are registered to a Server Name that is not currently recognized within the Scribe Internal Database.
 

Troubleshoot: 

Go to the Scribe Internal Database and run the below script to find what server name it’s currently recognized with:

SELECT * from SCRIBE.KSYNC with (nolock)
where KEYNAME = 'Server_Owner'


 

 

Resolution:

1. Run the ‘ClearScribeLicense.sql’ script located in the Scribe folder 'C:\Program Files (x86)\Scribe' against the Scribe Internal Database
2. From the Scribe folder, run the InternalDB.exe utility > Click on the Internal Database tab > Test Connection 
3. Stay on the Internal Database tab and click on Update Insight Server Name > Enter in the old Server name (Computer name) where Scribe  was installed, not the SQL Server name > Enter in the New Server name where Scribe is currently installed > Click Ok
4. Open the Workbench and go through the registration process.

When switching Servers for TIBCO Scribe® Insight, or restoring to a previous version of the Internal Database, you may come across the error below: “An unexpected error occurred. There is no site key and only the Server_Owner can generate a new one. “