In environments that have been upgraded from 2.2.0 to 2.3.0 or 2.3.0.1, network functions may fail during workflow instantiation.
This can be confirmed by checking the upgrade log located in /opt/vmware/upgrade.log and searching for the following SQL exception:
ERROR: unsupported Unicode escape sequence
Detail: \u0000 cannot be converted to text.
2.2, 2.3, 2.3.0.1
Resolved in TCA 2.3.1.
1. Download the attached recover_recipe_data.py script.
2. SSH as admin into the TCA Manager appliance observing the issue and switch user to root.
3. Copy the recover_recipe_data.py script into the /home/admin directory of the TCA Manager.
4. Restart the postgress-tca-config service to re-populate the built-inside recipes/ingredients.systemctl restart postgres-tca-config
5. Run the script to repopulate the recipe from the CSARs in objectstore.files collection:python3 recover_recipe_data.py
1. Download the attached clean_mongo.py script.
2. SSH as admin into the TCA Manager appliance observing the issue.
3. Copy the clean_mongo.py script into the /home/admin directory of the TCA Manager.
4. Run the script to clean the mongo collection “SiteLevelManagementRecipes”:python3 clean_mongo.py
5. SSH as admin into the TCA-CP appliance observing the issue.
6. Copy the clean_mongo.py script into the /home/admin directory of the TCA-CP.
7. Run the script to clean the mongo collection “SiteLevelManagementRecipes”:python3 clean_mongo.py
Impact/Risks:
TCA 2.2.0, 2.3.0 and 2.3.0.1. Does not impact 3.0.