+------------------------------------------------------------------------------------------------------------------------ | Summary of install data +------------------------------------------------------------------------------------------------------------------------ [platform] os = Windows 10 os_arch = amd64 host = DESKTOP-MI2OTD6 ip = 192.168.0.160 java_home = C:\Program Files\Java\jdk-21 java_runtime_version = 21.0.5+9-LTS-239 java_vendor = Oracle Corporation user_name = rajrani user_home = C:\Users\rajrani user_country = IN [application] version = 2.7.3-SNAPSHOT name = JS7 JOC Cockpit install_path = C:\Program Files\sos-berlin.com\js7273\joc_2326 data_path = C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base with_root_permissions = no [license] type = Commercial key = C:\Users\rajrani\Documents\js7 license\sos_setup.pem [jetty] with_jetty = yes jetty_base = C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base jetty_port = 2326 jetty_stop_port = 20326 jetty_user = jetty_user_home = jetty_java_opt_xmx = 512 jetty_java_opt_xms = 128 jetty_java_opt_xss = 4000 jetty_java_options = installed_as_daemon = no with_jetty_start = yes [joc] id = joc#0 title = Primary security_level = LOW as_api_server = no [database] dbms = mysql url = jdbc:mariadb://localhost:3309/test1?serverTimezone=UTC dialect = user = test1 jdbc = internal_connector = yes hibernate_conf_file = C:\Users\rajrani\Documents\hibernate.cfg.xml with_create_tables = byInstaller +------------------------------------------------------------------------------------------------------------------------ | Set ACLs in C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base +------------------------------------------------------------------------------------------------------------------------ ... set read/write access for Windows service account in 'C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base' +------------------------------------------------------------------------------------------------------------------------ | Create some symlinks +------------------------------------------------------------------------------------------------------------------------ ... trying to create symlink C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base\joc_home -> C:\Program Files\sos-berlin.com\js7273\joc_2326 ... done. ... trying to create symlink C:\Program Files\sos-berlin.com\js7273\joc_2326\jetty_base -> C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base ... done. +------------------------------------------------------------------------------------------------------------------------ | Set Security Level: LOW +------------------------------------------------------------------------------------------------------------------------ ... done +------------------------------------------------------------------------------------------------------------------------ | Install Jetty base directory +------------------------------------------------------------------------------------------------------------------------ INFO : mkdir ${jetty.base}\start.d INFO : webapp transitively enabled, ini template available with --add-module=webapp INFO : ext initialized in ${jetty.base}\start.d\ext.ini INFO : server initialized in ${jetty.base}\start.d\server.ini INFO : servlet transitively enabled INFO : resources initialized in ${jetty.base}\start.d\resources.ini INFO : threadpool transitively enabled, ini template available with --add-module=threadpool INFO : rewrite initialized in ${jetty.base}\start.d\rewrite.ini INFO : deploy initialized in ${jetty.base}\start.d\deploy.ini INFO : logging-jetty transitively enabled INFO : security transitively enabled INFO : console-capture initialized in ${jetty.base}\start.d\console-capture.ini INFO : http initialized in ${jetty.base}\start.d\http.ini INFO : logging/slf4j transitive provider of logging/slf4j for logging-jetty INFO : logging/slf4j dynamic dependency of logging-jetty INFO : bytebufferpool transitively enabled, ini template available with --add-module=bytebufferpool INFO : copy ${jetty.home}\modules\logging\jetty\resources\jetty-logging.properties to ${jetty.base}\resources\jetty-logging.properties INFO : Base directory was modified ... done +------------------------------------------------------------------------------------------------------------------------ | Store internal JDBC drivers in C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base\lib\ext\joc +------------------------------------------------------------------------------------------------------------------------ -> ojdbc8-19.25.0.0.jar ... done -> mariadb-java-client-3.5.0.jar ... done -> postgresql-42.7.4.jar ... done +------------------------------------------------------------------------------------------------------------------------ | Configuration of ./resources/joc/joc.properties +------------------------------------------------------------------------------------------------------------------------ ... done +------------------------------------------------------------------------------------------------------------------------ | Copy hibernate configuration file C:\Users\rajrani\Documents\hibernate.cfg.xml to ./resources/joc/hibernate.cfg.xml +------------------------------------------------------------------------------------------------------------------------ ... done +------------------------------------------------------------------------------------------------------------------------ | Store license file in C:\ProgramData\sos-berlin.com\js7273\joc_2326\jetty_base\resources\joc\license +------------------------------------------------------------------------------------------------------------------------ ... done +------------------------------------------------------------------------------------------------------------------------ | Initial database +------------------------------------------------------------------------------------------------------------------------ ... the database management system is mysql ... create database tables which not already exist ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\authentication.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\daily_plan.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\deployment.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\encipherment.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\history.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\inventory.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\joc.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\monitoring.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\reporting.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\search.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\xmleditor.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\yade.sql processed successfully ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\authentication_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=922) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\daily_plan_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=933) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\daily_plan_order_variables_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=943) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... processing daily_plan_order_variables_clob_alter.sql might take some time ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\daily_plan_order_variables_clob_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=953) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\history_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=964) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... processing history_variables_clob_alter.sql might take some time ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\history_variables_clob_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=974) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\inventory_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=984) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\joc_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=994) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\monitoring_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=1004) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\monitoring_sn_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=1014) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... processing monitoring_variables_clob_alter.sql might take some time ... error occurred while executing C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\monitoring_variables_clob_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=1024) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\deployment_procedure.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\inventory_schedule2calendars_procedure.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\inventory_schedule2workflows_procedure.sql processed successfully ... insert initial rows into database tables ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\authentication_insert.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\inventory_insert.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\inventory_search_items_insert.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\joc_insert.sql processed successfully ... C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\key_insert.sql processed successfully ... done +------------------------------------------------------------------------------------------------------------------------ | Install/Update Jetty service for JS7 JOC Cockpit +------------------------------------------------------------------------------------------------------------------------ ...try to copy "C:\Program Files\sos-berlin.com\js7273\joc_2326\service\amd64\prunsrv.exe" to "C:\Program Files\sos-berlin.com\js7273\joc_2326\service\js7_joc_2326.exe" 1 file(s) copied. ...try to copy "C:\Program Files\sos-berlin.com\js7273\joc_2326\service\manager\prunmgr.exe" to "C:\Program Files\sos-berlin.com\js7273\joc_2326\service\js7_joc_2326w.exe" 1 file(s) copied. [2024-11-26 15:41:44] [info] [14104] Apache Commons Daemon procrun (1.3.1.0 64-bit) started. [2024-11-26 15:41:44] [info] [14104] Installing service 'js7_joc_2326' name 'SOS JS7 JOC (JS7 Operations Center) -id=joc_2326'. [2024-11-26 15:41:44] [info] [14104] Service 'js7_joc_2326' installed. [2024-11-26 15:41:44] [info] [14104] Apache Commons Daemon procrun finished. "js7_joc_2326" Service has been installed Please use "C:\Program Files\sos-berlin.com\js7273\joc_2326\service\js7_joc_2326w.exe" to change Service configurations +------------------------------------------------------------------------------------------------------------------------ | Start Jetty Windows Service for JS7 JOC Cockpit +------------------------------------------------------------------------------------------------------------------------ ... the Jetty won't be started due to a previous installation error: C:\Program Files\sos-berlin.com\js7273\joc_2326\db\mysql\authentication_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: -1 (conn=922) the given SQL statement produces an unexpected ResultSet object [EXECUTE statement] ... skipped +------------------------------------------------------------------------------------------------------------------------ | Create shortcuts +------------------------------------------------------------------------------------------------------------------------ ... done