The hdbsetup has UR : Upgrade SCM Repository option, which creates a $CA_SCM_HOME/updateschema.log, but if an error happens, sometimes there is not sufficient information about the error to diagnose and correct the problem. How can additional logging be enabled for hdbsetup?
Harvest Software Change Manager
A parameter must be set in the HServer.arg file to increase the logging level.
In the $CA_SCM_HOME folder (%CA_SCM_HOME% for Windows) edit the Hserver.arg file and add the following line:
-logging=5
Save and close the file, then exit HDBSetup and restart it. When you run the upgrade again with option “UR”, additional logging will be added to the updateschema.log file.
More information about HDBSetup can be found here: The hdbsetup Database Configuration Utility
More information about where to find the log files is here: Location of the Harvest log files