SQL migration is failing due to spool file location
说明
SQL migration is failing due to spool file location. When I hardcode spool file location , it is succeeding. If we don't put spool file location, sql migration failed. Please refer attached debug log to troubleshoot this issue
原因
As the OA is mainly a Java process, the statctl.sh command from the STAT_HOME, does a ‘cd’ to the STAT_JAVA_HOME/bin and this is from where the Spool command is trying to write the file.
解决办法
Having said above, we have two options:
-Give write permission to STAT_JAVA_HOME/bin directory OR
-Hardcode the spool path in the .sql files that need to be spooled off.
其他信息
You can also decide to download open jdk in a separate location, point Stat to it and have the necessary permissions.
