Cloned Databases Not Being Unique

When copying databases, it is extremely important to delete the GUID value in the new (copied) database. If not deleted, the hub will assume that the two environments are the same, leading to confusing environment records.

To resolve this, set the value of the GUID field in the PSOPTIONS table to <space> in the new database. You can insert the blank value in the PSOPTIONS table using the SQL tool at your site. The next time an application server connects to the database, the system generates a new, unique GUID.