4
respostas

Erro ao iniciar o start-pentaho.bat

Já tentei diversas vezes e sempre me deparo com os mesmos erros:

08:28:00,709 ERROR [SchemaUpdate] could not get database metadata java.sql.SQLTransientConnectionException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception...

...Caused by: org.hsqldb.HsqlException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ClientConnection.execute(Unknown Source) at org.hsqldb.ClientConnection.(Unknown Source)

08:28:00,713 ERROR [SchemaUpdate] could not complete schema update java.sql.SQLTransientConnectionException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception...

...Caused by: org.hsqldb.HsqlException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ClientConnection.execute(Unknown Source) at org.hsqldb.ClientConnection.(Unknown Source)

08:28:21,784 ERROR [EmbeddedQuartzSystemListener] EmbeddedQuartzSystemListener.ERROR_0007_SQLERROR java.sql.SQLTransientConnectionException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception

08:28:21,785 ERROR [Logger] Error: Pentaho 08:28:21,788 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - [pt_71] Error while trying to execute startup sequence for org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener org.pentaho.platform.api.engine.PentahoSystemException: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - [pt_71] Error while trying to execute startup sequence for org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener ... 61 more

4 respostas

Oii Carlos, tudo bom? Espero que sim.

Você consegue me enviar o log do console console do Pentaho Server?

Verifica se não tem algum software que está utilizando a mesma porta do Tomcat e também se as variáveis de ambiente estão apontando certinho para o JRE.

Fico no seu aguardo :)

Então, no prompt de comando da o seguinte resultado:

C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server>start-pentaho.bat DEBUG: Using PENTAHO_JAVA_HOME DEBUG: PENTAHOJAVA_HOME=C:\Program Files\Java\jre1.8.0_271 DEBUG: PENTAHOJAVA=C:\Program Files\Java\jre1.8.0_271\bin\java.exe Using CATALINA_BASE: "C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat" Using CATALINA_HOME: "C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat" Using CATALINA_TMPDIR: "C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\temp" Using JRE_HOME: "C:\Program Files\Java\jre1.8.0_271" Using CLASSPATH: "C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\bin\bootstrap.jar;C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\bin\tomcat-juli.jar"

Já no Tomcat aparecem diversos erros e o Log é tão grande que não consigo colocar tudo aqui, mas são em resumo os erros apresentados na primeira pergunta:

07:37:04,101 ERROR [SchemaUpdate] could not get database metadata java.sql.SQLTransientConnectionException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception

07:37:04,101 ERROR [SchemaUpdate] could not complete schema update java.sql.SQLTransientConnectionException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception

07:37:04,923 ERROR [SchemaUpdate] could not get database metadata java.sql.SQLTransientConnectionException: connection exception: connection failure: org.hsqldb.HsqlException: connection exception

07:37:22,055 ERROR [Logger] Error end: 07:37:22,055 INFO [PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process. [pt_68] Pentaho BI Platform server failed to properly initialize. The system will not be available for requests. 09-Jan-2021 07:37:22.667 INFORMAÇÕES [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\webapps\pentaho] has finished in [69,759] ms 09-Jan-2021 07:37:22.667 INFORMAÇÕES [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\webapps\pentaho-style] 09-Jan-2021 07:37:23.373 INFORMAÇÕES [localhost-startStop-1] 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. 09-Jan-2021 07:37:23.381 INFORMAÇÕES [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\webapps\pentaho-style] has finished in [714] ms 09-Jan-2021 07:37:23.381 INFORMAÇÕES [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\webapps\ROOT] 09-Jan-2021 07:37:23.863 INFORMAÇÕES [localhost-startStop-1] 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. 09-Jan-2021 07:37:23.873 INFORMAÇÕES [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\webapps\ROOT] has finished in [492] ms 09-Jan-2021 07:37:23.873 INFORMAÇÕES [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\webapps\sw-style] 09-Jan-2021 07:37:24.492 INFORMAÇÕES [localhost-startStop-1] 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. 09-Jan-2021 07:37:24.502 INFORMAÇÕES [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Users\carlo\OneDrive\Documentos\Pentaho (outros)\Server\pentaho-server-ce-8.2.0.0-342\pentaho-server\tomcat\webapps\sw-style] has finished in [619] ms 09-Jan-2021 07:37:24.502 INFORMAÇÕES [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8088"] 09-Jan-2021 07:37:24.512 INFORMAÇÕES [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"] 09-Jan-2021 07:37:24.512 INFORMAÇÕES [main] org.apache.catalina.startup.Catalina.start Server startup in 71643 ms

Oii Carlos, desculpa a demora.

O Java e as variáveis de ambiente estão configuradas corretamente? Tem algum serviço rodando no Windows que usa a mesma porta que o Tomcat?