No Start the Pentaho Job Scheduler Community Version 8.0.0-28

Navigation
0

I'm trying to automate the execution of a transformation, but it does not run.

Can it be a limitation of the Pentaho Data Integration Community?

The source of the transformation, I bring it from a remote computer:

I enclose an image so you can see how I'm doing it.

Could it be that the problem is that the file brings it from a remote computer and that is why the Schedule fails?

Try also to arm a file.bat so that it runs with a windows task 

    cd "C:\PCE\data-integration" >  
   C:\PCE\Scripts\logOOF.txt

pan.bat          /file:C:\PCE\Transformations\Resumen.ktr

  
    

C: \ PCE \ Scripts \ logOOF.txt              exit

  

and it gives me the following error: 

DEBUG: Using JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jre1.8.0_161
DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\jre1.8.0_161\bin\java.exe

C:\PCE\data-integration>"C:\Program Files\Java\jre1.8.0_161\bin\java.exe"  "-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m" "-Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2" "-Djava.library.path=libswt\win64" "-DKETTLE_HOME=" "-DKETTLE_REPOSITORY=" "-DKETTLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\pentaho-application-launcher-8.0.0.0-28.jar -lib ..\libswt\win64  -main org.pentaho.di.pan.Pan -initialDir "C:\PCE\data-integration"\ /file:C:\PCE\Transformaciones\Resumen.ktr 
08:32:03,175 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
08:32:04,347 ERROR [ServerSocketBasedKarafInstanceResolver] Error creating ServerSocket
java.net.BindException: Address already in use: JVM_Bind
    at java.net.DualStackPlainSocketImpl.bind0(Native Method)
    at java.net.DualStackPlainSocketImpl.socketBind(Unknown Source)
    at java.net.AbstractPlainSocketImpl.bind(Unknown Source)
    at java.net.PlainSocketImpl.bind(Unknown Source)
    at java.net.ServerSocket.bind(Unknown Source)
    at java.net.ServerSocket.<init>(Unknown Source)
    at java.net.ServerSocket.<init>(Unknown Source)
    at org.pentaho.platform.osgi.ServerSocketBasedKarafInstanceResolver.resolveInstanceNumber(ServerSocketBasedKarafInstanceResolver.java:207)
    at org.pentaho.platform.osgi.ServerSocketBasedKarafInstanceResolver.resolveInstance(ServerSocketBasedKarafInstanceResolver.java:65)
    at org.pentaho.platform.osgi.KarafInstance.assignPortsAndCreateCache(KarafInstance.java:152)
    at org.pentaho.platform.osgi.KarafBoot.createAndProcessKarafInstance(KarafBoot.java:329)
    at org.pentaho.platform.osgi.KarafBoot.startup(KarafBoot.java:224)
    at org.pentaho.di.osgi.registryExtension.OSGIPluginRegistryExtension.init(OSGIPluginRegistryExtension.java:109)
    at org.pentaho.di.core.plugins.PluginRegistry.init(PluginRegistry.java:596)
    at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironment.java:115)
    at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironment.java:79)
    at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:124)
    at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:98)
    at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:79)
    at org.pentaho.di.pan.Pan.main(Pan.java:73)
    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.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
08:32:08,378 INFO  [KarafInstance] 
*******************************************************************************
*** Karaf Instance Number: 2 at C:\PCE\data-integration\.\system\karaf\cach ***
***   es\pan\data-1                                                         ***
*** FastBin Provider Port:52902                                             ***
*** Karaf Port:8803                                                         ***
*** OSGI Service Port:9052                                                  ***
*******************************************************************************
2018/04/10 08:32:20 - Pan - Start of run.
2018/04/10 08:32:21 - Resumen - Dispatching started for transformation [ResumenMagma]
2018/04/10 08:32:21 - Table output.0 - Connected to database [Conexion 10.120.50.10] (commit=1000)
2018/04/10 08:32:22 - Archivo Magma.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
2018/04/10 08:32:22 - Resumen - Transformation detected one or more steps with errors.
2018/04/10 08:32:22 - Resumen - Transformation is killing the other steps!
2018/04/10 08:32:22 - Pan - Finished!
2018/04/10 08:32:22 - Pan - Start=2018/04/10 08:32:20.920, Stop=2018/04/10 08:32:22.229
2018/04/10 08:32:22 - Pan - Processing ended after 1 seconds.
    
asked by Osky 05.04.2018 в 20:33
source

1 answer

0

If you pass everything described above, what happened I had to change so everything would work ok.

The error specified above was due to the fact that some application was occupying the same port as Pentaho. I had to restart the Server and it was fixed.

Then I found that creating a windows task would not execute the file.bat that I had armed for the execution of the transformation.

This was because the files being in a remote repository and with all the permissions for the user that runs, did not work.

In this way, you must first create a file.bat that will copy the remote files in a local folder and finally modify the original bat where you executed the Pentaho trasnformacion.

This way I work correctly.

There was no way for the Pentaho job scheduler to work and I still do not know why it is not running.

I hope I can help you with these tips.

Greetings, Oscar.

    
answered by 12.04.2018 в 13:46
Why is not the image updated in the database? error 2005 (hy000) unknown mysql server host (110)