2023-05-15 15:35:19,784  INFO AppServer:271 - ---------------------------------------------------------------------- [WrapperSimpleAppMain]
2023-05-15 15:35:19,803  INFO AppServer:272 - --- Starting PaperCut NG Application Server - 17.4.4 (Build 42563) --- [WrapperSimpleAppMain]
2023-05-15 15:35:19,806  INFO AppServer:273 - ---------------------------------------------------------------------- [WrapperSimpleAppMain]
2023-05-15 15:35:20,058  INFO AppServer:132 - Starting application server version: 17.4.4 (Build 42563), Edition: NG, Platform: Windows Server 2016 - 10.0 64-bit [runtime: 1.8.0_131-b11 (amd64)], User: SYSTEM [WrapperSimpleAppMain]
2023-05-15 15:35:20,123  INFO AppServer:191 - System details - max memory: 3,600.0 MB, processors: 4, database: Derby, home: "C:\Program Files\PaperCut NG\server", free space: 102,433.5 MB, hostname: mswin-ADFS, IP addresses: [10.0.1.16, fe80:0:0:0:564:841b:b414:946%eth1] (Primary: 10.0.1.16), Server ID: 09fa8b07-a5a3-46f7-98ee-48e2974bbd35, time-zone: UTC, calendar: GregorianCalendar, locale: en_US, encoding: windows-1252 [WrapperSimpleAppMain]
2023-05-15 15:35:20,128  INFO AppServer:140 - System runtime arguments: [-Djava.io.tmpdir=tmp, -Dserver.home=., -Xverify:none, -XX:+UseParallelOldGC, -Dpc-reserved=X, -Dpc-reserved=X, -Dpc-reserved=X, -Dpc-reserved=X, -Dpc-reserved=X, -Xrs, -Dpc-reserved=X, -XX:+PrintGCDetails, -XX:+PrintGCApplicationConcurrentTime, -XX:+PrintGCApplicationStoppedTime, -XX:+PrintGCTimeStamps, -XX:+PrintGCDateStamps, -XX:+UseGCLogFileRotation, -XX:NumberOfGCLogFiles=10, -XX:GCLogFileSize=1M, -Xloggc:logs/gc.log, -Dlog4j.configuration=file:lib/log4j.properties, -Djava.library.path=bin/win/lib64, -Dwrapper.key=xMvzunt69uCEgQC5, -Dwrapper.port=32000, -Dwrapper.use_system_time=TRUE, -Dwrapper.version=3.1.2, -Dwrapper.native_library=wrapper, -Dwrapper.service=TRUE, -Dwrapper.cpu.timeout=10, -Dwrapper.jvmid=1] [WrapperSimpleAppMain]
2023-05-15 15:35:20,130  INFO AppServer:148 - *** Preparing database connection *** [WrapperSimpleAppMain]
2023-05-15 15:35:22,653  INFO AppServer:382 - Database: Apache Derby, Version: 10.13.1.1 - (1765088) [WrapperSimpleAppMain]
2023-05-15 15:35:22,832  INFO LiquibaseSchema:274 - Checking Liquibase schema using changelog: C:\Program Files\PaperCut NG\server\lib\sql\changelogs\db.changelog-master.yaml [WrapperSimpleAppMain]
2023-05-15 15:35:23,013  INFO AppServer:159 - *** Starting web server *** [WrapperSimpleAppMain]
2023-05-15 15:35:23,207  INFO Jetty:339 - Starting server listener with configuration (Port: 9191 IdleTime: 30000 Connector: ServerConnector) [WrapperSimpleAppMain]
2023-05-15 15:35:23,229  INFO Jetty:289 - Configured SSL settings with protocols: [SSLv3, TLSv1, TLSv1.1, TLSv1.2, SSLv2Hello] and 35 ciphers [WrapperSimpleAppMain]
2023-05-15 15:35:23,232  INFO Jetty:339 - Starting server listener with configuration (Port: 9192 IdleTime: 30000 Connector: ServerConnector) [WrapperSimpleAppMain]
2023-05-15 15:35:47,607  INFO ModuleRegistry:47 - Registered module with URI prefix toshiba and annotation Toshiba [WrapperSimpleAppMain]
2023-05-15 15:35:54,546  INFO ToshibaDeviceTypeRegistration:183 - Adding Toshiba device types dynamically [WrapperSimpleAppMain]
2023-05-15 15:35:54,598  INFO ToshibaDeviceTypeRegistration:297 - Toshiba device types added. (including v3+) [WrapperSimpleAppMain]
2023-05-15 15:35:54,846  INFO XeroxDeviceTypeRegistration:133 - Adding Xerox device types dynamically [WrapperSimpleAppMain]
2023-05-15 15:35:54,985  INFO ModuleRegistry:47 - Registered module with URI prefix xerox and annotation Xerox [WrapperSimpleAppMain]
2023-05-15 15:35:57,663  INFO SystemManagerImpl:532 - ********  License Details License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] ******** [WrapperSimpleAppMain]
2023-05-15 15:35:57,665  INFO SystemManagerImpl:533 - Support ID - T2023-05-15 [WrapperSimpleAppMain]
2023-05-15 15:35:57,703  INFO SystemManagerImpl:1064 - Updated modified_ticks to 1684164957677) [WrapperSimpleAppMain]
2023-05-15 15:35:57,704  INFO SystemManagerImpl:1071 - Unlinking groups from deleted printers [WrapperSimpleAppMain]
2023-05-15 15:35:59,866  INFO HpModule:41 - HP (FutureSmart 4+) module init... [WrapperSimpleAppMain]
2023-05-15 15:35:59,866  INFO ModuleRegistry:47 - Registered module with URI prefix hp and annotation Hp [WrapperSimpleAppMain]
2023-05-15 15:35:59,898  INFO HpInitializer:51 - HP (FutureSmart 4+) device init... [WrapperSimpleAppMain]
2023-05-15 15:36:00,321  INFO HpPrintOnlyDeviceTypeRegistration:29 - Adding HP (FutureSmart 4+) Print Only device type [WrapperSimpleAppMain]
2023-05-15 15:36:00,322  INFO HpPrintOnlyDeviceTypeRegistration:40 - HP (FutureSmart 4+) Print Only device type supported. [WrapperSimpleAppMain]
2023-05-15 15:36:00,331  INFO SindohExtDeviceTypeInitializer:60 - Sindoh device types added [WrapperSimpleAppMain]
2023-05-15 15:36:00,461  INFO ModuleRegistry:47 - Registered module with URI prefix konica and annotation Konica [WrapperSimpleAppMain]
2023-05-15 15:36:00,468  INFO KonicaMinoltaExtDeviceTypeInitializer:66 - Konica Minolta (OpenAPI 3.1+) device type added [WrapperSimpleAppMain]
2023-05-15 15:36:00,469  INFO KonicaMinoltaExtDeviceTypeInitializer:94 - Konica Minolta (OpenAPI 4.0+) device type added [WrapperSimpleAppMain]
2023-05-15 15:36:00,511  INFO KonicaMinoltaLegacyExtDeviceTypeInitializer:58 - Konica Minolta (OpenAPI 2.3+) device type added [WrapperSimpleAppMain]
2023-05-15 15:36:05,902  INFO SystemStartup:38 - System started: SystemStarted{startTime=2023-05-15T15:36:05.775Z}, resolving all physical printer addresses... [spring-async-task-1]
2023-05-15 15:36:06,005  INFO PrinterNetworkAddressCache:69 - Loading address cache and resolving all physical printer addresses... [spring-async-task-1]
2023-05-15 15:36:06,342  INFO PrinterNetworkAddressCache:88 - Cached 0 printer addresses registered in 0 printers (0 unique) [spring-async-task-1]
2023-05-15 15:36:06,347  INFO SystemStartup:41 - Startup tasks completed. [spring-async-task-1]
2023-05-15 15:36:06,400  INFO PrinterStatsGenerator:45 - Calculating printer statistics... [fetch-support-info-startup]
2023-05-15 15:36:08,910  INFO WebPrintStatusChangeLogger:136 - Web print server 'MSWIN-ADFS' version '17.4.4.42563' has been initialised and started [fetch-support-info-startup]
2023-05-15 15:36:10,183  INFO WebPluginConfig:194 - Added security interceptor patterns for toshiba: authenticated pages: /toshiba/*/**, excluded: [/toshiba/*/login] [WrapperSimpleAppMain]
2023-05-15 15:36:10,184  INFO WebPluginConfig:198 - Setting cache-control to 'no-store' for toshiba: URI patterns: /toshiba/*/** [WrapperSimpleAppMain]
2023-05-15 15:36:10,184  INFO WebPluginConfig:194 - Added security interceptor patterns for xerox: authenticated pages: /xerox/*/**, excluded: [/xerox/*/logout-message, /xerox/*/home/description, /xerox/*/home/icon, /xerox/*/print-release/description, /xerox/*/print-release/icon, /xerox/*/account-select/description, /xerox/*/account-select/icon] [WrapperSimpleAppMain]
2023-05-15 15:36:10,185  INFO WebPluginConfig:198 - Setting cache-control to 'no-store' for xerox: URI patterns: /xerox/*/** [WrapperSimpleAppMain]
2023-05-15 15:36:10,185  INFO WebPluginConfig:194 - Added security interceptor patterns for hp: authenticated pages: /hp/*/**, excluded: [/hp/*/integration-in-progress, /hp/*/login] [WrapperSimpleAppMain]
2023-05-15 15:36:10,185  INFO WebPluginConfig:198 - Setting cache-control to 'no-store' for hp: URI patterns: /hp/*/** [WrapperSimpleAppMain]
2023-05-15 15:36:11,041  INFO AppServer:647 - Server started in 51 seconds. [WrapperSimpleAppMain]
2023-05-15 15:36:11,043  INFO AppServer:553 - Enabled plugins: [] [WrapperSimpleAppMain]
2023-05-15 15:36:17,389  INFO Home:1217 - Setup has not yet been completed for server type: MASTER [http-82]
2023-05-15 15:37:07,798  INFO SetupVerify:117 - Setup wizard complete, performing setup/configuration [http-86]
2023-05-15 15:37:09,034  INFO SynchronisationManagerImpl:276 - Synchronizing users and groups with the operating system. [RunTask-1684165028519-1 (Initial user import)]
2023-05-15 15:37:09,034  INFO SynchronisationManagerImpl:159 - Started syncing users and groups. Delete users: false, Update users: false [RunTask-1684165028519-1 (Initial user import)]
2023-05-15 15:37:45,650  INFO SynchronisationManagerImpl:228 - Completed syncing users and groups. Added 2501 new users. [RunTask-1684165028519-1 (Initial user import)]
2023-05-15 17:51:27,977 DEBUG SystemManagerImpl:802 - Debug mode is set to: true. Keep: 100MB of server logs [http-98]
2023-05-15 17:51:27,977 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=system.log.keep-mb) [http-98]
2023-05-15 17:51:27,977 DEBUG AuditableInterceptor:306 - Updating: ConfigProperty[id=0,propertyName=system.enable-debug,value=Y] [http-98]
2023-05-15 17:51:27,977 DEBUG SQL:111 - update tbl_config set property_value=?, created_date=?, created_by=?, modified_date=?, modified_by=?, modified_ticks=?, propagate=? where property_name=? [http-98]
2023-05-15 17:51:27,977 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,977 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=system.log.keep-mb,value=2048] [http-98]
2023-05-15 17:51:27,977 DEBUG SystemManagerImpl:735 - Setting up debug mode: true. Keep: 2048MB of server logs [http-98]
2023-05-15 17:51:27,977 DEBUG SystemManagerImpl:802 - Debug mode is set to: true. Keep: 2048MB of server logs [http-98]
2023-05-15 17:51:27,977 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=gcp.debug) [http-98]
2023-05-15 17:51:27,977 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,977 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=gcp.debug,value=N] [http-98]
2023-05-15 17:51:27,993 DEBUG BootConfig:130 - Config file not modified, no need to reload from: C:\Program Files\PaperCut NG\server [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=logging.audit-logging-enabled) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=logging.audit-logging-enabled,value=Y] [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=ext-device.integration-enabled) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=ext-device.integration-enabled,value=N] [http-98]
2023-05-15 17:51:27,993 DEBUG AnalyticsConfigurationServiceImpl:56 - Analytics isEnabled value has been changed from N to N. [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=analytics.enabled) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=analytics.enabled,value=N] [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=auth.admin.allowed-addresses) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=auth.admin.allowed-addresses,value=*] [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=auth.providers.allowed-addresses) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=auth.providers.allowed-addresses,value=*] [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=auth.devices.allowed-addresses) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=auth.devices.allowed-addresses,value=*] [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=auth.webservices.allowed-addresses) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=auth.webservices.allowed-addresses,value=127.0.0.1] [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=auth.trusted-proxy-addresses) [http-98]
2023-05-15 17:51:27,993 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=auth.trusted-proxy-addresses,value=] [http-98]
2023-05-15 17:51:27,993 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=client.config.use-ssl) [http-98]
2023-05-15 17:51:28,010 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:28,010 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=client.config.use-ssl,value=N] [http-98]
2023-05-15 17:51:28,010 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=auth.web-login.sso-enable) [http-98]
2023-05-15 17:51:28,010 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:28,010 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=auth.web-login.sso-enable,value=N] [http-98]
2023-05-15 17:51:28,010 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=secondary-user-name.enabled) [http-98]
2023-05-15 17:51:28,010 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:28,010 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=secondary-user-name.enabled,value=N] [http-98]
2023-05-15 17:51:28,010 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=system.network-address.user-facing) [http-98]
2023-05-15 17:51:28,010 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:28,010 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=system.network-address.user-facing,value=] [http-98]
2023-05-15 17:51:28,010 DEBUG ConnectionManager:464 - releasing JDBC connection [http-98]
2023-05-15 17:51:28,030 DEBUG ConnectionManager:444 - opening JDBC connection [http-98]
2023-05-15 17:51:28,030 DEBUG ExtDeviceManagerImpl:818 - Disable password caching: newConfigIds=[], user=system [http-98]
2023-05-15 17:51:28,030 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=password-caching.configs.enabled) [http-98]
2023-05-15 17:51:28,030 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? [http-98]
2023-05-15 17:51:28,046 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=password-caching.configs.enabled,value=] [http-98]
2023-05-15 17:51:28,046 DEBUG ConnectionManager:464 - releasing JDBC connection [http-98]
2023-05-15 17:51:28,046 DEBUG ConnectionManager:444 - opening JDBC connection [http-98]
2023-05-15 17:51:28,046 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) [http-98]
2023-05-15 17:51:28,046 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? [http-98]
2023-05-15 17:51:28,061 DEBUG ConnectionManager:464 - releasing JDBC connection [http-98]
2023-05-15 17:51:28,061 DEBUG BootConfig:130 - Config file not modified, no need to reload from: C:\Program Files\PaperCut NG\server [http-98]
2023-05-15 17:51:28,061 DEBUG BootConfig:130 - Config file not modified, no need to reload from: C:\Program Files\PaperCut NG\server [http-98]
2023-05-15 17:51:28,061 DEBUG ConnectionManager:444 - opening JDBC connection [http-98]
2023-05-15 17:51:28,061 DEBUG ConnectionManager:464 - releasing JDBC connection [http-98]
2023-05-15 17:51:28,061 DEBUG ConnectionManager:444 - opening JDBC connection [http-98]
2023-05-15 17:51:28,061 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) [http-98]
2023-05-15 17:51:28,061 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? [http-98]
2023-05-15 17:51:28,061 DEBUG ConnectionManager:464 - releasing JDBC connection [http-98]
2023-05-15 17:51:28,077 DEBUG WebEngine:91 - Finish render: OptionsAdvanced [http-98]
2023-05-15 17:51:28,312 DEBUG Jetty:924 - >>> 127.0.0.1 HTTP/1.1 GET /rpc/api/rest/internal/adminui/diagnostic-files-upload-status [http-84]
2023-05-15 17:51:28,317 DEBUG SecurityRequestFilter:106 - REST API called: GET /rpc/api/rest/internal/adminui/diagnostic-files-upload-status RemoteAddr: 127.0.0.1 (GET - /rpc/api/rest/internal/adminui/diagnostic-files-upload-status) [http-84]
2023-05-15 17:51:28,319 DEBUG Jetty:934 - <<< 127.0.0.1 HTTP/1.1 GET /rpc/api/rest/internal/adminui/diagnostic-files-upload-status => Status: 200, Content-Type: application/json, Took 7ms [http-84]
2023-05-15 17:51:28,393 DEBUG Jetty:924 - >>> 127.0.0.1 HTTP/1.1 GET /rpc/api/rest/internal/adminui/applicationlicense [http-98]
2023-05-15 17:51:28,393 DEBUG SecurityRequestFilter:106 - REST API called: GET /rpc/api/rest/internal/adminui/applicationlicense RemoteAddr: 127.0.0.1 (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,394 DEBUG AdminUIResource:121 - Get support/license info: prefetch=false (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,394 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,395 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,395 DEBUG LicenseUtils:207 - Using cached license user count: 2501 (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,396 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,396 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,397 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,397 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,397 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,398 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,398 DEBUG AdminUIResource:176 - No cached support info. (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,398 DEBUG ExternalUrlManagerImpl:138 - No license provided when generating URL, load now (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,398 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,399 DEBUG LicenseUtils:207 - Using cached license user count: 2501 (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,399 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,400 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,400 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,400 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,401 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,401 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,402 DEBUG AdminUIResource:137 - Support info URL: https://www.papercut.com/api/supportinformation/v1/?ver-major=17&ver-minor=4&ver-patch=4&ver-suffix=&ver-build=42563&install-date=2023-05-15&edition=ng&app-name=PaperCut%20NG%20&org=Trial%20License&org-type=&exp-date=2023-06-24&modules=print&server-uid=9d6fc83a-08d3-440c-8800-b7ce01e0fec3&licensed-users=-1&purchased-users=0&licensed-release-stations=-1&license-id=&support-exp-date=&support-current=N&central-reports-servers=0&db-type=Derby&db-version=Apache%20Derby%2010.13.1.1%20-%20%281765088%29&os=Windows%20Server%202016&os-version=10.0&os-arch=amd64&os-host=mswin-ADFS&runtime-version=1.8.0_131-b11&runtime-arch=amd64&sys-max-memory-mb=3600&sys-cpus=4&sys-printers=0&sys-unique-network-printers=0&sys-unique-local-printers=0&direct-printers=0&direct-virtual-printers=0&direct-print-queues=0&direct-virtual-print-queues=0&direct-max-print-queues=0&sys-devices=0&sys-virtual=0&syslocale=en_US&user-count=2501&print-logs=-1&print-logs-last-week=0&active-shared-accounts=0&gcp-printers=0&etp-printers=0&webprint-printers=0&watermarking-header=0&watermarking-footer=0&watermarking-fullpage=0&watermarking-custom=0&block-web-release-on-printer-error=false&block-release-on-error-devices=0&archiving-printers=0&script-printers=0&webcash-enabled=false&rel-stations=0&daily-reports=0&weekly-reports=0&fortnightly-reports=0&monthly-reports=0&quarterly-reports=0&yearly-reports=0&scan-actions=0&int-scan-devices=0&status=VALID&monitored-health-simple-minutes-ago=-1&monitored-health-stats-minutes-ago=-1&monitored-health-individual-printer-device-minutes-ago=-1&monitored-health-recent-jobs-minutes-ago=-1&monitored-health-advanced-minutes-ago=-1&webprint-sandbox-servers=0&server-uptime=136&print-release-from-devices-logs=0&print-release-from-external-logs=0&print-release-from-web-logs=0&print-release-from-mobile-logs=0&held-page-count=0&released-pages-count=0&secondary-servers=1&mobility-print-servers=0&CA-signed=false&pages-converted-duplex=0&pages-converted-grayscale=0 (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,402 DEBUG ConfigManagerImpl:829 - License date stamp: 1684108800000:743b6cebdbe7481920dedb0bb467df5b (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,403 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /rpc/api/rest/internal/adminui/applicationlicense) [http-98]
2023-05-15 17:51:28,404 DEBUG Jetty:934 - <<< 127.0.0.1 HTTP/1.1 GET /rpc/api/rest/internal/adminui/applicationlicense => Status: 200, Content-Type: application/json, Took 11ms [http-98]
2023-05-15 17:51:28,584 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 619/1,688/3,600, Metaspace: 154/168/Unlimited, Threads: 98, Process CPU: 0.0%, System CPU: 100.0%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 9s [spring-scheduled-task-2]
2023-05-15 17:51:29,240 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:51:29,256 DEBUG SystemStateSerializerImpl:86 - Saved system state in 16ms, job-authentication: 0ms, user-client-data: 0ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 16ms [system-state-save-thread]
2023-05-15 17:51:29,927 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:51:29,928 DEBUG LicenseUtils:207 - Using cached license user count: 2501 [TrialLicenseInspector]
2023-05-15 17:51:29,928 DEBUG ConnectionManager:444 - opening JDBC connection [TrialLicenseInspector]
2023-05-15 17:51:29,929 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) [TrialLicenseInspector]
2023-05-15 17:51:29,929 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? [TrialLicenseInspector]
2023-05-15 17:51:29,930 DEBUG ConnectionManager:464 - releasing JDBC connection [TrialLicenseInspector]
2023-05-15 17:51:29,930 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT [TrialLicenseInspector]
2023-05-15 17:51:29,930 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. [TrialLicenseInspector]
2023-05-15 17:51:29,930 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] [TrialLicenseInspector]
2023-05-15 17:51:29,930 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:51:33,606 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 619/1,688/3,600, Metaspace: 154/168/Unlimited, Threads: 98, Process CPU: 0.8%, System CPU: 57.5%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 14s [spring-scheduled-task-4]
2023-05-15 17:51:34,132 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:51:34,132 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:51:34,132 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:51:34,132 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:51:34,132 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:51:35,265 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:51:35,269 DEBUG SystemStateSerializerImpl:86 - Saved system state in 4ms, job-authentication: 0ms, user-client-data: 4ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 0ms [system-state-save-thread]
2023-05-15 17:51:38,066 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 GET /app [http-87]
2023-05-15 17:51:38,067 DEBUG WebEngine:70 - Start render: /app?service=page/SetupCompleted, IP: 18.246.57.67 (GET - /app) [http-87]
2023-05-15 17:51:38,095 DEBUG Visit:171 - Determine start page for login type: Admin. Default: Dashboard (GET - /app) [http-87]
2023-05-15 17:51:38,096 DEBUG Visit:227 - Completed login for: Visit[created=2023-05-15 17:51:38,userName=[setup wizard],loginType=Admin,startPage=Dashboard] (GET - /app) [http-87]
2023-05-15 17:51:38,098 DEBUG WebEngine:93 - Finish render: SetupCompleted (31 ms) (GET - /app) [http-87]
2023-05-15 17:51:38,098 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 GET /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 32ms [http-87]
2023-05-15 17:51:38,101 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-84]
2023-05-15 17:51:38,102 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node0ynzbk40ohqfdhhy4e138ua4i12, Visit[created=2023-05-15 17:51:38,userName=[setup wizard],loginType=Admin,startPage=Dashboard] (POST - /app) [http-84]
2023-05-15 17:51:38,103 DEBUG AnalyticsConfigurationServiceImpl:56 - Analytics isEnabled value has been changed from N to N. (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,104 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,105 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=analytics.enabled) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,105 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,106 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=analytics.enabled,value=N] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,107 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,108 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,108 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=analytics.admin-notified) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,108 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,109 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=analytics.admin-notified,value=Y] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,109 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,110 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,110 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,111 DEBUG HibernateDAOBase:377 - HQL: select count( u.id)  from User u  where u.deleted = 'N'  (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,111 DEBUG SQL:111 - select count(user0_.user_id) as col_0_0_ from tbl_user user0_ where user0_.deleted='N' (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,112 DEBUG HibernateDAOBase:392 - Count: 2501 (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,113 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,113 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,114 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,114 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,114 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,114 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,115 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,188 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,188 DEBUG BootConfig:130 - Config file not modified, no need to reload from: C:\Program Files\PaperCut NG\server (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,189 DEBUG HibernateDAOBase:377 - HQL: from User u where u.deleted = 'N' AND u.userName = :userName (Params: userName=admin) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,189 DEBUG SQL:111 - select user0_.user_id as user1_20_, user0_.user_name as user2_20_, user0_.external_user_name as external3_20_, user0_.full_name as full4_20_, user0_.email as email20_, user0_.notes as notes20_, user0_.total_jobs as total7_20_, user0_.total_pages as total8_20_, user0_.total_sheets as total9_20_, user0_.reset_by as reset10_20_, user0_.reset_date as reset11_20_, user0_.deleted as deleted20_, user0_.deleted_date as deleted13_20_, user0_.created_date as created14_20_, user0_.created_by as created15_20_, user0_.modified_date as modified16_20_, user0_.modified_by as modified17_20_, user0_.department as department20_, user0_.office as office20_, user0_.card_number as card20_20_, user0_.disabled_printing as disabled21_20_, user0_.disabled_printing_until as disabled22_20_, user0_.net_reset_by as net23_20_, user0_.net_reset_date as net24_20_, user0_.net_total_megabytes as net25_20_, user0_.net_total_time_hours as net26_20_, user0_.disabled_net as disabled27_20_, user0_.disabled_net_until as disabled28_20_, user0_.internal as internal20_, user0_.last_user_activity as last30_20_, user0_.card_number2 as card31_20_, user0_.secondary_user_name as secondary32_20_, user0_.modified_ticks as modified33_20_, user0_.home_directory as home34_20_ from tbl_user user0_ where user0_.deleted='N' and user0_.user_name=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,190 DEBUG AuthenticationManagerImpl:407 - User: admin has rights: [Administrator, ReleaseStationManager, ReleaseStationCloseFullScreen, CanAccessDashboardSection, CanAccessUsersSection, CanAdjustUserBalance, CanChangeUserPassword, CanCreateInternalUsers, CanEditUsers, CanAccessBulkUserActions, CanAccessGroupsSection, CanAccessSharedAccountSection, CanEditSharedAccounts, CanAccessBulkAccountActions, CanAccessPrintersSection, CanAccessGlobalJobLogs, CanEditPrinters, CanAccessDevicesSection, CanEditDevices, CanEditPrintLogs, CanAccessArchivedJobs, CanRemoveArchivedJobs, CanRefundPrintJobs, WebCashierManager, CanAccessWebCashierDepositSection, CanAccessWebCashierPurchaseSection, CanAccessReportsSection, CanAccessCentralReports, CanAccessCardsSection, CanManageCards, CanAccessOptionsSection, CanAccessAdminRightsSection, CanAccessApplicationLogSection, CanAccessAuditLogSection] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,191 DEBUG BootConfig:130 - Config file not modified, no need to reload from: C:\Program Files\PaperCut NG\server (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,191 DEBUG HibernateDAOBase:377 - HQL: from User u where u.deleted = 'N' AND u.userName = :userName (Params: userName=admin) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,191 DEBUG SQL:111 - select user0_.user_id as user1_20_, user0_.user_name as user2_20_, user0_.external_user_name as external3_20_, user0_.full_name as full4_20_, user0_.email as email20_, user0_.notes as notes20_, user0_.total_jobs as total7_20_, user0_.total_pages as total8_20_, user0_.total_sheets as total9_20_, user0_.reset_by as reset10_20_, user0_.reset_date as reset11_20_, user0_.deleted as deleted20_, user0_.deleted_date as deleted13_20_, user0_.created_date as created14_20_, user0_.created_by as created15_20_, user0_.modified_date as modified16_20_, user0_.modified_by as modified17_20_, user0_.department as department20_, user0_.office as office20_, user0_.card_number as card20_20_, user0_.disabled_printing as disabled21_20_, user0_.disabled_printing_until as disabled22_20_, user0_.net_reset_by as net23_20_, user0_.net_reset_date as net24_20_, user0_.net_total_megabytes as net25_20_, user0_.net_total_time_hours as net26_20_, user0_.disabled_net as disabled27_20_, user0_.disabled_net_until as disabled28_20_, user0_.internal as internal20_, user0_.last_user_activity as last30_20_, user0_.card_number2 as card31_20_, user0_.secondary_user_name as secondary32_20_, user0_.modified_ticks as modified33_20_, user0_.home_directory as home34_20_ from tbl_user user0_ where user0_.deleted='N' and user0_.user_name=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,192 DEBUG AuthenticationManagerImpl:407 - User: admin has rights: [Administrator, ReleaseStationManager, ReleaseStationCloseFullScreen, CanAccessDashboardSection, CanAccessUsersSection, CanAdjustUserBalance, CanChangeUserPassword, CanCreateInternalUsers, CanEditUsers, CanAccessBulkUserActions, CanAccessGroupsSection, CanAccessSharedAccountSection, CanEditSharedAccounts, CanAccessBulkAccountActions, CanAccessPrintersSection, CanAccessGlobalJobLogs, CanEditPrinters, CanAccessDevicesSection, CanEditDevices, CanEditPrintLogs, CanAccessArchivedJobs, CanRemoveArchivedJobs, CanRefundPrintJobs, WebCashierManager, CanAccessWebCashierDepositSection, CanAccessWebCashierPurchaseSection, CanAccessReportsSection, CanAccessCentralReports, CanAccessCardsSection, CanManageCards, CanAccessOptionsSection, CanAccessAdminRightsSection, CanAccessApplicationLogSection, CanAccessAuditLogSection] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,192 DEBUG Home:708 - Performing login for user: admin, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, loginType=Admin (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,193 DEBUG HibernateDAOBase:377 - HQL: from User u where u.deleted = 'N' AND u.userName = :userName (Params: userName=admin) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,194 DEBUG SQL:111 - select user0_.user_id as user1_20_, user0_.user_name as user2_20_, user0_.external_user_name as external3_20_, user0_.full_name as full4_20_, user0_.email as email20_, user0_.notes as notes20_, user0_.total_jobs as total7_20_, user0_.total_pages as total8_20_, user0_.total_sheets as total9_20_, user0_.reset_by as reset10_20_, user0_.reset_date as reset11_20_, user0_.deleted as deleted20_, user0_.deleted_date as deleted13_20_, user0_.created_date as created14_20_, user0_.created_by as created15_20_, user0_.modified_date as modified16_20_, user0_.modified_by as modified17_20_, user0_.department as department20_, user0_.office as office20_, user0_.card_number as card20_20_, user0_.disabled_printing as disabled21_20_, user0_.disabled_printing_until as disabled22_20_, user0_.net_reset_by as net23_20_, user0_.net_reset_date as net24_20_, user0_.net_total_megabytes as net25_20_, user0_.net_total_time_hours as net26_20_, user0_.disabled_net as disabled27_20_, user0_.disabled_net_until as disabled28_20_, user0_.internal as internal20_, user0_.last_user_activity as last30_20_, user0_.card_number2 as card31_20_, user0_.secondary_user_name as secondary32_20_, user0_.modified_ticks as modified33_20_, user0_.home_directory as home34_20_ from tbl_user user0_ where user0_.deleted='N' and user0_.user_name=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,194 DEBUG Visit:171 - Determine start page for login type: Admin. Default: Dashboard (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,194 DEBUG Visit:227 - Completed login for: Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,195 DEBUG Home:783 - login admin: license check login. startPage=Dashboard, loginType=Admin (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,195 DEBUG ApplicationLogManagerImpl:181 - App log: User "admin" logged into the administration interface. (IP: 18.246.57.67) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,196 DEBUG ApplicationLogManagerImpl:74 - Submitted app log entry. Pending logs: 1 (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,196 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,196 DEBUG LicenseUtils:207 - Using cached license user count: 2501 (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,197 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,197 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,198 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,198 DEBUG ApplicationLogManagerImpl:122 - 1 app logs to save [app-log-persist]
2023-05-15 17:51:38,198 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,198 DEBUG ConnectionManager:444 - opening JDBC connection [app-log-persist]
2023-05-15 17:51:38,199 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,199 DEBUG HibernateDAOBase:141 - Saving: PersistedApplicationLogEntry[id=0,entryTime=2023-05-15T17:51:38,entryLevel=INFO,message=User "admin" logged into the administration interface. (IP: 18.246.57.67)] [app-log-persist]
2023-05-15 17:51:38,199 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,199 DEBUG SQL:111 - insert into tbl_application_log (log_date, server_name, log_level, message, application_log_id) values (?, ?, ?, ?, ?) [app-log-persist]
2023-05-15 17:51:38,199 DEBUG HibernateDAOBase:377 - HQL: from ConfigProperty p where p.propertyName = :propertyName (Params: propertyName=stats.user-count) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,201 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name=? (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,201 DEBUG HibernateDAOBase:141 - Saving: ConfigProperty[id=0,propertyName=stats.user-count,value=2501] (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,202 DEBUG Home:1030 - Update check days: 90 (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,202 DEBUG ConnectionManager:464 - releasing JDBC connection [app-log-persist]
2023-05-15 17:51:38,203 DEBUG LoginRedirectCookieHelper:119 - no redirect cookie found, activating startPage=Dashboard (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,218 DEBUG ApplicationLogManagerImpl:103 - Wait for app logs [app-log-persist]
2023-05-15 17:51:38,311 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,313 DEBUG WebEngine:93 - Finish render: SetupCompleted (211 ms) (POST - /app, user: '[setup wizard]', loginType: Admin) [http-84]
2023-05-15 17:51:38,313 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 302, Content-Type: N/A, Took 212ms [http-84]
2023-05-15 17:51:38,318 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 GET /app [http-98]
2023-05-15 17:51:38,319 DEBUG WebEngine:70 - Start render: /app?service=page/Dashboard, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (GET - /app) [http-98]
2023-05-15 17:51:38,320 DEBUG Dashboard:73 - pageBeginRender: Dashboard (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,320 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,320 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,321 DEBUG LicenseUtils:207 - Using cached license user count: 2501 (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,321 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,321 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,322 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,322 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,322 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,324 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,330 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,334 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,334 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,335 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,336 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,338 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,339 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,339 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,340 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,341 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,341 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,341 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,341 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,342 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,343 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,343 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,344 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,344 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,345 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,345 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,346 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,346 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,346 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,347 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,347 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,348 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,348 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,349 DEBUG Dashboard:257 - Using a print status refresh interval of 20 seconds (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,350 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,350 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,351 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,351 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,351 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,352 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,352 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,352 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,353 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,355 DEBUG WebEngine:93 - Finish render: Dashboard (37 ms) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,356 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 GET /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 38ms [http-98]
2023-05-15 17:51:38,360 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-87]
2023-05-15 17:51:38,361 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-87]
2023-05-15 17:51:38,366 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,366 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,367 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,368 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,369 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,370 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,370 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,372 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,372 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,374 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,374 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,375 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,380 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,388 DEBUG WebEngine:93 - Finish render: ConfigEditor (27 ms) (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,388 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 28ms [http-87]
2023-05-15 17:51:38,391 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-94]
2023-05-15 17:51:38,392 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-94]
2023-05-15 17:51:38,422 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,423 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,423 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,424 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,425 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,426 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,426 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,426 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,431 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,436 DEBUG WebEngine:93 - Finish render: StaleLink (43 ms) (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,436 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 45ms [http-94]
2023-05-15 17:51:38,438 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-98]
2023-05-15 17:51:38,443 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-98]
2023-05-15 17:51:38,448 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,450 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,454 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,455 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,502 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print.script.sandboxed%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,503 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,503 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,505 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,505 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,507 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print.script.sandboxed%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,508 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,508 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,513 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,516 DEBUG WebEngine:93 - Finish render: ConfigEditor (73 ms) (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:38,516 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 78ms [http-98]
2023-05-15 17:51:38,522 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-87]
2023-05-15 17:51:38,531 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-87]
2023-05-15 17:51:38,532 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print.script.sandboxed%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,533 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,533 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,539 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,540 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,541 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print.script.sandboxed%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,542 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,542 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,547 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,550 DEBUG WebEngine:93 - Finish render: StaleLink (19 ms) (POST - /app, user: 'admin', loginType: Admin) [http-87]
2023-05-15 17:51:38,551 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 29ms [http-87]
2023-05-15 17:51:38,569 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 GET /app [http-94]
2023-05-15 17:51:38,570 DEBUG WebEngine:70 - Start render: /app?service=page/PrinterList, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (GET - /app) [http-94]
2023-05-15 17:51:38,571 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,571 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,625 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 642/1,688/3,600, Metaspace: 154/168/Unlimited, Threads: 98, Process CPU: 5.7%, System CPU: 69.3%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 19s [spring-scheduled-task-4]
2023-05-15 17:51:38,777 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,777 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,778 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:38,779 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,326 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,326 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.Printer p  WHERE p.deleted = 'N'  AND (p.deviceType IN (:deviceTypes))  AND p.parentPrinter is null  (Params: deviceTypes=[PRINTER, PRINTER_WITH_QUEUES, VIRTUAL_QUEUE, VIRTUAL_PRINTER_WITH_QUEUES], Limit: 1) (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,327 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_printer printer0_ where printer0_.deleted='N' and (printer0_.device_type in (? , ? , ? , ?)) and (printer0_.parent_id is null) fetch first 1 rows only (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,327 DEBUG HibernateDAOBase:392 - Count: 1 (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,328 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,330 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,330 DEBUG HibernateDAOBase:377 - HQL: select p FROM biz.papercut.pcng.domain.Printer p  WHERE p.deleted = 'N'  AND (p.deviceType IN (:deviceTypes))  AND p.parentPrinter is null  ORDER BY coalesce(p.serverName, '!') asc, p.printerName asc (Params: deviceTypes=[PRINTER, PRINTER_WITH_QUEUES, VIRTUAL_QUEUE, VIRTUAL_PRINTER_WITH_QUEUES], Limit: 25) (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,331 DEBUG SQL:111 - select printer0_.printer_id as printer1_10_, printer0_.server_name as server2_10_, printer0_.printer_name as printer3_10_, printer0_.display_name as display4_10_, printer0_.location as location10_, printer0_.notes as notes10_, printer0_.charge_type as charge7_10_, printer0_.default_cost as default8_10_, printer0_.deleted as deleted10_, printer0_.deleted_date as deleted10_10_, printer0_.disabled as disabled10_, printer0_.disabled_until as disabled12_10_, printer0_.total_jobs as total13_10_, printer0_.total_pages as total14_10_, printer0_.total_sheets as total15_10_, printer0_.reset_by as reset16_10_, printer0_.reset_date as reset17_10_, printer0_.created_date as created18_10_, printer0_.created_by as created19_10_, printer0_.modified_date as modified20_10_, printer0_.modified_by as modified21_10_, printer0_.color_detection_mode as color22_10_, printer0_.device_type as device23_10_, printer0_.ext_device_function as ext24_10_, printer0_.physical_printer_id as physical25_10_, printer0_.printer_type as printer26_10_, printer0_.serial_number as serial27_10_, printer0_.web_print_enabled as web28_10_, printer0_.custom1 as custom29_10_, printer0_.custom2 as custom30_10_, printer0_.custom3 as custom31_10_, printer0_.custom4 as custom32_10_, printer0_.custom5 as custom33_10_, printer0_.custom6 as custom34_10_, printer0_.last_usage_date as last35_10_, printer0_.gcp_printer_id as gcp36_10_, printer0_.gcp_enabled as gcp37_10_, printer0_.modified_ticks as modified38_10_, printer0_.server_uuid as server39_10_, printer0_.parent_id as parent40_10_ from tbl_printer printer0_ where printer0_.deleted='N' and (printer0_.device_type in (? , ? , ? , ?)) and (printer0_.parent_id is null) order by coalesce(printer0_.server_name, '!') asc, printer0_.printer_name asc fetch first 25 rows only (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,332 DEBUG SQL:111 - select printeratt0_.printer_id as printer1_10_0_, printeratt0_.attrib_value as attrib2_0_, printeratt0_.modified_ticks as modified3_0_, printeratt0_.propagate as propagate0_, printeratt0_.attrib_name as attrib5_0_ from tbl_printer_attribute printeratt0_ where printeratt0_.printer_id=? (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,333 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,334 DEBUG PaperSizeTablePrintCostModel:70 - Enabling region-specific common page sizes with default costs for first time use: [LETTER, LEGAL, 11X17] (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,349 DEBUG WebEngine:93 - Finish render: PrinterList (779 ms) (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:39,349 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 GET /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 780ms [http-94]
2023-05-15 17:51:39,352 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 GET /app [http-98]
2023-05-15 17:51:39,353 DEBUG WebEngine:70 - Start render: /app?service=direct/1/PrinterList/selectPrinter&sp=l1001, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (GET - /app) [http-98]
2023-05-15 17:51:39,354 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:39,354 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:39,563 DEBUG DeviceServerDialog:61 - finishLoad (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:39,800 DEBUG PrintProviderPushEventsManagerImpl:311 - Drained 0 events to server: mswin-adfs|127.0.0.1. Remaining: 0, Waited: 90003 ms [http-82]
2023-05-15 17:51:39,802 DEBUG ProviderRPCHandler:1582 - Returning events:  [http-82]
2023-05-15 17:51:39,803 DEBUG BaseXMLRPCServlet:146 - XMLRPC(providers-xmlrpc) - end - Took: 1684173099803 ms [http-82]
2023-05-15 17:51:39,837 DEBUG Jetty:924 - >>> 127.0.0.1 HTTP/1.0 POST /rpc/providers/xmlrpc [http-87]
2023-05-15 17:51:39,838 DEBUG BaseXMLRPCServlet:132 - XMLRPC(providers-xmlrpc) - start - IP: 127.0.0.1, ST: 1, TT: 1, UA: PC-Print-Provider full-ver: 17.4.4.42563 env-ver: 13 (POST - /rpc/providers/xmlrpc) [http-87]
2023-05-15 17:51:39,840 DEBUG ProviderRPCHandler:1556 - Requesting events on server: mswin-adfs with timeout: 90000ms. IP: 127.0.0.1 (POST - /rpc/providers/xmlrpc, invoke 'drainEvents') [http-87]
2023-05-15 17:51:40,430 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,430 DEBUG SQL:111 - select printer0_.printer_id as printer1_10_0_, printer0_.server_name as server2_10_0_, printer0_.printer_name as printer3_10_0_, printer0_.display_name as display4_10_0_, printer0_.location as location10_0_, printer0_.notes as notes10_0_, printer0_.charge_type as charge7_10_0_, printer0_.default_cost as default8_10_0_, printer0_.deleted as deleted10_0_, printer0_.deleted_date as deleted10_10_0_, printer0_.disabled as disabled10_0_, printer0_.disabled_until as disabled12_10_0_, printer0_.total_jobs as total13_10_0_, printer0_.total_pages as total14_10_0_, printer0_.total_sheets as total15_10_0_, printer0_.reset_by as reset16_10_0_, printer0_.reset_date as reset17_10_0_, printer0_.created_date as created18_10_0_, printer0_.created_by as created19_10_0_, printer0_.modified_date as modified20_10_0_, printer0_.modified_by as modified21_10_0_, printer0_.color_detection_mode as color22_10_0_, printer0_.device_type as device23_10_0_, printer0_.ext_device_function as ext24_10_0_, printer0_.physical_printer_id as physical25_10_0_, printer0_.printer_type as printer26_10_0_, printer0_.serial_number as serial27_10_0_, printer0_.web_print_enabled as web28_10_0_, printer0_.custom1 as custom29_10_0_, printer0_.custom2 as custom30_10_0_, printer0_.custom3 as custom31_10_0_, printer0_.custom4 as custom32_10_0_, printer0_.custom5 as custom33_10_0_, printer0_.custom6 as custom34_10_0_, printer0_.last_usage_date as last35_10_0_, printer0_.gcp_printer_id as gcp36_10_0_, printer0_.gcp_enabled as gcp37_10_0_, printer0_.modified_ticks as modified38_10_0_, printer0_.server_uuid as server39_10_0_, printer0_.parent_id as parent40_10_0_ from tbl_printer printer0_ where printer0_.printer_id=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,431 DEBUG SQL:111 - select printeratt0_.printer_id as printer1_10_0_, printeratt0_.attrib_value as attrib2_0_, printeratt0_.modified_ticks as modified3_0_, printeratt0_.propagate as propagate0_, printeratt0_.attrib_name as attrib5_0_ from tbl_printer_attribute printeratt0_ where printeratt0_.printer_id=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,432 DEBUG HibernateDAOBase:125 - Fetched: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,433 DEBUG BasePrintCostModelComponent:60 - loading cost model (SimplePrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,433 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperSizeTablePrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,433 DEBUG PaperSizeTablePrintCostModel:70 - Enabling region-specific common page sizes with default costs for first time use: [LETTER, LEGAL, 11X17] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,434 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperSizeCategoryPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,434 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperSizeIndividualPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,434 DEBUG BasePrintCostModelComponent:60 - loading cost model (LinearPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,434 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperAreaPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,434 DEBUG DeviceDetailsFilters:83 - creating filters (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,435 DEBUG HibernateDAOBase:377 - HQL: from Group g (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,435 DEBUG SQL:111 - select group0_.group_id as group1_6_, group0_.group_name as group2_6_, group0_.initial_credit as initial3_6_, group0_.initially_restricted as initially4_6_, group0_.schedule_period as schedule5_6_, group0_.schedule_amount as schedule6_6_, group0_.allow_accum as allow7_6_, group0_.max_accum_balance as max8_6_, group0_.reset_statistics as reset9_6_, group0_.created_date as created10_6_, group0_.created_by as created11_6_, group0_.modified_date as modified12_6_, group0_.modified_by as modified13_6_, group0_.initial_settings_enabled as initial14_6_, group0_.modified_ticks as modified15_6_ from tbl_group group0_ (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,436 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,437 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,437 DEBUG PrinterDetails:784 - pageBeginRender: PrinterDetails (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,437 DEBUG HibernateDAOBase:377 - HQL:  from biz.papercut.pcng.domain.PrinterGroup order by groupName  (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,438 DEBUG SQL:111 - select printergro0_.printer_group_id as printer1_13_, printergro0_.group_name as group2_13_, printergro0_.display_name as display3_13_, printergro0_.created_date as created4_13_, printergro0_.created_by as created5_13_, printergro0_.modified_date as modified6_13_, printergro0_.modified_by as modified7_13_, printergro0_.modified_ticks as modified8_13_ from tbl_printer_group printergro0_ order by printergro0_.group_name (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,438 DEBUG SQL:111 - select printergro0_.printer_id as printer1_10_0_, printergro0_.printer_group_id as printer2_0_ from tbl_printer_printer_group printergro0_ where printergro0_.printer_id=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,439 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,442 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,443 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,443 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,445 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,448 DEBUG PaperSizeTablePrintCostModel:70 - Enabling region-specific common page sizes with default costs for first time use: [LETTER, LEGAL, 11X17] (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,451 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,451 DEBUG HibernateDAOBase:377 - HQL: select p.id, p.serverName, p.printerName, p.displayName, p.deviceType, p.extDeviceFunction, p.location, p.lastUsageDate, p.slaveServerUuid, p.physicalPrinterId, p.printerType FROM biz.papercut.pcng.domain.Printer p  WHERE p.deleted = 'N'  AND (p.deviceType IN (:deviceTypes))  AND p.printerName != :templatePrinter  AND p.parentPrinter is null  ORDER BY coalesce(p.serverName, '!'), p.printerName (Params: deviceTypes=[PRINTER, PRINTER_WITH_QUEUES, VIRTUAL_QUEUE, VIRTUAL_PRINTER_WITH_QUEUES], templatePrinter=!!template printer!!) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,451 DEBUG SQL:111 - select printer0_.printer_id as col_0_0_, printer0_.server_name as col_1_0_, printer0_.printer_name as col_2_0_, printer0_.display_name as col_3_0_, printer0_.device_type as col_4_0_, printer0_.ext_device_function as col_5_0_, printer0_.location as col_6_0_, printer0_.last_usage_date as col_7_0_, printer0_.server_uuid as col_8_0_, printer0_.physical_printer_id as col_9_0_, printer0_.printer_type as col_10_0_ from tbl_printer printer0_ where printer0_.deleted='N' and (printer0_.device_type in (? , ? , ? , ?)) and printer0_.printer_name<>? and (printer0_.parent_id is null) order by coalesce(printer0_.server_name, '!'), printer0_.printer_name (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,452 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,453 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,453 DEBUG HibernateDAOBase:377 - HQL: select p.id, p.serverName, p.printerName, p.displayName, p.deviceType, p.extDeviceFunction, p.location, p.lastUsageDate, p.slaveServerUuid, p.physicalPrinterId, p.printerType FROM biz.papercut.pcng.domain.Printer p  WHERE p.deleted = 'N'  AND (p.deviceType NOT IN (:deviceTypes))  AND p.printerName != :templatePrinter  AND p.parentPrinter is null  ORDER BY coalesce(p.serverName, '!'), p.printerName (Params: deviceTypes=[PRINTER, PRINTER_WITH_QUEUES, VIRTUAL_QUEUE, VIRTUAL_PRINTER_WITH_QUEUES], templatePrinter=!!template printer!!) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,454 DEBUG SQL:111 - select printer0_.printer_id as col_0_0_, printer0_.server_name as col_1_0_, printer0_.printer_name as col_2_0_, printer0_.display_name as col_3_0_, printer0_.device_type as col_4_0_, printer0_.ext_device_function as col_5_0_, printer0_.location as col_6_0_, printer0_.last_usage_date as col_7_0_, printer0_.server_uuid as col_8_0_, printer0_.physical_printer_id as col_9_0_, printer0_.printer_type as col_10_0_ from tbl_printer printer0_ where printer0_.deleted='N' and (printer0_.device_type not in  (? , ? , ? , ?)) and printer0_.printer_name<>? and (printer0_.parent_id is null) order by coalesce(printer0_.server_name, '!'), printer0_.printer_name (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,455 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,470 DEBUG WebEngine:93 - Finish render: PrinterDetails (1117 ms) (GET - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,471 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 GET /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 1119ms [http-98]
2023-05-15 17:51:40,474 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 GET /app [http-94]
2023-05-15 17:51:40,477 DEBUG WebEngine:70 - Start render: /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (GET - /app) [http-94]
2023-05-15 17:51:40,477 DEBUG ConnectionManager:444 - opening JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,478 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,478 DEBUG LicenseUtils:207 - Using cached license user count: 2501 (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,478 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,478 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,479 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,479 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,479 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,480 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,480 DEBUG ConnectionManager:464 - releasing JDBC connection (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,494 DEBUG WebEngine:93 - Finish render: Home (17 ms) (GET - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,494 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 GET /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 21ms [http-94]
2023-05-15 17:51:40,497 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-84]
2023-05-15 17:51:40,499 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-84]
2023-05-15 17:51:40,500 DEBUG BasePrintCostModelComponent:60 - loading cost model (SimplePrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,502 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperSizeTablePrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,502 DEBUG PaperSizeTablePrintCostModel:70 - Enabling region-specific common page sizes with default costs for first time use: [LETTER, LEGAL, 11X17] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,502 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperSizeCategoryPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,502 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperSizeIndividualPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,503 DEBUG BasePrintCostModelComponent:60 - loading cost model (LinearPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,503 DEBUG BasePrintCostModelComponent:60 - loading cost model (PaperAreaPrintCostModel) from printer: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,503 DEBUG DeviceDetailsFilters:83 - creating filters (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,503 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,504 DEBUG PrinterDetails:784 - pageBeginRender: PrinterDetails (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,504 DEBUG HibernateDAOBase:377 - HQL:  from biz.papercut.pcng.domain.PrinterGroup order by groupName  (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,504 DEBUG SQL:111 - select printergro0_.printer_group_id as printer1_13_, printergro0_.group_name as group2_13_, printergro0_.display_name as display3_13_, printergro0_.created_date as created4_13_, printergro0_.created_by as created5_13_, printergro0_.modified_date as modified6_13_, printergro0_.modified_by as modified7_13_, printergro0_.modified_ticks as modified8_13_ from tbl_printer_group printergro0_ order by printergro0_.group_name (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,505 DEBUG SQL:111 - select printer0_.printer_id as printer1_10_0_, printer0_.server_name as server2_10_0_, printer0_.printer_name as printer3_10_0_, printer0_.display_name as display4_10_0_, printer0_.location as location10_0_, printer0_.notes as notes10_0_, printer0_.charge_type as charge7_10_0_, printer0_.default_cost as default8_10_0_, printer0_.deleted as deleted10_0_, printer0_.deleted_date as deleted10_10_0_, printer0_.disabled as disabled10_0_, printer0_.disabled_until as disabled12_10_0_, printer0_.total_jobs as total13_10_0_, printer0_.total_pages as total14_10_0_, printer0_.total_sheets as total15_10_0_, printer0_.reset_by as reset16_10_0_, printer0_.reset_date as reset17_10_0_, printer0_.created_date as created18_10_0_, printer0_.created_by as created19_10_0_, printer0_.modified_date as modified20_10_0_, printer0_.modified_by as modified21_10_0_, printer0_.color_detection_mode as color22_10_0_, printer0_.device_type as device23_10_0_, printer0_.ext_device_function as ext24_10_0_, printer0_.physical_printer_id as physical25_10_0_, printer0_.printer_type as printer26_10_0_, printer0_.serial_number as serial27_10_0_, printer0_.web_print_enabled as web28_10_0_, printer0_.custom1 as custom29_10_0_, printer0_.custom2 as custom30_10_0_, printer0_.custom3 as custom31_10_0_, printer0_.custom4 as custom32_10_0_, printer0_.custom5 as custom33_10_0_, printer0_.custom6 as custom34_10_0_, printer0_.last_usage_date as last35_10_0_, printer0_.gcp_printer_id as gcp36_10_0_, printer0_.gcp_enabled as gcp37_10_0_, printer0_.modified_ticks as modified38_10_0_, printer0_.server_uuid as server39_10_0_, printer0_.parent_id as parent40_10_0_ from tbl_printer printer0_ where printer0_.printer_id=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,506 DEBUG SQL:111 - select printeratt0_.printer_id as printer1_10_0_, printeratt0_.attrib_value as attrib2_0_, printeratt0_.modified_ticks as modified3_0_, printeratt0_.propagate as propagate0_, printeratt0_.attrib_name as attrib5_0_ from tbl_printer_attribute printeratt0_ where printeratt0_.printer_id=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,507 DEBUG HibernateDAOBase:125 - Fetched: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,507 DEBUG SQL:111 - select printergro0_.printer_id as printer1_10_0_, printergro0_.printer_group_id as printer2_0_ from tbl_printer_printer_group printergro0_ where printergro0_.printer_id=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,508 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,535 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,535 DEBUG ApplicationLogManagerImpl:181 - App log: Admin user "admin" modified the print script on printer "[Template printer]" (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,536 DEBUG ApplicationLogManagerImpl:74 - Submitted app log entry. Pending logs: 1 (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,536 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,537 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,537 DEBUG HibernateDAOBase:141 - Saving: Printer[id=1001,name=!!template printer!!,deviceType=DeviceType{type=PRINTER},physicalId=,disabled=N,created=2023-05-15T15:37:08] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,538 DEBUG SQL:111 - select printer0_.printer_id as printer1_10_1_, printer0_.server_name as server2_10_1_, printer0_.printer_name as printer3_10_1_, printer0_.display_name as display4_10_1_, printer0_.location as location10_1_, printer0_.notes as notes10_1_, printer0_.charge_type as charge7_10_1_, printer0_.default_cost as default8_10_1_, printer0_.deleted as deleted10_1_, printer0_.deleted_date as deleted10_10_1_, printer0_.disabled as disabled10_1_, printer0_.disabled_until as disabled12_10_1_, printer0_.total_jobs as total13_10_1_, printer0_.total_pages as total14_10_1_, printer0_.total_sheets as total15_10_1_, printer0_.reset_by as reset16_10_1_, printer0_.reset_date as reset17_10_1_, printer0_.created_date as created18_10_1_, printer0_.created_by as created19_10_1_, printer0_.modified_date as modified20_10_1_, printer0_.modified_by as modified21_10_1_, printer0_.color_detection_mode as color22_10_1_, printer0_.device_type as device23_10_1_, printer0_.ext_device_function as ext24_10_1_, printer0_.physical_printer_id as physical25_10_1_, printer0_.printer_type as printer26_10_1_, printer0_.serial_number as serial27_10_1_, printer0_.web_print_enabled as web28_10_1_, printer0_.custom1 as custom29_10_1_, printer0_.custom2 as custom30_10_1_, printer0_.custom3 as custom31_10_1_, printer0_.custom4 as custom32_10_1_, printer0_.custom5 as custom33_10_1_, printer0_.custom6 as custom34_10_1_, printer0_.last_usage_date as last35_10_1_, printer0_.gcp_printer_id as gcp36_10_1_, printer0_.gcp_enabled as gcp37_10_1_, printer0_.modified_ticks as modified38_10_1_, printer0_.server_uuid as server39_10_1_, printer0_.parent_id as parent40_10_1_, printeratt1_.printer_id as printer1_10_3_, printeratt1_.attrib_value as attrib2_3_, printeratt1_.modified_ticks as modified3_3_, printeratt1_.propagate as propagate3_, printeratt1_.attrib_name as attrib5_3_, printer2_.printer_id as printer1_10_0_, printer2_.server_name as server2_10_0_, printer2_.printer_name as printer3_10_0_, printer2_.display_name as display4_10_0_, printer2_.location as location10_0_, printer2_.notes as notes10_0_, printer2_.charge_type as charge7_10_0_, printer2_.default_cost as default8_10_0_, printer2_.deleted as deleted10_0_, printer2_.deleted_date as deleted10_10_0_, printer2_.disabled as disabled10_0_, printer2_.disabled_until as disabled12_10_0_, printer2_.total_jobs as total13_10_0_, printer2_.total_pages as total14_10_0_, printer2_.total_sheets as total15_10_0_, printer2_.reset_by as reset16_10_0_, printer2_.reset_date as reset17_10_0_, printer2_.created_date as created18_10_0_, printer2_.created_by as created19_10_0_, printer2_.modified_date as modified20_10_0_, printer2_.modified_by as modified21_10_0_, printer2_.color_detection_mode as color22_10_0_, printer2_.device_type as device23_10_0_, printer2_.ext_device_function as ext24_10_0_, printer2_.physical_printer_id as physical25_10_0_, printer2_.printer_type as printer26_10_0_, printer2_.serial_number as serial27_10_0_, printer2_.web_print_enabled as web28_10_0_, printer2_.custom1 as custom29_10_0_, printer2_.custom2 as custom30_10_0_, printer2_.custom3 as custom31_10_0_, printer2_.custom4 as custom32_10_0_, printer2_.custom5 as custom33_10_0_, printer2_.custom6 as custom34_10_0_, printer2_.last_usage_date as last35_10_0_, printer2_.gcp_printer_id as gcp36_10_0_, printer2_.gcp_enabled as gcp37_10_0_, printer2_.modified_ticks as modified38_10_0_, printer2_.server_uuid as server39_10_0_, printer2_.parent_id as parent40_10_0_ from tbl_printer printer0_ left outer join tbl_printer_attribute printeratt1_ on printer0_.printer_id=printeratt1_.printer_id left outer join tbl_printer printer2_ on printer0_.parent_id=printer2_.printer_id where printer0_.printer_id=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,537 DEBUG ApplicationLogManagerImpl:122 - 1 app logs to save [app-log-persist]
2023-05-15 17:51:40,540 DEBUG ConnectionManager:444 - opening JDBC connection [app-log-persist]
2023-05-15 17:51:40,540 DEBUG SQL:111 - select printergro0_.printer_id as printer1_10_0_, printergro0_.printer_group_id as printer2_0_ from tbl_printer_printer_group printergro0_ where printergro0_.printer_id=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,541 DEBUG HibernateDAOBase:141 - Saving: PersistedApplicationLogEntry[id=0,entryTime=2023-05-15T17:51:40,entryLevel=INFO,message=Admin user "admin" modified the print script on printer "[Template printer]"] [app-log-persist]
2023-05-15 17:51:40,541 DEBUG SQL:111 - insert into tbl_application_log (log_date, server_name, log_level, message, application_log_id) values (?, ?, ?, ?, ?) [app-log-persist]
2023-05-15 17:51:40,541 DEBUG SQL:111 - update tbl_printer_attribute set attrib_value=?, modified_ticks=?, propagate=? where printer_id=? and attrib_name=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,542 DEBUG ConnectionManager:464 - releasing JDBC connection [app-log-persist]
2023-05-15 17:51:40,542 DEBUG ApplicationLogManagerImpl:103 - Wait for app logs [app-log-persist]
2023-05-15 17:51:40,543 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,544 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,544 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.Group g   (Params: Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,545 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_group group0_ fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,546 DEBUG HibernateDAOBase:392 - Count: 1 (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,546 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,547 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,547 DEBUG HibernateDAOBase:377 - HQL: from Group g (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,547 DEBUG SQL:111 - select group0_.group_id as group1_6_, group0_.group_name as group2_6_, group0_.initial_credit as initial3_6_, group0_.initially_restricted as initially4_6_, group0_.schedule_period as schedule5_6_, group0_.schedule_amount as schedule6_6_, group0_.allow_accum as allow7_6_, group0_.max_accum_balance as max8_6_, group0_.reset_statistics as reset9_6_, group0_.created_date as created10_6_, group0_.created_by as created11_6_, group0_.modified_date as modified12_6_, group0_.modified_by as modified13_6_, group0_.initial_settings_enabled as initial14_6_, group0_.modified_ticks as modified15_6_ from tbl_group group0_ (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,548 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,549 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,550 DEBUG PrinterDetails:784 - pageBeginRender: PrinterDetails (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,550 DEBUG HibernateDAOBase:377 - HQL:  from biz.papercut.pcng.domain.PrinterGroup order by groupName  (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,553 DEBUG SQL:111 - select printergro0_.printer_group_id as printer1_13_, printergro0_.group_name as group2_13_, printergro0_.display_name as display3_13_, printergro0_.created_date as created4_13_, printergro0_.created_by as created5_13_, printergro0_.modified_date as modified6_13_, printergro0_.modified_by as modified7_13_, printergro0_.modified_ticks as modified8_13_ from tbl_printer_group printergro0_ order by printergro0_.group_name (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,554 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,623 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,624 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,624 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,625 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,626 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,628 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,630 DEBUG PaperSizeTablePrintCostModel:70 - Enabling region-specific common page sizes with default costs for first time use: [LETTER, LEGAL, 11X17] (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,631 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,631 DEBUG HibernateDAOBase:377 - HQL: select p.id, p.serverName, p.printerName, p.displayName, p.deviceType, p.extDeviceFunction, p.location, p.lastUsageDate, p.slaveServerUuid, p.physicalPrinterId, p.printerType FROM biz.papercut.pcng.domain.Printer p  WHERE p.deleted = 'N'  AND (p.deviceType IN (:deviceTypes))  AND p.printerName != :templatePrinter  AND p.parentPrinter is null  ORDER BY coalesce(p.serverName, '!'), p.printerName (Params: deviceTypes=[PRINTER, PRINTER_WITH_QUEUES, VIRTUAL_QUEUE, VIRTUAL_PRINTER_WITH_QUEUES], templatePrinter=!!template printer!!) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,632 DEBUG SQL:111 - select printer0_.printer_id as col_0_0_, printer0_.server_name as col_1_0_, printer0_.printer_name as col_2_0_, printer0_.display_name as col_3_0_, printer0_.device_type as col_4_0_, printer0_.ext_device_function as col_5_0_, printer0_.location as col_6_0_, printer0_.last_usage_date as col_7_0_, printer0_.server_uuid as col_8_0_, printer0_.physical_printer_id as col_9_0_, printer0_.printer_type as col_10_0_ from tbl_printer printer0_ where printer0_.deleted='N' and (printer0_.device_type in (? , ? , ? , ?)) and printer0_.printer_name<>? and (printer0_.parent_id is null) order by coalesce(printer0_.server_name, '!'), printer0_.printer_name (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,633 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,633 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,634 DEBUG HibernateDAOBase:377 - HQL: select p.id, p.serverName, p.printerName, p.displayName, p.deviceType, p.extDeviceFunction, p.location, p.lastUsageDate, p.slaveServerUuid, p.physicalPrinterId, p.printerType FROM biz.papercut.pcng.domain.Printer p  WHERE p.deleted = 'N'  AND (p.deviceType NOT IN (:deviceTypes))  AND p.printerName != :templatePrinter  AND p.parentPrinter is null  ORDER BY coalesce(p.serverName, '!'), p.printerName (Params: deviceTypes=[PRINTER, PRINTER_WITH_QUEUES, VIRTUAL_QUEUE, VIRTUAL_PRINTER_WITH_QUEUES], templatePrinter=!!template printer!!) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,634 DEBUG SQL:111 - select printer0_.printer_id as col_0_0_, printer0_.server_name as col_1_0_, printer0_.printer_name as col_2_0_, printer0_.display_name as col_3_0_, printer0_.device_type as col_4_0_, printer0_.ext_device_function as col_5_0_, printer0_.location as col_6_0_, printer0_.last_usage_date as col_7_0_, printer0_.server_uuid as col_8_0_, printer0_.physical_printer_id as col_9_0_, printer0_.printer_type as col_10_0_ from tbl_printer printer0_ where printer0_.deleted='N' and (printer0_.device_type not in  (? , ? , ? , ?)) and printer0_.printer_name<>? and (printer0_.parent_id is null) order by coalesce(printer0_.server_name, '!'), printer0_.printer_name (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,635 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,643 DEBUG WebEngine:93 - Finish render: PrinterDetails (144 ms) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,644 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 147ms [http-84]
2023-05-15 17:51:40,647 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-82]
2023-05-15 17:51:40,654 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-82]
2023-05-15 17:51:40,654 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,654 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,654 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,658 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,659 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,659 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,660 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,661 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,661 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,663 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,664 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,664 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,668 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,671 DEBUG WebEngine:93 - Finish render: ConfigEditor (17 ms) (POST - /app, user: 'admin', loginType: Admin) [http-82]
2023-05-15 17:51:40,671 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 24ms [http-82]
2023-05-15 17:51:40,673 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-94]
2023-05-15 17:51:40,693 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-94]
2023-05-15 17:51:40,694 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,695 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,695 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,696 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,697 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,698 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print-and-device.script.enabled%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,698 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,698 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,715 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,717 DEBUG WebEngine:93 - Finish render: StaleLink (23 ms) (POST - /app, user: 'admin', loginType: Admin) [http-94]
2023-05-15 17:51:40,717 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 44ms [http-94]
2023-05-15 17:51:40,738 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-84]
2023-05-15 17:51:40,740 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-84]
2023-05-15 17:51:40,742 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,743 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,743 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,744 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,746 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print.script.sandboxed%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,746 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,747 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,748 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,749 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,751 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print.script.sandboxed%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,751 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,751 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,756 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,758 DEBUG WebEngine:93 - Finish render: ConfigEditor (18 ms) (POST - /app, user: 'admin', loginType: Admin) [http-84]
2023-05-15 17:51:40,759 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 21ms [http-84]
2023-05-15 17:51:40,762 DEBUG Jetty:924 - >>> 18.246.57.67 HTTP/1.1 POST /app [http-98]
2023-05-15 17:51:40,911 DEBUG WebEngine:70 - Start render (POST): /app, IP: 18.246.57.67, SessionID: node01hqa55290f5lx15t9w2s6q7nl813, Visit[created=2023-05-15 17:51:38,userName=admin,loginType=Admin,startPage=Dashboard] (POST - /app) [http-98]
2023-05-15 17:51:40,912 DEBUG HibernateDAOBase:377 - HQL: select count(*) FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  (Params: propertyNameText=%print.script.sandboxed%, Limit: 1) (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,913 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,913 DEBUG SQL:111 - select count(*) as col_0_0_ from tbl_config configprop0_ where configprop0_.property_name like ? fetch first 1 rows only (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,914 DEBUG HibernateDAOBase:392 - Count: 0 (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,915 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,916 DEBUG HibernateDAOBase:377 - HQL:  FROM biz.papercut.pcng.domain.ConfigProperty cp  WHERE cp.propertyName LIKE :propertyNameText  order by cp.propertyName asc (Params: propertyNameText=%print.script.sandboxed%, Limit: 25) (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,916 DEBUG ConnectionManager:444 - opening JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,916 DEBUG SQL:111 - select configprop0_.property_name as property1_5_, configprop0_.property_value as property2_5_, configprop0_.created_date as created3_5_, configprop0_.created_by as created4_5_, configprop0_.modified_date as modified5_5_, configprop0_.modified_by as modified6_5_, configprop0_.modified_ticks as modified7_5_, configprop0_.propagate as propagate5_ from tbl_config configprop0_ where configprop0_.property_name like ? order by configprop0_.property_name asc fetch first 25 rows only (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,979 DEBUG ConnectionManager:464 - releasing JDBC connection (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,981 DEBUG WebEngine:93 - Finish render: StaleLink (70 ms) (POST - /app, user: 'admin', loginType: Admin) [http-98]
2023-05-15 17:51:40,981 DEBUG Jetty:934 - <<< 18.246.57.67 HTTP/1.1 POST /app => Status: 200, Content-Type: text/html;charset=utf-8, Took 220ms [http-98]
2023-05-15 17:51:41,269 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:51:41,481 DEBUG SystemStateSerializerImpl:86 - Saved system state in 197ms, job-authentication: 155ms, user-client-data: 9ms, script-state: 10ms, held-jobs: 5ms, web-print: 14ms, device-txns: 4ms [system-state-save-thread]
2023-05-15 17:51:41,777 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:51:43,639 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 14.3%, System CPU: 90.9%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 24s [spring-scheduled-task-1]
2023-05-15 17:51:44,137 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:51:44,137 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:51:44,137 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:51:44,138 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:51:44,138 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:51:46,778 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:51:47,483 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:51:47,499 DEBUG SystemStateSerializerImpl:86 - Saved system state in 16ms, job-authentication: 3ms, user-client-data: 2ms, script-state: 3ms, held-jobs: 3ms, web-print: 2ms, device-txns: 3ms [system-state-save-thread]
2023-05-15 17:51:48,660 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.9%, System CPU: 78.6%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 29s [spring-scheduled-task-1]
2023-05-15 17:51:48,848 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' and s.serverState != :offlineState (Params: serverType=SLAVE, offlineState=SLAVE_OFFLINE) [server-sync-generation]
2023-05-15 17:51:48,848 DEBUG ConnectionManager:444 - opening JDBC connection [server-sync-generation]
2023-05-15 17:51:48,848 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' and server0_.server_state<>? [server-sync-generation]
2023-05-15 17:51:48,848 DEBUG ConnectionManager:464 - releasing JDBC connection [server-sync-generation]
2023-05-15 17:51:48,849 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) [server-sync-generation]
2023-05-15 17:51:48,849 DEBUG ConnectionManager:444 - opening JDBC connection [server-sync-generation]
2023-05-15 17:51:48,849 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? [server-sync-generation]
2023-05-15 17:51:48,849 DEBUG ConnectionManager:464 - releasing JDBC connection [server-sync-generation]
2023-05-15 17:51:51,789 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:51:53,503 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:51:53,518 DEBUG SystemStateSerializerImpl:86 - Saved system state in 15ms, job-authentication: 0ms, user-client-data: 0ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 15ms [system-state-save-thread]
2023-05-15 17:51:53,667 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.7%, System CPU: 54.5%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 34s [spring-scheduled-task-5]
2023-05-15 17:51:54,150 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:51:54,150 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:51:54,150 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:51:54,150 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:51:54,150 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:51:56,795 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:51:58,692 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.9%, System CPU: 53.0%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 39s [spring-scheduled-task-5]
2023-05-15 17:51:59,524 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:51:59,540 DEBUG SystemStateSerializerImpl:86 - Saved system state in 16ms, job-authentication: 0ms, user-client-data: 0ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 16ms [system-state-save-thread]
2023-05-15 17:51:59,931 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:51:59,931 DEBUG ConnectionManager:444 - opening JDBC connection [TrialLicenseInspector]
2023-05-15 17:51:59,931 DEBUG HibernateDAOBase:377 - HQL: select count( u.id)  from User u  where u.deleted = 'N'  [TrialLicenseInspector]
2023-05-15 17:51:59,931 DEBUG SQL:111 - select count(user0_.user_id) as col_0_0_ from tbl_user user0_ where user0_.deleted='N' [TrialLicenseInspector]
2023-05-15 17:51:59,936 DEBUG HibernateDAOBase:392 - Count: 2501 [TrialLicenseInspector]
2023-05-15 17:51:59,937 DEBUG ConnectionManager:464 - releasing JDBC connection [TrialLicenseInspector]
2023-05-15 17:51:59,938 DEBUG ConnectionManager:444 - opening JDBC connection [TrialLicenseInspector]
2023-05-15 17:51:59,938 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) [TrialLicenseInspector]
2023-05-15 17:51:59,938 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? [TrialLicenseInspector]
2023-05-15 17:51:59,938 DEBUG ConnectionManager:464 - releasing JDBC connection [TrialLicenseInspector]
2023-05-15 17:51:59,939 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT [TrialLicenseInspector]
2023-05-15 17:51:59,939 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. [TrialLicenseInspector]
2023-05-15 17:51:59,939 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] [TrialLicenseInspector]
2023-05-15 17:51:59,939 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:52:01,808 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:03,696 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.4%, System CPU: 54.6%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 44s [spring-scheduled-task-3]
2023-05-15 17:52:04,159 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:52:04,160 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:52:04,160 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:52:04,160 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:52:04,161 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:52:05,540 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:05,540 DEBUG SystemStateSerializerImpl:86 - Saved system state in 0ms, job-authentication: 0ms, user-client-data: 0ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 0ms [system-state-save-thread]
2023-05-15 17:52:06,808 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:08,723 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.8%, System CPU: 60.0%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 49s [spring-scheduled-task-2]
2023-05-15 17:52:11,544 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:11,559 DEBUG SystemStateSerializerImpl:86 - Saved system state in 15ms, job-authentication: 0ms, user-client-data: 0ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 15ms [system-state-save-thread]
2023-05-15 17:52:11,825 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:13,739 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.7%, System CPU: 55.4%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 54s [spring-scheduled-task-5]
2023-05-15 17:52:14,171 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:52:14,171 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:52:14,171 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:52:14,171 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:52:14,171 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:52:16,836 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:17,567 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:17,589 DEBUG SystemStateSerializerImpl:86 - Saved system state in 22ms, job-authentication: 2ms, user-client-data: 0ms, script-state: 0ms, held-jobs: 0ms, web-print: 16ms, device-txns: 4ms [system-state-save-thread]
2023-05-15 17:52:18,756 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.5%, System CPU: 56.5%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 16m 59s [spring-scheduled-task-5]
2023-05-15 17:52:21,847 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:23,591 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:23,609 DEBUG SystemStateSerializerImpl:86 - Saved system state in 17ms, job-authentication: 3ms, user-client-data: 2ms, script-state: 3ms, held-jobs: 4ms, web-print: 3ms, device-txns: 2ms [system-state-save-thread]
2023-05-15 17:52:23,783 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 1.2%, System CPU: 58.3%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 4s [spring-scheduled-task-3]
2023-05-15 17:52:24,192 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:52:24,192 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:52:24,192 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:52:24,192 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:52:24,193 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:52:26,847 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:28,795 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.9%, System CPU: 64.3%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 9s [spring-scheduled-task-3]
2023-05-15 17:52:29,619 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:29,619 DEBUG SystemStateSerializerImpl:86 - Saved system state in 0ms, job-authentication: 0ms, user-client-data: 0ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 0ms [system-state-save-thread]
2023-05-15 17:52:29,951 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:52:29,951 DEBUG ConnectionManager:444 - opening JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:29,951 DEBUG HibernateDAOBase:377 - HQL: select count( u.id)  from User u  where u.deleted = 'N'  [TrialLicenseInspector]
2023-05-15 17:52:29,951 DEBUG SQL:111 - select count(user0_.user_id) as col_0_0_ from tbl_user user0_ where user0_.deleted='N' [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG HibernateDAOBase:392 - Count: 2501 [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG ConnectionManager:464 - releasing JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG ConnectionManager:444 - opening JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG ConnectionManager:464 - releasing JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] [TrialLicenseInspector]
2023-05-15 17:52:29,953 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:52:31,854 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:33,810 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 754/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.8%, System CPU: 56.8%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 14s [spring-scheduled-task-5]
2023-05-15 17:52:34,194 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:52:34,194 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:52:34,194 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:52:34,194 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:52:34,195 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:52:35,619 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:35,639 DEBUG SystemStateSerializerImpl:86 - Saved system state in 19ms, job-authentication: 3ms, user-client-data: 3ms, script-state: 3ms, held-jobs: 4ms, web-print: 3ms, device-txns: 3ms [system-state-save-thread]
2023-05-15 17:52:36,863 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:38,835 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 755/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.7%, System CPU: 63.1%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 19s [spring-scheduled-task-1]
2023-05-15 17:52:41,643 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:41,647 DEBUG SystemStateSerializerImpl:86 - Saved system state in 4ms, job-authentication: 0ms, user-client-data: 4ms, script-state: 0ms, held-jobs: 0ms, web-print: 0ms, device-txns: 0ms [system-state-save-thread]
2023-05-15 17:52:41,865 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:43,853 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 755/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.7%, System CPU: 59.3%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 24s [spring-scheduled-task-2]
2023-05-15 17:52:44,205 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:52:44,205 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:52:44,205 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:52:44,205 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:52:44,205 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:52:46,878 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:47,661 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:47,679 DEBUG SystemStateSerializerImpl:86 - Saved system state in 18ms, job-authentication: 3ms, user-client-data: 3ms, script-state: 3ms, held-jobs: 4ms, web-print: 3ms, device-txns: 2ms [system-state-save-thread]
2023-05-15 17:52:48,870 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 756/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.6%, System CPU: 57.0%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 29s [spring-scheduled-task-2]
2023-05-15 17:52:51,883 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:53,686 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:53,705 DEBUG SystemStateSerializerImpl:86 - Saved system state in 19ms, job-authentication: 3ms, user-client-data: 3ms, script-state: 3ms, held-jobs: 4ms, web-print: 3ms, device-txns: 3ms [system-state-save-thread]
2023-05-15 17:52:53,880 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 756/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 1.2%, System CPU: 61.4%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 34s [spring-scheduled-task-2]
2023-05-15 17:52:54,216 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:52:54,216 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:52:54,216 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:52:54,217 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:52:54,217 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:52:56,895 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:52:58,893 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 756/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.5%, System CPU: 52.1%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 39s [spring-scheduled-task-2]
2023-05-15 17:52:59,711 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:52:59,727 DEBUG SystemStateSerializerImpl:86 - Saved system state in 16ms, job-authentication: 3ms, user-client-data: 3ms, script-state: 2ms, held-jobs: 3ms, web-print: 3ms, device-txns: 2ms [system-state-save-thread]
2023-05-15 17:52:59,959 DEBUG LicenseUtils:245 - License details (before checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG ConnectionManager:444 - opening JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG HibernateDAOBase:377 - HQL: select count( u.id)  from User u  where u.deleted = 'N'  [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG SQL:111 - select count(user0_.user_id) as col_0_0_ from tbl_user user0_ where user0_.deleted='N' [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG HibernateDAOBase:392 - Count: 2501 [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG ConnectionManager:464 - releasing JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG ConnectionManager:444 - opening JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType (Params: serverType=SLAVE) [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG ConnectionManager:464 - releasing JDBC connection [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG LicenseUtils:999 - Module has been enabled in DB: PRINT [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG LicenseUtils:1003 - Module is licensed or we're in the trial license. [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG LicenseUtils:1022 - Module status: ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>] [TrialLicenseInspector]
2023-05-15 17:52:59,959 DEBUG LicenseUtils:405 - License details (after checks): License[org=Trial License,order ID=,customerReferenceNo=,users=-1,purchasedUsers=0,numberOfUsersInDB=2501,modules=PRINT,version=17,releaseStations=-1,advancedClients=-1,siteServers=0,extras={},expDate=2023-06-24T23:59:59,status=VALID,moduleStatus={PRINT=ModuleLicenseStatus[module=PRINT,licensed=Y,enabled=Y,expiryDate=<null>]},supportExpiry=<null>] [TrialLicenseInspector]
2023-05-15 17:53:01,910 DEBUG ConnectionPoolHealthChecker:94 - Database connections (total/active/idle/peak) - Main: 20/0/20/20, Secondary: 1/0/1/3, DB URL: jdbc:derby:derby, Used: 5.00% of 400 in main, 5.00% of 20 in secondary [db-connection-logger]
2023-05-15 17:53:03,898 DEBUG SystemPerformanceHealthChecker:149 - Memory MB (used/total/max): 756/1,688/3,600, Metaspace: 155/169/Unlimited, Threads: 98, Process CPU: 0.4%, System CPU: 53.9%, GC executions: 29, GC time: 3703 ms, Uptime: 0d 2h 17m 44s [spring-scheduled-task-3]
2023-05-15 17:53:04,231 DEBUG ConnectionManager:444 - opening JDBC connection [server-state-monitor]
2023-05-15 17:53:04,231 DEBUG HibernateDAOBase:377 - HQL: from Server s where s.deleted = 'N' and s.serverType = :serverType and s.enabled = 'Y' (Params: serverType=SLAVE) [server-state-monitor]
2023-05-15 17:53:04,231 DEBUG SQL:111 - select server0_.server_id as server1_18_, server0_.modified_ticks as modified2_18_, server0_.uuid as uuid18_, server0_.enabled as enabled18_, server0_.deleted as deleted18_, server0_.deleted_date as deleted6_18_, server0_.server_name as server7_18_, server0_.server_type as server8_18_, server0_.server_state as server9_18_, server0_.location as location18_, server0_.notes as notes18_, server0_.major_version as major12_18_, server0_.minor_version as minor13_18_, server0_.build_id as build14_18_, server0_.sync_ticks as sync15_18_, server0_.display_name as display16_18_, server0_.network_address as network17_18_, server0_.created_date as created18_18_, server0_.created_by as created19_18_, server0_.modified_date as modified20_18_, server0_.modified_by as modified21_18_ from tbl_server server0_ where server0_.deleted='N' and server0_.server_type=? and server0_.enabled='Y' [server-state-monitor]
2023-05-15 17:53:04,231 DEBUG ConnectionManager:464 - releasing JDBC connection [server-state-monitor]
2023-05-15 17:53:04,232 DEBUG ServerStateManagerImpl:805 - Done scanning for offline site servers. Online: 0, Offline: 0:  [server-state-monitor]
2023-05-15 17:53:05,727 DEBUG SystemStateSerializerImpl:70 - Saving system state to: C:\Program Files\PaperCut NG\server\data\internal\state\systemstate [system-state-save-thread]
2023-05-15 17:53:05,