El punto 1) y 2) lo pude realizar sin problemas. Aunque en el punto (2.2.8. Migrar los datos existentes) no me queda claro si tengo que pasar todas las bases o solo siu-wichi y utilizar el “import-export.sh”
Si paso las bases y algo se rompe y no le gusta.
Si paso solo siu-wichi y utilizo el script me deja continuar.
En el paso 4) especificamente en 4.3. Actualizar solución SIU-Wichi.
Al subir el zip me tira el siguiente error:
org.pentaho.platform.plugin.services.importer.PlatformImportException: Could not import: General Error : ExceptionOnCreatingFile: creating file with name “cargar_dimesiones.kjb”
at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:157)
at org.pentaho.platform.plugin.services.importer.SolutionImportHandler.importFile(SolutionImportHandler.java:283)
at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:124)
at org.pentaho.platform.web.http.api.resources.RepositoryImportResource.doPostImport(RepositoryImportResource.java:238)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at org.pentaho.platform.web.servlet.JAXRSServlet$InternalWebComponent.service(JAXRSServlet.java:288)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:139)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:144)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:238)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:90)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.pentaho.platform.web.http.filters.PentahoMDCFilter.doFilter(PentahoMDCFilter.java:72)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:192)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:149)
at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternalSuper(PentahoBasicProcessingFilter.java:123)
at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterInternal(PentahoBasicProcessingFilter.java:117)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:283)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at com.hitachivantara.security.web.impl.service.cors.servlet.CorsProtocolFilter.doFilter(CorsProtocolFilter.java:80)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at com.hitachivantara.security.web.impl.service.csrf.servlet.CsrfGateFilter.doFilter(CsrfGateFilter.java:202)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:750)
Caused by: org.pentaho.platform.api.repository2.unified.UnifiedRepositoryCreateFileException: ExceptionOnCreatingFile: creating file with name “cargar_dimesiones.kjb”
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:561)
at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.createFile(ExceptionLoggingDecorator.java:104)
at org.pentaho.platform.plugin.services.importer.RepositoryFileImportFileHandler.createFile(RepositoryFileImportFileHandler.java:415)
at org.pentaho.platform.plugin.services.importer.PDIImportFileHandler.createFile(PDIImportFileHandler.java:46)
at org.pentaho.platform.plugin.services.importer.RepositoryFileImportFileHandler.copyFileToRepository(RepositoryFileImportFileHandler.java:247)
at org.pentaho.platform.plugin.services.importer.RepositoryFileImportFileHandler.importFile(RepositoryFileImportFileHandler.java:154)
at org.pentaho.platform.plugin.services.importer.PentahoPlatformImporter.importFile(PentahoPlatformImporter.java:124)
… 102 more
Caused by: java.lang.NullPointerException
at java.util.Calendar.setTime(Calendar.java:1770)
at org.pentaho.platform.repository2.unified.jcr.transform.NodeRepositoryFileDataTransformer.internalCreateOrUpdate(NodeRepositoryFileDataTransformer.java:133)
at org.pentaho.platform.repository2.unified.jcr.transform.NodeRepositoryFileDataTransformer.createOrUpdateContentNode(NodeRepositoryFileDataTransformer.java:81)
at org.pentaho.platform.repository2.unified.jcr.transform.NodeRepositoryFileDataTransformer.createContentNode(NodeRepositoryFileDataTransformer.java:86)
at org.pentaho.platform.repository2.unified.jcr.transform.NodeRepositoryFileDataTransformer.createContentNode(NodeRepositoryFileDataTransformer.java:45)
at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileUtils.createFileNode(JcrRepositoryFileUtils.java:616)
at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao$1.doInJcr(JcrRepositoryFileDao.java:215)
at org.pentaho.platform.repository2.unified.jcr.sejcr.PentahoJcrTemplate.execute(PentahoJcrTemplate.java:74)
at org.springframework.extensions.jcr.JcrTemplate.execute(JcrTemplate.java:115)
at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao.internalCreateFile(JcrRepositoryFileDao.java:209)
at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao.createFile(JcrRepositoryFileDao.java:320)
at org.pentaho.platform.repository2.unified.DefaultUnifiedRepository.internalCreateFile(DefaultUnifiedRepository.java:509)
at org.pentaho.platform.repository2.unified.DefaultUnifiedRepository.createFile(DefaultUnifiedRepository.java:188)
at org.pentaho.platform.repository2.unified.DefaultUnifiedRepository.createFile(DefaultUnifiedRepository.java:167)
at sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
at com.sun.proxy.$Proxy136.createFile(Unknown Source)
at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$2.call(ExceptionLoggingDecorator.java:106)
at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$2.call(ExceptionLoggingDecorator.java:104)
at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:537)
… 108 more
Buenos dias! para la migración (punto 2.2.8) es indistinto cualquiera de las dos opciones.
Si migras todas las bases es importante que los usuarios Owner de las bases esten creados, porque sino no te va a funcionar.
Recomiendo, me parece mas sencillo, migrar solo siu_wichi y utilizar el script de migracion import-export.sh.
En el paso 4 fijate que estas subiendo el zip general, lo que tenes que hacer es deszipear el Paquete y dentro vas a encontrar el archivo Siu-Wichi.zip, ese es el que tenes que subir.
Saludos,
Sabrina.
Sospecho que no levanto con las bases en postgres. Para verificarlo anda a:
Archivo → Manage Data Sources..
Parate en la conexion DBWichi de typo JDBC y desde la ruedita elegi Edit
Ingresa al contenedor de pentaho mediante docker exec -it pentaho bash, luego ejecuta nano server/pentaho-server/tomcat/webapps/pentaho/META-INF/context.xml
Dentro tendrias que tener esta configuracion de DBWichi
Claro, el pentaho no inicio con las bases en Postgresql. Podes ver si hubo algún error durante el arranque mediante esta sentencia docker logs -f pentaho . Podes bajarlo a un txt para que sea mas facial de ver, al inicio es cuando prueba las conexiones a postgres y a las bases de datos
+ '[' postgres ']'
+ '[' '!' 5432 ']'
+ '[' '!' postgres ']'
+ '[' '!' postgres ']'
+ '[' '!' postgres ']'
+ export PGPASSWORD=postgres
+ PGPASSWORD=postgres
+ echo 'Checking PostgreSQL connection ...'
+ nc -zv postgres 5432
Checking PostgreSQL connection ...
nc: connect to postgres (172.18.0.2) port 5432 (tcp) failed: Connection refused
+ '[' 1 -ne 0 ']'
+ echo 'PostgreSQL connection failed.'
+ exit 0
PostgreSQL connection failed.
+ '[' '!' http://localhost:9999/hanyaj.php ']'
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho/mantle/browser/js/browser.js
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho/mantle/browser/index.jsp
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho/mantle/home/js/home.js
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/pentaho-solutions/system/cda/static/hanyaj.html
DEBUG: Using PENTAHO_JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=/usr/local/openjdk-8
DEBUG: _PENTAHO_JAVA=/usr/local/openjdk-8/bin/java
28-Apr-2025 10:08:32.521 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.65
28-Apr-2025 10:08:32.522 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jul 14 2022 12:28:53 UTC
28-Apr-2025 10:08:32.522 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.65.0
28-Apr-2025 10:08:32.522 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
28-Apr-2025 10:08:32.522 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 5.4.72-microsoft-standard-WSL2
28-Apr-2025 10:08:32.522 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
28-Apr-2025 10:08:32.523 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/local/openjdk-8
28-Apr-2025 10:08:32.523 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_342-b07
28-Apr-2025 10:08:32.523 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
28-Apr-2025 10:08:32.523 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 10:08:32.523 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 10:08:32.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/pentaho/server/pentaho-server/tomcat/conf/logging.properties
28-Apr-2025 10:08:32.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
28-Apr-2025 10:08:32.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
28-Apr-2025 10:08:32.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
28-Apr-2025 10:08:32.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
28-Apr-2025 10:08:32.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms2048m
28-Apr-2025 10:08:32.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx6144m
28-Apr-2025 10:08:32.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.client.gcInterval=3600000
28-Apr-2025 10:08:32.527 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.server.gcInterval=3600000
28-Apr-2025 10:08:32.527 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=utf8
28-Apr-2025 10:08:32.527 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.locale.providers=COMPAT,SPI
28-Apr-2025 10:08:32.528 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -DDI_HOME=/opt/pentaho/server/pentaho-server/pentaho-solutions/system/kettle
28-Apr-2025 10:08:32.528 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
28-Apr-2025 10:08:32.528 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 10:08:32.528 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 10:08:32.528 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/pentaho/server/pentaho-server/tomcat/temp
28-Apr-2025 10:08:32.531 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
28-Apr-2025 10:08:32.951 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
28-Apr-2025 10:08:32.976 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [720] milliseconds
28-Apr-2025 10:08:33.005 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
28-Apr-2025 10:08:33.005 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.65]
28-Apr-2025 10:08:33.021 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/sw-style]
28-Apr-2025 10:08:33.653 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.
28-Apr-2025 10:08:33.729 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/sw-style] has finished in [709] ms
28-Apr-2025 10:08:33.730 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/ROOT]
28-Apr-2025 10:08:34.061 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.
28-Apr-2025 10:08:34.063 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/ROOT] has finished in [333] ms
28-Apr-2025 10:08:34.064 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho]
28-Apr-2025 10:08:34.069 WARNING [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Context] failed to set property [docbase] to [webapps/pentaho/]
28-Apr-2025 10:08:55.948 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.
[Server@7e92d189]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@7e92d189]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@7e92d189]: Initiating startup sequence...
[Server@7e92d189]: Server socket opened successfully in 24 ms.
28-Apr-2025 10:08:58.265 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent open start - state not modified
28-Apr-2025 10:08:58.291 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent Checkpoint start
28-Apr-2025 10:08:58.292 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose start
28-Apr-2025 10:08:59.232 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose end
28-Apr-2025 10:08:59.233 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent Checkpoint end - txts: 49
[Server@7e92d189]: Database [index=0, id=0, db=file:../../data/hsqldb/quartz, alias=quartz] opened sucessfully in 1607 ms.
28-Apr-2025 10:08:59.457 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent open start - state not modified
28-Apr-2025 10:08:59.460 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent Checkpoint start
28-Apr-2025 10:08:59.460 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose start
28-Apr-2025 10:09:00.206 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose end
28-Apr-2025 10:09:00.206 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent Checkpoint end - txts: 27
[Server@7e92d189]: Database [index=1, id=1, db=file:../../data/hsqldb/hibernate, alias=hibernate] opened sucessfully in 909 ms.
28-Apr-2025 10:09:00.336 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent open start - state not modified
28-Apr-2025 10:09:00.550 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache open start
28-Apr-2025 10:09:01.026 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache open end
28-Apr-2025 10:09:01.591 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose start
28-Apr-2025 10:09:02.156 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache commit start
28-Apr-2025 10:09:02.702 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache commit end
28-Apr-2025 10:09:03.106 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose end
28-Apr-2025 10:09:03.106 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent Checkpoint start
28-Apr-2025 10:09:03.106 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose start
28-Apr-2025 10:09:03.572 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache commit start
28-Apr-2025 10:09:03.686 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache commit end
28-Apr-2025 10:09:04.178 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose end
28-Apr-2025 10:09:04.178 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent Checkpoint end - txts: 107
[Server@7e92d189]: Database [index=2, id=2, db=file:../../data/hsqldb/sampledata, alias=sampledata] opened sucessfully in 3967 ms.
[Server@7e92d189]: Startup sequence completed in 6508 ms.
[Server@7e92d189]: 2025-04-28 10:09:04.278 HSQLDB server 2.3.2 is online on port 9001
[Server@7e92d189]: To close normally, connect and execute SHUTDOWN SQL
[Server@7e92d189]: From command line, use [Ctrl]+[C] to abort abruptly
10:09:08,184 INFO [PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
10:09:09,120 INFO [OSGIBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
10:09:09,258 INFO [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 1 at /opt/pentaho/server/pentaho-server/pentaho- ***
*** solutions/system/karaf/caches/default/data-1 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
*******************************************************************************
28-Apr-2025 10:09:09.874 INFO [main] org.apache.karaf.main.Main.launch Installing and starting initial bundles
28-Apr-2025 10:09:10.445 INFO [main] org.apache.karaf.main.Main.launch All initial bundles installed and set to start
28-Apr-2025 10:09:10.557 INFO [Karaf Lock Monitor Thread] org.apache.karaf.main.Main$KarafLockCallback.lockAcquired Lock acquired. Setting startlevel to 100
28-Apr-2025 10:09:11.151 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.config} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.config.cfg
28-Apr-2025 10:09:11.171 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {jmx.acl.java.lang.Memory} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/jmx.acl.java.lang.Memory.cfg
28-Apr-2025 10:09:11.177 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.felix.fileinstall~deploy} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.felix.fileinstall-deploy.cfg
28-Apr-2025 10:09:11.184 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {profile} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/profile.cfg
28-Apr-2025 10:09:11.189 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {mondrian} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/mondrian.cfg
28-Apr-2025 10:09:11.192 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.system} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.system.cfg
28-Apr-2025 10:09:11.237 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.felix.eventadmin.impl.EventAdmin} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.felix.eventadmin.impl.EventAdmin.cfg
28-Apr-2025 10:09:11.241 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.pentaho.pdi.engine.spark} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.pentaho.pdi.engine.spark.cfg
28-Apr-2025 10:09:11.247 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {jmx.acl.org.apache.karaf.bundle} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/jmx.acl.org.apache.karaf.bundle.cfg
28-Apr-2025 10:09:11.251 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.features} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.features.cfg
28-Apr-2025 10:09:11.255 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.jaas} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.jaas.cfg
28-Apr-2025 10:09:11.264 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {jmx.acl.org.apache.karaf.config} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/jmx.acl.org.apache.karaf.config.cfg
28-Apr-2025 10:09:11.268 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.feature} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.feature.cfg
28-Apr-2025 10:09:11.271 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.pentaho.caching~default} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.pentaho.caching-default.cfg
28-Apr-2025 10:09:11.280 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.log} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.log.cfg
28-Apr-2025 10:09:11.284 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {jmx.acl.osgi.compendium.cm} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/jmx.acl.osgi.compendium.cm.cfg
28-Apr-2025 10:09:11.287 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.kar} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.kar.cfg
28-Apr-2025 10:09:11.289 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {pentaho.shim} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/pentaho.shim.cfg
28-Apr-2025 10:09:11.292 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {jmx.acl} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/jmx.acl.cfg
28-Apr-2025 10:09:11.295 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.ops4j.pax.web} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.ops4j.pax.web.cfg
28-Apr-2025 10:09:11.300 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.shell} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.shell.cfg
28-Apr-2025 10:09:11.318 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.ops4j.pax.url.mvn} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.ops4j.pax.url.mvn.cfg
28-Apr-2025 10:09:11.320 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.jaas} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.jaas.cfg
28-Apr-2025 10:09:11.323 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.ops4j.pax.logging} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.ops4j.pax.logging.cfg
28-Apr-2025 10:09:11.339 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.management} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.management.cfg
28-Apr-2025 10:09:11.343 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {jmx.acl.org.apache.karaf.security.jmx} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/jmx.acl.org.apache.karaf.security.jmx.cfg
28-Apr-2025 10:09:11.348 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.pentaho.features} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.pentaho.features.cfg
28-Apr-2025 10:09:11.354 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.ops4j.pax.transx.tm.geronimo} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.ops4j.pax.transx.tm.geronimo.cfg
28-Apr-2025 10:09:11.357 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.shell} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.shell.cfg
28-Apr-2025 10:09:11.362 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.kar} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.kar.cfg
28-Apr-2025 10:09:11.366 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.bundle} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.bundle.cfg
28-Apr-2025 10:09:11.370 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.features.repos} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.features.repos.cfg
28-Apr-2025 10:09:11.372 INFO [FelixStartLevel] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {org.apache.karaf.command.acl.scope_bundle} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/org.apache.karaf.command.acl.scope_bundle.cfg
[INFO] Started bridged http services
28-Apr-2025 10:09:16.308 INFO [features-3-thread-1] org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1.onSuccess New Caching Service registered
[INFO] Apachde Felix Http Whiteboard Service started
28-Apr-2025 10:09:20.155 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-management (116) [org.apache.cxf.management.InstrumentationManager]
28-Apr-2025 10:09:20.158 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-rs-service-description (121) [org.apache.cxf.jaxrs.model.wadl.WadlGenerator]
28-Apr-2025 10:09:20.158 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (123) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
28-Apr-2025 10:09:20.657 INFO [features-3-thread-1] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /i18n
28-Apr-2025 10:09:21.080 INFO [fileinstall-/opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {pentaho.big.data.impl.cluster} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/pentaho.big.data.impl.cluster.cfg
28-Apr-2025 10:09:23.806 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.unregister Removing the extensions for bundle 116
28-Apr-2025 10:09:23.807 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.unregister Removing the extensions for bundle 121
28-Apr-2025 10:09:23.808 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.unregister Removing the extensions for bundle 123
28-Apr-2025 10:09:30.831 INFO [fileinstall-/opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {pentaho.marketplace.ba} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/pentaho.marketplace.ba.cfg
28-Apr-2025 10:09:30.833 INFO [fileinstall-/opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc] org.apache.felix.fileinstall.internal.Util$DefaultLogger.log Creating configuration {pentaho.geo.roles} from /opt/pentaho/server/pentaho-server/pentaho-solutions/system/karaf/etc/pentaho.geo.roles.cfg
28-Apr-2025 10:09:32.105 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-management (116) [org.apache.cxf.management.InstrumentationManager]
28-Apr-2025 10:09:32.106 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-rs-service-description (121) [org.apache.cxf.jaxrs.model.wadl.WadlGenerator]
28-Apr-2025 10:09:32.106 INFO [features-3-thread-1] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (123) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
28-Apr-2025 10:09:32.374 INFO [Blueprint Extender: 3] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /i18n
28-Apr-2025 10:09:32.452 INFO [features-3-thread-1] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /marketplace
28-Apr-2025 10:09:32.713 INFO [features-3-thread-1] org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1.onSuccess New Caching Service registered
10:09:32,786 INFO [DriverManager] Installing driver kars.
10:09:32,790 INFO [DriverManager] 0 drivers will be installed.
10:09:32,791 INFO [DriverManager] Finished installing drivers kars.
28-Apr-2025 10:09:33.007 INFO [Blueprint Extender: 3] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /hadoop-cluster
28-Apr-2025 10:09:33.579 INFO [Blueprint Extender: 2] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /lineage
Using tag repository path: file:/opt/pentaho/server/pentaho-server/pentaho-solutions/system/saiku/saiku-repository
10:09:38,168 INFO [PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
10:09:47,230 INFO [PeriodicStatusLogger] The system has finished initializing.
Pentaho BI Platform server is ready. (pentaho-platform-core 9.4.0.0-343) Fully Qualified Server Url = http://localhost:8080/pentaho/, Solution Path = /opt/pentaho/server/pentaho-server/pentaho-solutions
28-Apr-2025 10:09:50.481 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho] has finished in [76,418] ms
28-Apr-2025 10:09:50.482 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho-style]
28-Apr-2025 10:09:50.772 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.
28-Apr-2025 10:09:50.774 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho-style] has finished in [292] ms
28-Apr-2025 10:09:50.780 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
28-Apr-2025 10:09:50.822 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [77849] milliseconds
10:09:53,267 INFO [di] 2025/04/28 10:09:53 - RepositoriesMeta - Reading repositories XML file: FromInputStream
2025/04/28 10:09:53 - RepositoriesMeta - Reading repositories XML file: FromInputStream
Perdón el log esta mal, porque estuve haciendo pruebas y realice un build de pentaho. El problema es que se pierde toda la estructura al hacer un build. Ahora vuelvo a hacer los pasos y te paso los logs correctos.
Ese error era porque volví a realizar el build, pero fijate el archivo salida.txt o te paso un reinicio del server para que veas que no tira ese rror
+ '[' '!' http://localhost:9999/hanyaj.php ']'
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho/mantle/browser/js/browser.js
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho/mantle/browser/index.jsp
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho/mantle/home/js/home.js
+ sed -i 's|HANYAJ_PAGE|http://localhost:9999/hanyaj.php|g' /opt/pentaho/server/pentaho-server/pentaho-solutions/system/cda/static/hanyaj.html
DEBUG: Using PENTAHO_JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=/usr/local/openjdk-8
DEBUG: _PENTAHO_JAVA=/usr/local/openjdk-8/bin/java
28-Apr-2025 11:58:09.362 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.65
28-Apr-2025 11:58:09.363 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jul 14 2022 12:28:53 UTC
28-Apr-2025 11:58:09.363 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.65.0
28-Apr-2025 11:58:09.363 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
28-Apr-2025 11:58:09.363 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 5.4.72-microsoft-standard-WSL2
28-Apr-2025 11:58:09.363 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
28-Apr-2025 11:58:09.363 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/local/openjdk-8
28-Apr-2025 11:58:09.363 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_342-b07
28-Apr-2025 11:58:09.364 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
28-Apr-2025 11:58:09.364 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 11:58:09.364 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 11:58:09.379 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/pentaho/server/pentaho-server/tomcat/conf/logging.properties
28-Apr-2025 11:58:09.379 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
28-Apr-2025 11:58:09.379 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
28-Apr-2025 11:58:09.379 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
28-Apr-2025 11:58:09.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
28-Apr-2025 11:58:09.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms2048m
28-Apr-2025 11:58:09.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx6144m
28-Apr-2025 11:58:09.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.client.gcInterval=3600000
28-Apr-2025 11:58:09.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.server.gcInterval=3600000
28-Apr-2025 11:58:09.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=utf8
28-Apr-2025 11:58:09.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.locale.providers=COMPAT,SPI
28-Apr-2025 11:58:09.381 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -DDI_HOME=/opt/pentaho/server/pentaho-server/pentaho-solutions/system/kettle
28-Apr-2025 11:58:09.381 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
28-Apr-2025 11:58:09.381 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 11:58:09.381 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/pentaho/server/pentaho-server/tomcat
28-Apr-2025 11:58:09.382 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/pentaho/server/pentaho-server/tomcat/temp
28-Apr-2025 11:58:09.385 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
28-Apr-2025 11:58:10.010 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
28-Apr-2025 11:58:10.034 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [1186] milliseconds
28-Apr-2025 11:58:10.102 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
28-Apr-2025 11:58:10.102 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.65]
28-Apr-2025 11:58:10.117 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/sw-style]
28-Apr-2025 11:58:11.475 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.
28-Apr-2025 11:58:11.567 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/sw-style] has finished in [1,450] ms
28-Apr-2025 11:58:11.568 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/ROOT]
28-Apr-2025 11:58:11.927 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.
28-Apr-2025 11:58:11.929 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/ROOT] has finished in [362] ms
28-Apr-2025 11:58:11.930 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho]
28-Apr-2025 11:58:11.934 WARNING [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match [Context] failed to set property [docbase] to [webapps/pentaho/]
28-Apr-2025 11:58:51.365 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.
[Server@7e92d189]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@7e92d189]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@7e92d189]: Initiating startup sequence...
[Server@7e92d189]: Server socket opened successfully in 1 ms.
28-Apr-2025 11:58:52.804 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose start
28-Apr-2025 11:58:52.972 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose end
[Server@7e92d189]: Database [index=0, id=0, db=file:../../data/hsqldb/quartz, alias=quartz] opened sucessfully in 528 ms.
28-Apr-2025 11:58:53.058 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose start
28-Apr-2025 11:58:53.356 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose end
[Server@7e92d189]: Database [index=1, id=1, db=file:../../data/hsqldb/hibernate, alias=hibernate] opened sucessfully in 381 ms.
28-Apr-2025 11:58:53.414 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache open start
28-Apr-2025 11:58:53.422 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache open end
28-Apr-2025 11:58:53.687 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose start
28-Apr-2025 11:58:54.015 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache commit start
28-Apr-2025 11:58:54.131 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent dataFileCache commit end
28-Apr-2025 11:58:54.615 INFO [HSQLDB Server @7e92d189] org.hsqldb.persist.Logger.logInfoEvent checkpointClose end
[Server@7e92d189]: Database [index=2, id=2, db=file:../../data/hsqldb/sampledata, alias=sampledata] opened sucessfully in 1259 ms.
[Server@7e92d189]: Startup sequence completed in 2171 ms.
[Server@7e92d189]: 2025-04-28 11:58:54.616 HSQLDB server 2.3.2 is online on port 9001
[Server@7e92d189]: To close normally, connect and execute SHUTDOWN SQL
[Server@7e92d189]: From command line, use [Ctrl]+[C] to abort abruptly
11:58:57,603 INFO [PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
11:58:58,060 INFO [OSGIBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
11:58:58,224 INFO [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 1 at /opt/pentaho/server/pentaho-server/pentaho- ***
*** solutions/system/karaf/caches/default/data-1 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
*******************************************************************************
28-Apr-2025 11:59:01.041 INFO [Karaf Lock Monitor Thread] org.apache.karaf.main.Main$KarafLockCallback.lockAcquired Lock acquired. Setting startlevel to 100
[INFO] Started bridged http services
[INFO] Apachde Felix Http Whiteboard Service started
28-Apr-2025 11:59:06.006 INFO [FelixStartLevel] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-management (116) [org.apache.cxf.management.InstrumentationManager]
28-Apr-2025 11:59:06.007 INFO [FelixStartLevel] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-rs-service-description (121) [org.apache.cxf.jaxrs.model.wadl.WadlGenerator]
28-Apr-2025 11:59:06.008 INFO [FelixStartLevel] org.apache.cxf.bus.osgi.CXFExtensionBundleListener.addExtensions Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (123) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
28-Apr-2025 11:59:06.403 INFO [FelixStartLevel] org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1.onSuccess New Caching Service registered
28-Apr-2025 11:59:08.028 INFO [FelixStartLevel] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /i18n
28-Apr-2025 11:59:08.893 INFO [FelixStartLevel] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /hadoop-cluster
28-Apr-2025 11:59:09.317 INFO [FelixStartLevel] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /marketplace
11:59:11,640 INFO [DriverManager] Installing driver kars.
11:59:11,644 INFO [DriverManager] 0 drivers will be installed.
11:59:11,645 INFO [DriverManager] Finished installing drivers kars.
28-Apr-2025 11:59:12.175 INFO [Blueprint Extender: 2] org.apache.cxf.endpoint.ServerImpl.initDestination Setting the server's publish address to be /lineage
Using tag repository path: file:/opt/pentaho/server/pentaho-server/pentaho-solutions/system/saiku/saiku-repository
11:59:24,964 INFO [PeriodicStatusLogger] The system has finished initializing.
Pentaho BI Platform server is ready. (pentaho-platform-core 9.4.0.0-343) Fully Qualified Server Url = http://localhost:8080/pentaho/, Solution Path = /opt/pentaho/server/pentaho-server/pentaho-solutions
28-Apr-2025 11:59:25.924 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho] has finished in [73,994] ms
28-Apr-2025 11:59:25.924 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho-style]
28-Apr-2025 11:59:26.130 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.
28-Apr-2025 11:59:26.132 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/pentaho/server/pentaho-server/tomcat/webapps/pentaho-style] has finished in [208] ms
28-Apr-2025 11:59:26.138 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
28-Apr-2025 11:59:26.180 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [76146] milliseconds
Tenes razón ese error no lo había visto, pero porque puede ser que no se conecte. Las bases de datos están y las claves deje las que vienen por defecto.
En el docker-compose.xml, en el contenedor de postgres, le dejaste la pass por defecto o la cambiaste? esa tiene que coincidir con la que esta en pentaho.env
Si no le encontras la vuelta, escribi un mail a wichi@siu.edu.ar y coordinamos un meet.
Hola Sabrina, encontré el problema de conexión. Ya tenia un servicio de postgres en la PC y le estaba asignando otro puerto. Veo si puedo continuar y cualquier cosa les aviso.
Hola Sabrina, era la conexión con postgres. Ya pude realizar todos los pasos. Y quedo funcionando de manera correcta. Voy a ver los scripts que tengo en el CRON para ver si los puedo incorporar, ya que leen automáticamente guaraní, pilaga y diaguita.
