24-Jun-2024 14:28:33.076 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.82 24-Jun-2024 14:28:33.078 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Oct 11 2023 13:15:08 UTC 24-Jun-2024 14:28:33.078 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.82.0 24-Jun-2024 14:28:33.078 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10 24-Jun-2024 14:28:33.078 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0 24-Jun-2024 14:28:33.079 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 24-Jun-2024 14:28:33.079 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files\Java\jre1.8.0_333 24-Jun-2024 14:28:33.079 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_333-b02 24-Jun-2024 14:28:33.079 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation 24-Jun-2024 14:28:33.079 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Yellowfin\appserver 24-Jun-2024 14:28:33.079 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Yellowfin\appserver 24-Jun-2024 14:28:33.080 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Yellowfin\appserver\conf\logging.properties 24-Jun-2024 14:28:33.080 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 24-Jun-2024 14:28:33.080 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m 24-Jun-2024 14:28:33.080 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx25521m 24-Jun-2024 14:28:33.080 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl 24-Jun-2024 14:28:33.081 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djavax.xml.soap.SOAPConnectionFactory=org.apache.axis.soap.SOAPConnectionFactoryImpl 24-Jun-2024 14:28:33.082 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djavax.xml.soap.SOAPFactory=org.apache.axis.soap.SOAPFactoryImpl 24-Jun-2024 14:28:33.082 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 24-Jun-2024 14:28:33.083 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 24-Jun-2024 14:28:33.083 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= 24-Jun-2024 14:28:33.084 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Yellowfin\appserver 24-Jun-2024 14:28:33.085 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Yellowfin\appserver 24-Jun-2024 14:28:33.086 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Yellowfin\appserver\temp 24-Jun-2024 14:28:33.087 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -agentpath:C:\Program Files\SentinelOne\Sentinel Agent 23.3.3.264\SentinelJava64.dll=extendedCapabilities 24-Jun-2024 14:28:33.101 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.39] using APR version [1.7.4]. 24-Jun-2024 14:28:33.103 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true], UDS [true]. 24-Jun-2024 14:28:33.103 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 24-Jun-2024 14:28:33.112 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 3.0.11 19 Sep 2023] 24-Jun-2024 14:28:33.341 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8085"] 24-Jun-2024 14:28:33.352 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [497] milliseconds 24-Jun-2024 14:28:33.378 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 24-Jun-2024 14:28:33.379 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.82] 24-Jun-2024 14:28:33.390 INFO [main] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying deployment descriptor [C:\Yellowfin\appserver\conf\Catalina\localhost\ROOT.xml] 24-Jun-2024 14:28:33.420 WARNING [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Context/Manager] failed to set property [distributable] to [false] 24-Jun-2024 14:28:42.168 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 24-Jun-2024 14:28:43.273 INFO [main] com.sun.xml.ws.transport.http.servlet.WSServletContextListener.contextInitialized WSSERVLET12: JAX-WS context listener initializing 24-Jun-2024 14:28:44.857 INFO [main] com.sun.xml.ws.server.MonitorBase.createRoot Metro monitoring rootname successfully set to: com.sun.metro:pp=/,type=WSEndpoint,name=-HelloServiceService-HelloServicePort 24-Jun-2024 14:28:45.479 INFO [main] com.sun.xml.ws.server.MonitorBase.createRoot Metro monitoring rootname successfully set to: com.sun.metro:pp=/,type=WSEndpoint,name=-LegacyReportServiceService-LegacyReportServicePort 24-Jun-2024 14:28:45.763 INFO [main] com.sun.xml.ws.server.MonitorBase.createRoot Metro monitoring rootname successfully set to: com.sun.metro:pp=/,type=WSEndpoint,name=-LegacyAdministrationServiceService-LegacyAdministrationServicePort 24-Jun-2024 14:28:45.807 INFO [main] com.sun.xml.ws.server.MonitorBase.createRoot Metro monitoring rootname successfully set to: com.sun.metro:pp=/,type=WSEndpoint,name=-LegacyVersionServiceService-LegacyVersionServicePort 24-Jun-2024 14:28:45.835 INFO [main] com.sun.xml.ws.transport.http.servlet.WSServletDelegate. WSSERVLET14: JAX-WS servlet initializing 24-Jun-2024 14:28:46.092 WARNING [main] org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [255] milliseconds. YF:2024-06-24 14:28:46.287: INFO (DispatcherServlet) - Initializing Servlet 'dispatcher' YF:2024-06-24 14:28:48.810: INFO (DispatcherServlet) - Completed initialization in 2514 ms ============================== BO Finder Startup ======================= | | Loading plugin modules... | com.hof.interfaces.GroupFlatten : com.hof.adapter.JDBCGroupFlatten | com.hof.interfaces.EventCreation : com.hof.adapter.JDBCEventCreation | com.hof.interfaces.SystemUtil : com.hof.adapter.JDBCSystemUtil | com.hof.interfaces.FileUpload : com.hof.adapter.JDBCFileUpload | com.hof.interfaces.Authentication : com.hof.adapter.YFConfigAuthentication | OK | | Plugins loaded: 5 | ======================================================================== =================== i4 JDBC Connection Pool ================================ | | Description : Yellowfin Connection Pool | JDBC Driver : org.postgresql.Driver | Url : jdbc:postgresql://sprint-test-psqldb.dev.dawinci.cloud:5432/yf-incredibles-test | User : dwdbinstall | Min Count : 2 | Max Count : 25 | Recycle : null | Timeout : null | PS Cache Size: null | JDBC Fetch Size: null | Isolation Level: null | Heart Beat: true | No Verify: false | No Lock: false | | JDBCFetchSize parameter could not be parsed | Performing JDBC connections... OK | | The i4 JDBC Connection pool has been successfully started. | ======================================================================== =================== Liquibase Migration ================================ | | Fetching Respository Connection... | Enabling Indefinite Connection Timeout... | Pass Repository Connection to Liquibase... YF:2024-06-24 14:28:55.660: INFO (PostgresDatabase) - Set default schema name to public | Liquibase has identidied database as: dwdbinstall @ jdbc:postgresql://sprint-test-psqldb.dev.dawinci.cloud:5432/yf-incredibles-test (Default Schema: public) | Processing Schema Update... YF:2024-06-24 14:28:55.967: INFO (PGLockService) - Successfully acquired change session log lock YF:2024-06-24 14:28:55.980: INFO (StandardServiceLocator) - Cannot load service: liquibase.parser.ChangeLogParser: Provider liquibase.parser.core.json.JsonChangeLogParser could not be instantiated YF:2024-06-24 14:28:55.991: INFO (StandardServiceLocator) - Cannot load service: liquibase.parser.ChangeLogParser: Provider liquibase.parser.core.yaml.YamlChangeLogParser could not be instantiated YF:2024-06-24 14:28:56.123: INFO (StandardServiceLocator) - Cannot load service: liquibase.change.Change: Provider liquibase.change.core.LoadDataChange could not be instantiated YF:2024-06-24 14:28:56.126: INFO (StandardServiceLocator) - Cannot load service: liquibase.change.Change: Provider liquibase.change.core.LoadUpdateDataChange could not be instantiated YF:2024-06-24 14:28:57.026: INFO (StandardChangeLogHistoryService) - Reading from public.databasechangelog YF:2024-06-24 14:28:58.461: INFO (UpdateCommandStep) - Using deploymentId: 9219537608 YF:2024-06-24 14:28:58.478: INFO (StandardServiceLocator) - Cannot load service: liquibase.hub.HubService: Provider liquibase.hub.core.StandardHubService could not be instantiated YF:2024-06-24 14:28:58.630: INFO (StandardChangeLogHistoryService) - Reading from public.databasechangelog Running Changeset: com/hof/patch/db-schema-changelog-8.0.xml::YFN-21641 Increase FormatCode to fit encrypted passwords for SQL Server::pd YF:2024-06-24 14:28:58.806: INFO (ChangeSet) - Continuing past: com/hof/patch/db-schema-changelog-8.0.xml::YFN-21641 Increase FormatCode to fit encrypted passwords for SQL Server::pd despite precondition failure due to onFail='CONTINUE': com/hof/patch/db-schema-changelog-master.xml : DBMS Precondition failed: expected mssql, got postgresql Running Changeset: com/hof/patch/db-schema-changelog-9.0.xml::YFN-24309 Dashboard Filter Group Names in Japanese get garbled when using SQL Server::harin YF:2024-06-24 14:28:59.401: INFO (ChangeSet) - Continuing past: com/hof/patch/db-schema-changelog-9.0.xml::YFN-24309 Dashboard Filter Group Names in Japanese get garbled when using SQL Server::harin despite precondition failure due to onFail='CONTINUE': com/hof/patch/db-schema-changelog-master.xml : DBMS Precondition failed: expected mssql, got postgresql YF:2024-06-24 14:28:59.723: INFO (ShowSummaryUtil) - UPDATE SUMMARY YF:2024-06-24 14:28:59.724: INFO (ShowSummaryUtil) - Run: 2 YF:2024-06-24 14:28:59.726: INFO (ShowSummaryUtil) - Previously run: 74 YF:2024-06-24 14:28:59.728: INFO (ShowSummaryUtil) - Filtered out: 0 YF:2024-06-24 14:28:59.732: INFO (ShowSummaryUtil) - ------------------------------- YF:2024-06-24 14:28:59.732: INFO (ShowSummaryUtil) - Total change sets: 76 UPDATE SUMMARY Run: 2 Previously run: 74 Filtered out: 0 ------------------------------- Total change sets: 76 YF:2024-06-24 14:28:59.734: INFO (ShowSummaryUtil) - Update summary generated YF:2024-06-24 14:28:59.736: INFO (UpdateCommandStep) - Update command completed successfully. Liquibase: Update has been successful. YF:2024-06-24 14:28:59.884: INFO (PGLockService) - Successfully released change log session lock YF:2024-06-24 14:28:59.887: INFO (CommandScope) - Command execution complete | Processing Schema Update Complete | Processing Content Update... YF:2024-06-24 14:29:00.041: INFO (PGLockService) - Successfully acquired change session log lock YF:2024-06-24 14:29:00.779: INFO (StandardChangeLogHistoryService) - Reading from public.databasechangelog YF:2024-06-24 14:29:01.264: INFO (UpdateCommandStep) - Using deploymentId: 9219541078 YF:2024-06-24 14:29:01.270: INFO (ShowSummaryUtil) - UPDATE SUMMARY YF:2024-06-24 14:29:01.271: INFO (ShowSummaryUtil) - Run: 0 YF:2024-06-24 14:29:01.271: INFO (ShowSummaryUtil) - Previously run: 47 YF:2024-06-24 14:29:01.273: INFO (ShowSummaryUtil) - Filtered out: 0 YF:2024-06-24 14:29:01.273: INFO (ShowSummaryUtil) - ------------------------------- YF:2024-06-24 14:29:01.274: INFO (ShowSummaryUtil) - Total change sets: 47 UPDATE SUMMARY Run: 0 Previously run: 47 Filtered out: 0 ------------------------------- Total change sets: 47 YF:2024-06-24 14:29:01.275: INFO (ShowSummaryUtil) - Update summary generated YF:2024-06-24 14:29:01.276: INFO (UpdateCommandStep) - Update command completed successfully. Liquibase: Update has been successful. YF:2024-06-24 14:29:01.428: INFO (PGLockService) - Successfully released change log session lock YF:2024-06-24 14:29:01.431: INFO (CommandScope) - Command execution complete | Processing Content Update Complete | Processing Custom Updates... YF:2024-06-24 14:29:01.587: INFO (PGLockService) - Successfully acquired change session log lock YF:2024-06-24 14:29:02.240: INFO (StandardChangeLogHistoryService) - Reading from public.databasechangelog YF:2024-06-24 14:29:02.683: INFO (UpdateCommandStep) - Using deploymentId: 9219542534 Running Changeset: com/hof/patch/db-schema-changelog-dashboard.xml::YFN-19342 Add publish UUID to WidgetItem and ReportGroupEntity::sarah YF:2024-06-24 14:34:55.090:ERROR (WidgetItemManager) - [1] [Background] [STARTUP] Errors occured updating WidgetItem: This statement has been closed. YF:2024-06-24 14:34:55.092:ERROR (WidgetItemManager) - [1] [Background] [STARTUP] SQL Stmt: UPDATE WidgetItem SET WidgetUUID = ?, CanvasUUID = ?, WidgetType = ?, PositionLeft = ?, PositionTop = ?, Width = ?, Height = ?, SortOrder = ?, DrawOrder = ?, WidgetTemplate = ?, WidgetName = ?, ConditionalFormatEnabled = ?, PublishUUID = ? WHERE WidgetUUID = ? YF:2024-06-24 14:34:56.991:ERROR (YFN19605AddPublishUUIDToWidgetItemAndReportGroupEntity) - [1] [Background] [STARTUP] Error adding WidgetItem.PublishUUIDs and ReportGroupEntity.PublishUUIDs: org.postgresql.util.PSQLException: This statement has been closed. org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:742) ~[postgresql-42.5.0.jar:42.5.0] at org.postgresql.jdbc.PgPreparedStatement.setObject(PgPreparedStatement.java:981) ~[postgresql-42.5.0.jar:42.5.0] at com.hof.managers.PreparedStatementBinder.bindValues(PreparedStatementBinder.java:184) ~[i4-core.jar:9.10 (20231204)] at com.hof.managers.PreparedStatementBinder.bindValues(PreparedStatementBinder.java:47) ~[i4-core.jar:9.10 (20231204)] at com.hof.mi.manager.WidgetItemManager.bindValuesToPreparedStatement(WidgetItemManager.java:143) ~[i4-mi.jar:9.10 (20231204)] at com.hof.mi.manager.migration.WidgetItemMigrationManager.updateWidgetItemsPS(WidgetItemMigrationManager.java:118) ~[i4-mi.jar:9.10 (20231204)] at com.hof.patch.liquibase.YFN19605AddPublishUUIDToWidgetItemAndReportGroupEntity.B(YFN19605AddPublishUUIDToWidgetItemAndReportGroupEntity.java:105) ~[i4-core.jar:9.10 (20231204)] at com.hof.patch.liquibase.YFN19605AddPublishUUIDToWidgetItemAndReportGroupEntity.execute(YFN19605AddPublishUUIDToWidgetItemAndReportGroupEntity.java:41) ~[i4-core.jar:9.10 (20231204)] at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:168) ~[liquibase-core-4.21.1.jar:?] at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1267) ~[liquibase-core-4.21.1.jar:?] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:718) ~[liquibase-core-4.21.1.jar:?] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:61) ~[liquibase-core-4.21.1.jar:?] at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.lambda$child$0(Scope.java:194) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:203) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:193) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:172) ~[liquibase-core-4.21.1.jar:?] at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:111) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.lambda$child$0(Scope.java:194) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:203) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:193) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:172) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:260) ~[liquibase-core-4.21.1.jar:?] at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.lambda$child$0(Scope.java:194) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:203) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:193) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:172) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:260) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:264) ~[liquibase-core-4.21.1.jar:?] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:68) ~[liquibase-core-4.21.1.jar:?] at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:102) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.lambda$child$0(Scope.java:194) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:203) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:193) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:172) ~[liquibase-core-4.21.1.jar:?] at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:99) ~[liquibase-core-4.21.1.jar:?] at liquibase.command.CommandScope.execute(CommandScope.java:212) ~[liquibase-core-4.21.1.jar:?] at liquibase.Liquibase.lambda$update$0(Liquibase.java:237) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.lambda$child$0(Scope.java:194) ~[liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:203) [liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:193) [liquibase-core-4.21.1.jar:?] at liquibase.Scope.child(Scope.java:172) [liquibase-core-4.21.1.jar:?] at liquibase.Liquibase.runInScope(Liquibase.java:1618) [liquibase-core-4.21.1.jar:?] at liquibase.Liquibase.update(Liquibase.java:229) [liquibase-core-4.21.1.jar:?] at liquibase.Liquibase.update(Liquibase.java:213) [liquibase-core-4.21.1.jar:?] at com.hof.servlet.InitConnectionPool.A(InitConnectionPool.java:455) [i4-core.jar:9.10 (20231204)] at com.hof.servlet.InitConnectionPool.init(InitConnectionPool.java:312) [i4-core.jar:9.10 (20231204)] at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1106) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1063) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:960) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4641) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4948) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) [catalina.jar:9.0.82] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683) [catalina.jar:9.0.82] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:661) [catalina.jar:9.0.82] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:689) [catalina.jar:9.0.82] at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1888) [catalina.jar:9.0.82] at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_333] at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_333] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.82] at java.util.concurrent.AbstractExecutorService.submit(Unknown Source) [?:1.8.0_333] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:582) [catalina.jar:9.0.82] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472) [catalina.jar:9.0.82] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1617) [catalina.jar:9.0.82] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:318) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:114) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:345) [catalina.jar:9.0.82] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:893) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:794) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) [catalina.jar:9.0.82] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) [catalina.jar:9.0.82] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) [catalina.jar:9.0.82] at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_333] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.82] at java.util.concurrent.AbstractExecutorService.submit(Unknown Source) [?:1.8.0_333] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:248) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) [catalina.jar:9.0.82] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:921) [catalina.jar:9.0.82] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) [catalina.jar:9.0.82] at org.apache.catalina.startup.Catalina.start(Catalina.java:772) [catalina.jar:9.0.82] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_333] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_333] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_333] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_333] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:347) [bootstrap.jar:9.0.82] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478) [bootstrap.jar:9.0.82] YF:2024-06-24 14:34:57.030:ERROR (ChangeSet) - ChangeSet com/hof/patch/db-schema-changelog-dashboard.xml::YFN-19342 Add publish UUID to WidgetItem and ReportGroupEntity::sarah encountered an exception. YF:2024-06-24 14:34:57.354: INFO (UpdateCommandStep) - Update command encountered an exception. YF:2024-06-24 14:34:57.505: INFO (PGLockService) - Successfully released change log session lock YF:2024-06-24 14:34:57.506: INFO (CommandScope) - Command execution complete liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset com/hof/patch/db-schema-changelog-dashboard.xml::YFN-19342 Add publish UUID to WidgetItem and ReportGroupEntity::sarah: Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Error adding PublishUUID data to WidgetItem and ReportGroupEntity records at liquibase.command.CommandScope.execute(CommandScope.java:235) at liquibase.Liquibase.lambda$update$0(Liquibase.java:237) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Liquibase.runInScope(Liquibase.java:1618) at liquibase.Liquibase.update(Liquibase.java:229) at liquibase.Liquibase.update(Liquibase.java:213) at com.hof.servlet.InitConnectionPool.A(InitConnectionPool.java:455) at com.hof.servlet.InitConnectionPool.init(InitConnectionPool.java:312) at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1106) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1063) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:960) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4641) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4948) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:661) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:689) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1888) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.util.concurrent.AbstractExecutorService.submit(Unknown Source) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:582) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1617) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:318) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:114) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:345) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:893) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:794) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322) at java.util.concurrent.FutureTask.run(Unknown Source) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.util.concurrent.AbstractExecutorService.submit(Unknown Source) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:248) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:921) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) at org.apache.catalina.startup.Catalina.start(Catalina.java:772) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:347) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478) Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset com/hof/patch/db-schema-changelog-dashboard.xml::YFN-19342 Add publish UUID to WidgetItem and ReportGroupEntity::sarah: Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Error adding PublishUUID data to WidgetItem and ReportGroupEntity records at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:123) at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:102) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:99) at liquibase.command.CommandScope.execute(CommandScope.java:212) ... 54 more Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset com/hof/patch/db-schema-changelog-dashboard.xml::YFN-19342 Add publish UUID to WidgetItem and ReportGroupEntity::sarah: Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Error adding PublishUUID data to WidgetItem and ReportGroupEntity records at liquibase.changelog.ChangeSet.execute(ChangeSet.java:761) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:61) at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:111) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Scope.child(Scope.java:260) at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Scope.child(Scope.java:260) at liquibase.Scope.child(Scope.java:264) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:68) ... 61 more Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Error adding PublishUUID data to WidgetItem and ReportGroupEntity records at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:173) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1267) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:718) ... 81 more Caused by: liquibase.exception.CustomChangeException: Error adding PublishUUID data to WidgetItem and ReportGroupEntity records at com.hof.patch.liquibase.YFN19605AddPublishUUIDToWidgetItemAndReportGroupEntity.execute(YFN19605AddPublishUUIDToWidgetItemAndReportGroupEntity.java:67) at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:168) ... 83 more YF:2024-06-24 14:34:57.978: INFO (hofStartup) - [1] [Background] [STARTUP] === hofStartup Starting Up === ============================== i4 Startup ============================== | | Release Version: 9.10 | Current Code Version: 20231204 | Original Code Version: 20231204 | Schema Version: 20231204 | Boot Time: 24 June, 2024 2:34:57 PM IST | java.vm.name: Java HotSpot(TM) 64-Bit Server VM | java.vm.vendor: Oracle Corporation | java.vm.version: 25.333-b02 | os.name: Windows 10 | os.arch: amd64 | os.version: 10.0 | Memory Allocated: 23788519424 | Application Server: Apache Tomcat/9.0.82 | Servlet API Version: 4.0 | JSP API Version: 2.3 | | Initialising RefCodeList... OK | Available languages: EN_GB, DE, PT, EN_US, PT_BR, EN, IT, FR, ZH, ES, TH, JA, EN_AU, NL | Default language: EN | | | The i4 Utility classes listed above have been initialised. | ======================================================================== ================================ Licence Check ========================== | YF:2024-06-24 14:35:04.122: INFO (LicenceControl) - [1] [Background] [STARTUP] Resetting Licence Control YF:2024-06-24 14:35:04.470: INFO (LicenceControl) - [1] [Background] [STARTUP] Checking Features.. Licence Decryption ok: true YF:2024-06-24 14:35:04.479: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Checking Licenced metrics... YF:2024-06-24 14:35:04.492: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Counting Datasources... YF:2024-06-24 14:35:04.646: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] DataSources: 1 YF:2024-06-24 14:35:04.647: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Primary Org DataSources: 1 YF:2024-06-24 14:35:04.649: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Client Org DataSources: 0 YF:2024-06-24 14:35:04.661: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Counting UsageStats... YF:2024-06-24 14:35:05.644: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Counting Client Orgs YF:2024-06-24 14:35:05.848: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] There are about 0 Clients Orgs. YF:2024-06-24 14:35:05.849: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Building roles tree. YF:2024-06-24 14:35:08.920: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Dashboards: 1 YF:2024-06-24 14:35:08.921: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Writers: 1 YF:2024-06-24 14:35:08.923: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Consumers: 0 YF:2024-06-24 14:35:08.928: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Named Users: 0 YF:2024-06-24 14:35:08.930: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Email Users: 0 YF:2024-06-24 14:35:08.931: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Multicasts: 20 YF:2024-06-24 14:35:08.932: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Server Cores: 20 YF:2024-06-24 14:35:08.934: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Clients: 0 YF:2024-06-24 14:35:08.938: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Licenced Concurrent Users: 9999 YF:2024-06-24 14:35:08.942: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Licenced for Concurrent Mode: DISABLED YF:2024-06-24 14:35:08.946: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Cluster Cores: 0 YF:2024-06-24 14:35:08.947: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Cluster Signals Cores: 0 YF:2024-06-24 14:35:08.948: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Cluster Nodes: 0 YF:2024-06-24 14:35:08.952: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Signals Users: 1 YF:2024-06-24 14:35:08.955: INFO (LicenceCheckProcess) - [1] [Background] [STARTUP] Done Checking Licenced metrics... YF:2024-06-24 14:36:21.389: INFO (LicenceControl) - [1] [Background] [STARTUP] =========================================================================== YF:2024-06-24 14:36:21.389: INFO (LicenceControl) - [1] [Background] [STARTUP] This version of Yellowfin is a Development Version only -> Not For Resale YF:2024-06-24 14:36:21.396: INFO (LicenceControl) - [1] [Background] [STARTUP] =========================================================================== | | License Valid: Yes | Licensor: Yellowfin, Inc. | Licensee: Quorum Software Norway AS | Products: null | ServerName: localhost, Currently using: [AP-RFsRgP6k1E3L,AP-RFsRgP6k1E3L.corp.quorumsoftware.com,host.docker.internal,kubernetes.docker.internal,localhost] | Days Left: 162 | DataSources: 9999, Currently using: 1 | ClientDataSources: 9999, Currently using: 0 | Consumers: 9999, Currently using: 0 | Writers: 9999, Currently using: 1 | Dashboard: 9999, Currently using: 1 | NamedUsers: 9999, Currently using: 0 | ServerCores: 9999, Currently using: 20 | MultiCast: 9999, Currently using: 20 | Clients: 9999, Currently using: 0 | Licence Type: DEVELOPMENT, Currently using: Development Version (DEVELOPMENT) | Signals Users: 9999, Currently using: 1 | REST User Lic: null | Guided NLQ Lic: null | | | The i4 Licence classes have been initialised. | ======================================================================== ============================== MI Startup ============================== | | Webapp context: C:\Yellowfin\appserver\webapps\ROOT\ | | Yellowfin 9.10.0.1 starting (build 20231204) | | Loading Analytical Functions... 75 functions loaded | | Loading Third Party Data Sources... 0 functions loaded | | Loading Custom Formatters... 33 formatters loaded | | Loading Custom Menu Items... [] menu items loaded | | Loading Custom Functions... 57 functions loaded | | Loading Converters... 11 converters loaded | | Initialising Geometry Cache... OK | Size: 4000 | | Initialising Report Definition Cache... OK | Size: 1000 | | | Initialising Dashboard Definition Cache... OK | Size: 1000 | | | Initialising Execution Queue... OK | Execution Queue Size: 100 | Queue Item wait time: 5000 ms | Queue Item timeout: 14400000 ms | | Initialising ETL... OK | Max Threads in an ETL Preview Job: 2 | Max Threads for all Background ETL Jobs: 20 | Max Concurrent Background ETL Tasks: 1 | | Initialising ReportDataCache... OK | Cache size: 20 | Max age: 86400000 ms | | Initialising TranslationCache... OK | Cache size: 50000 | Max age: 86400000 ms | | Initialising CachedFilterCache... OK | Cache Method: CACHE_BY_USER | Cached Filter Cache Size: 100 | Cached Filter Query Cache Size: 100 | Cached Filter Meta Cache Size: 1000 | Cached Filter Cache Period: 86400000 ms | Cached Filter Query Cache Period: 86400000 ms | Cached Filter Meta Cache Period: 86400000 ms | | Jasper Compile Class Path Set. | | Loading JDBC drivers... | 8 Drivers Found: | com.hof.mi.database.jdbc.ColumnarDriver | com.microsoft.sqlserver.jdbc.SQLServerDriver | net.sourceforge.jtds.jdbc.Driver | org.apache.derby.jdbc.AutoloadedDriver | org.apache.derby.jdbc.EmbeddedDriver | org.hsqldb.jdbc.JDBCDriver | org.hsqldb.jdbcDriver | org.postgresql.Driver | | Initialising PersonCache... OK | Cache size: 1000 | Max age: 43200000 ms | | Initialising GroupCache... OK | Cache size: 1000 | Max age: 43200000 ms | | Initialising TextEntityCache... OK | Cache size: 10000 | Max age: 43200000 ms | | Initialising MultiChartThumbnailCache... OK | Cache size: 100 | Max age: 604800000 ms | | Initialising ReportThumbnailCache... OK | Cache size: 1000 | Max age: 604800000 ms | | Initialising REST User Cache... OK | Cache size: 100 | Max age: 43200000 ms | | Initialising Guided NLQ Cache... OK | View Entries: | Cache Size: 5000 | Max age: 43200000 | | Field Entries: | Cache Size: 50000 | Max age: 43200000 | | Initialising WebServicesSessionManager | Interval: 120 seconds | Session timeout: 1200 seconds | First run: 2024-06-24 09:07 (GMT) | 2024-06-24 14:37 (IST) | | | Initialising TaskScheduler | | Redirect JS/CSS compress enabled | | PdfExportInitialMemory has been set to 64mb | | Query Webservice Disabled | | OLAP Caching Enabled (External Caching Enabled) | | Initialising Birt Engine | Birt resource path: C:\Yellowfin\appserver\BirtResources | Birt Engine initialisation failed. Birt functionality disabled. | Loading Source Platforms... 4 source platforms loaded | | Initialising EventCache... done | | Priming Definition Caches... Caches primed in 13408ms (Reports: 1 Dashboards: 0) | | | Clearing Content Locks... Done YF:2024-06-24 14:36:43.392: WARN (FontCache) - [1] [Background] [STARTUP] Unable to load font LucidaBrightDemiBold.ttf. C:\Program Files\Java\jre1.8.0_333\lib\fonts\LucidaBrightDemiBold.ttf cannot be embedded due to licensing restrictions. YF:2024-06-24 14:36:43.395: WARN (FontCache) - [1] [Background] [STARTUP] Unable to load font LucidaBrightDemiItalic.ttf. C:\Program Files\Java\jre1.8.0_333\lib\fonts\LucidaBrightDemiItalic.ttf cannot be embedded due to licensing restrictions. YF:2024-06-24 14:36:43.401: WARN (FontCache) - [1] [Background] [STARTUP] Unable to load font LucidaBrightItalic.ttf. C:\Program Files\Java\jre1.8.0_333\lib\fonts\LucidaBrightItalic.ttf cannot be embedded due to licensing restrictions. YF:2024-06-24 14:36:43.408: WARN (FontCache) - [1] [Background] [STARTUP] Unable to load font LucidaBrightRegular.ttf. C:\Program Files\Java\jre1.8.0_333\lib\fonts\LucidaBrightRegular.ttf cannot be embedded due to licensing restrictions. YF:2024-06-24 14:36:43.413: WARN (FontCache) - [1] [Background] [STARTUP] Unable to load font LucidaSansDemiBold.ttf. C:\Program Files\Java\jre1.8.0_333\lib\fonts\LucidaSansDemiBold.ttf cannot be embedded due to licensing restrictions. YF:2024-06-24 14:36:43.423: WARN (FontCache) - [1] [Background] [STARTUP] Unable to load font LucidaSansRegular.ttf. C:\Program Files\Java\jre1.8.0_333\lib\fonts\LucidaSansRegular.ttf cannot be embedded due to licensing restrictions. | | The MI Utility classes have been initialised. | ======================================================================== ===================== i4 SystemTaskManager Startup ===================== | | Debug Mode: off | Interval: 5 | SystemTaskManager started | ======================================================================== 24-Jun-2024 14:36:49.754 INFO [main] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of deployment descriptor [C:\Yellowfin\appserver\conf\Catalina\localhost\ROOT.xml] has finished in [496,364] ms 24-Jun-2024 14:36:49.772 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8085"] 24-Jun-2024 14:36:49.829 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [496500] milliseconds