AnsweredAssumed Answered

Error "cfgbuilder-Warning: [org] is not supported" running a job from file in linux

Question asked by Cristina Corrales on Dec 29, 2017

Hi,

 

I'm new using linux (centos) and also setting job executing automatically.

 

I'm executing the job using this information: https://wiki.pentaho.com/display/EAI...unajobfromfile

 

Like this: kitchen.sh -file=/PRD/updateWarehouse.kjb -level=Minimal

 

However I'm receiving this error:

cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

 

What the .sh file doesin Centos is mount a windows folder because the job uses an excel in that folder and upload it to a database table.

 

I only have a linux server to run this job that works in windows.

 

But I don't understand what is this error related, any idea?

If I open the job file in windows using spoon.bat it runs fine and never show me that error.

 

Data Integration version: 6.1

 

Thanks in advance!

 

 

 

This is the log when there is no file:

 

10:15:03,838 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled

Dec 28, 2017 10:15:04 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired

INFO: Lock acquired. Setting startlevel to 100

2017/12/28 10:15:05 - Kitchen - Logging is at level : Minimal

2017/12/28 10:15:05 - Kitchen - Start of run.

2017/12/28 10:15:05 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

Dec 28, 2017 10:15:07 AM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess

INFO: New Caching Service registered

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/opt/pentaho/data-integration/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/opt/pentaho/data-integration/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

 

 

And this is the log when there is a file to upload:

But don't upload the file

 

10:14:06,705 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled

Dec 28, 2017 10:14:07 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired

INFO: Lock acquired. Setting startlevel to 100

2017/12/28 10:14:07 - Kitchen - Logging is at level : Minimal

2017/12/28 10:14:07 - Kitchen - Start of run.

2017/12/28 10:14:08 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

Dec 28, 2017 10:14:10 AM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess

INFO: New Caching Service registered

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/opt/pentaho/data-integration/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/opt/pentaho/data-integration/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

2017/12/28 10:14:13 - Job_Test - Start of job execution

2017/12/28 10:14:13 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

2017/12/28 10:14:13 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

2017/12/28 10:14:13 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp

2017/12/28 10:14:13 - Job_Test - Job execution finished

2017/12/28 10:14:13 - Kitchen - Finished!

2017/12/28 10:14:13 - Kitchen - Start=2017/12/28 10:14:07.953, Stop=2017/12/28 10:14:13.787

2017/12/28 10:14:13 - Kitchen - Processing ended after 5 seconds.

10:15:03,837 INFO [KarafInstance]

 

 

 

The way I'm executing the job:

 

mount...

 

/opt/pentaho/data-integration/kitchen.sh -file=/opt/pentaho/repo/Job_Test.kjb -level=Minimal >> /var/log/log_job.log

Outcomes