Profile

John Eicher

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 20 of 34 total
Posted By John Eicher 09-05-2018 20:04
Found In Community: Pentaho
\ view thread
Hi Roger, I was unable to reproduce the error youre describing. I used á, é, í, ó, ú as the contents of a file and then zipped the file and unzipped it using Pentaho 8.1.0.0.   Ill recommend a few things you could try:   Change the archival program youre using. For example, if you use windows archive, ...
Posted By John Eicher 08-16-2018 16:00
Found In Community: Pentaho
\ view thread
Ayan, Based on the code youve described here, it looks like you may not be actually passing any parameters when attempting to execute the transformation. Please see the code below, youll need something like this.       // Loading the transformation file from file system into the TransMeta object.       ...
Posted By John Eicher 08-16-2018 15:37
Found In Community: Pentaho
\ view thread
Hi Nilesh, Id recommend you upgrade your version of Pentaho. Version 6.0.1 of Pentaho was built to use the version 21 of the Salesforce API, and wont work with anything newer than 24. Version 6.0.1 of Pentaho also suggests that you should connect through www.salesforce.com for the API which has since ...
Posted By John Eicher 08-16-2018 15:23
Found In Community: Pentaho
\ view thread
Hi Martin, The Using legacy execution engine message simply means that youre using kettle as the engine. This is the default and doesnt necessarily mean youre using an old engine thats no longer being maintained or something along those lines. The reason this is a new message in 8.1 as compared to 7.0 ...
Posted By John Eicher 08-01-2018 23:50
Found In Community: Pentaho
\ view thread
Ayan, Can you please clarify what you mean by running a Kettle transformation through Java ? Transformations and jobs are meant to be run by the Kettle engine, e.g. Kitchen, Pan, or Spoon. They dont just run if executed against a JDK/JRE itself. -Chris
Posted By John Eicher 08-01-2018 23:45
Found In Community: Pentaho
\ view thread
Hi Urvashi, Based on your information that this is an upgrade for you, can you please check your kettle.properties file and see if you have this property? vfs.sftp.org.apache.commons.vfs2.provider.sftp.SftpFileSystemConfigBuilder.USER_DIR_IS_ROOT If you do, please either remove or comment out this property ...
Posted By John Eicher 08-01-2018 23:37
Found In Community: Pentaho
\ view thread
Hi, This is a defect with the product. You can view the defect report here in the Pentaho Jira: [PDI-17478] Cant use directory path variables on Get data from XML step - Pentaho Platform Tracking It looks like you may have been the one who logged this defect in Jira as the error text is the exact same, ...
Posted By John Eicher 08-01-2018 17:58
Found In Community: Pentaho
\ view thread
Hi HUY, The following steps will help to get Hive connection work on AEL: 1) Download from the internet the jars youll need, could be like Cloudera_HiveJDBC4_2.5.4.1006 if using Cloudera. If using a different vendor, download their Hive drivers. 2) Unzip the driver-archive into the .../data-integration/lib ...
Posted By John Eicher 08-01-2018 17:34
Found In Community: Pentaho
\ view thread
Hi Anton, Youre likely encountering this issue: [PDI-17399] log messages from previous runs appended to the latest run of the same job - Pentaho Platform Tracking Basically, if youre using the Pentaho Server run configuration (which is the run configuration that will be used when executing a job from ...
Posted By John Eicher 07-25-2018 21:45
Found In Community: Pentaho
\ view thread
Rajat, When you connect to Hadoop from Spoon, it will attempt to connect to the cluster using the user profile of whoever started Spoon. So for example, in my case if I start Spoon in Windows using my ceicher profile, I must have a /user/ceicher directory in the Hadoop cluster, or else I will get similar ...
Posted By John Eicher 07-25-2018 21:30
Found In Community: Pentaho
\ view thread
Hi Rajagopal, I found a Jira from MongoDB about the same error with the same stacktrace and the Mongo folks suggested it might be an issue with load balancer. Do you have a load balancer? I would suggest you check out this Jira from MongoDB: [JAVA-2538] MongoCursorNotFoundException almost immediately ...
Posted By John Eicher 07-25-2018 21:13
Found In Community: Pentaho
\ view thread
Hi Tomas, Pentaho version 5.2 is getting pretty old at this point and has been unsupported for a while. Id suggest you upgrade to a newer version such as 7.1 or 8.1. Past that, Id recommend you try the CPython Script Executor, which is a community plugin (but managed by Pentaho/HV) that deploys a better ...
Posted By John Eicher 07-25-2018 21:07
Found In Community: Pentaho
\ view thread
Dhanenjjeyan, I do not believe there is any official support for Eloqua in Pentaho, so I dont believe there will be any documentation that can be provided. Are you able to give a little more detail on how youre connecting? Is this via a community plugin, a REST API, or maybe a database connection? - ...
Posted By John Eicher 07-25-2018 18:15
Found In Community: Pentaho
\ view thread
Paul, The new Connector/J 8.0 uses a different driver class path. Please use the Generic database connection type when using the new Connector/J 8.0 version. Your connection URL should look like: jdbc:mysql:// : / And your driver class will be: com.mysql.cj.jdbc.Driver -Chris
Posted By John Eicher 07-25-2018 16:09
Found In Community: Pentaho
\ view thread
Hi Clifford, You can use a Select Values step and it should work. Feed your stream that contains the UNIX time field into a Select Values step and in the Meta-data tab of the Select Values step, add the UNIX time field and change the Type to Date and select whatever format youd prefer. If you find that ...
Posted By John Eicher 06-25-2018 23:42
Found In Community: Pentaho
\ view thread
Clifford, It simply looks like the server is unable to contact the repository. This is either because the Pentaho Server is incorrectly configured or because the Pentaho Server is unable to reach your MySQL database. There are 6 files you need to edit in the Pentaho Server file system: repository.xml, ...
Posted By John Eicher 06-25-2018 18:20
Found In Community: Pentaho
\ view thread
Hi Clifford, Look at this error: Caused by: org.pentaho.di.core.exception.KettleException: !Monitoring.License.Message! This means you need to install your enterprise licenses. The behavior you described of getting to the web login but being unable to actually login is consistent with this error. You ...
Posted By John Eicher 06-25-2018 18:10
Found In Community: Pentaho
\ view thread
Hi Slim, You should be seeing entries in your Hibernate database if youre using an enterprise repository with an EE version of Pentaho. If youre not seeing any entries, you may not have your connection configured correctly. Please refer to our documentation for setting up the enterprise repository using ...
Posted By John Eicher 06-25-2018 17:38
Found In Community: Pentaho
\ view thread
Urvashi, I suggest you work together with your vendor on this if theyre going to provide support for your Pentaho installation. Otherwise, I dont see any errors in the log you posted. These are all info or warning messages, which are not necessarily anything to worry about. -Chris
Posted By John Eicher 06-22-2018 05:11
Found In Community: Pentaho
\ view thread
Hi Urvashi, Version 6.1 from an official support standpoint is on limited support. Please try version 8.1 and let me know what errors you encounter. You may find that the newest version does not provide any errors for your configurations when you load data. -Chris