ITM Agent Insights: Configuring federation for the Capacity Planner for VMware FAILS
ssnachan 0600020S7X Visits (7832)
This blog explains the steps to resolve the federation failure when you have a special character in your Tivoli Data Warehouse password. While configuring homogeneous federation for the Capacity Planner for VMware, you get the following error while executing the fed_admin.sh script. (federating TADFDCDB and WAREHOUS databases.)
TADFDCDB => Capacity planner database
WAREHOUS => Tivoli data warehouse
SQL0104N An unexpected token "!" was found following "<identifier>".
The link from the user guide which describes the configuration are as follows: http
The execution of Step 5. and 6. fails when the password for WAREHOUS contains a special character e.g.: "!". The special characters cannot be handled by the fed_admin.sh script at this time. I have opened a Documentation APAR which references the following BLOG as a solution. The solution ONLY applies to WAREHOUS password with special character. For all other cases, the steps mentioned in the user guide should work.
To resolve the issue specify the password as follows in the fed_config.cfg
# instance owner name of capacity planner database.
NOTE: There are NO quotes while specifying TDW_
Also, the following command fails outside the script with the error highlighted:
In order to ensure the federation completed successfully you can check for the existence of views and data in respective views by connecting to ‘TADFDCDB’ database.
TADFDC.MES_VM_CPU_W (_W stands for weekly, similarly the other summarization view names would be suffixed with _D, _H, _Y as per summarization at ITM end)
This should also confirm the configuration for federation completed successfully.
Subscribe and follow us for all the latest information directly on your social feeds: