Edit

Corrupted Global Variables Data Store

During development activities, the Global Variables Field Scheme can be accidentally modified in Control Tower (CT). As a result, ds_Global_Variables table appears in PostgreSQL, but no information about it is available in MySQL. This leads to sporadic CT behavior: a Business Process (BP) doesn't start and doesn't allow any actions, imported BPs have an empty Designer view, and so on. The environment virtually becomes unusable.

Solution

Since the environment is corrupted, it is not possible to modify or delete the Global Variables Data Store and the Global Variables Field Scheme from the CT user interface. Use the following workaround:

1. In PostgreSQL, drop the existing ds_Global_Variables and ds_Global_Variables_archive tables:

   ALTER TABLE "ds_Global_Variables" RENAME TO "ds_Global_Variables_bak";
   

2. In MySQL, delete the related records from DataStoreColumn, CampaignConfigurationDataStore, CampaignConfigurationParameter, and DataStore table:

   delete from CampaignConfigurationDataStore where dataStoreId=(select id from DataStore where name="Global Variables");
    delete from DataStoreColumn where dataStoreId=(select id from DataStore where name="Global Variables");
    delete from DataStore where name="Global Variables";
   

3. Restart CT. The clean Global Variables Data Store is created automatically upon restart.