Please refer this article if the cube build fails with the below error,
ERROR [main] impl.CubeBuildExecutor:150 : INFOWORKS: Cube build failed! ERROR [main] impl.CubeBuildExecutor:152 : io.infoworks.cube.exception.CubeBuildExecuteException: Failed to load starschema tables
The loading of StarSchema is failing mainly because of the improper configurations set inside env.sh file located in $IW_HOME/bin/.
The above error message usually is seen when HCAT_HOME variable is not set in env.sh file.
Follow the below steps to resolve the issue,
HCAT_HOME by defaults point to the $HIVE_HOME/HCatalog. We can check the path set to HCAT_HOME by running the below command in Cluster
Copy the respective HCAT_PATH and add the entry in env.sh
Execute the below commands
cd $IW_HOME/bin source env.sh ./stop.sh hangman cube-engine ./start.sh hangman cube-engine
Go to the Infoworks ADE and re-run the failed Cube Build job, This build should be successful.