Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
