Search Options
Skip to main content (Press Enter).
Sign In
Skip auxiliary navigation (Press Enter).
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Communities
General Discussion
My Communities
Explore All Communities
Products
Solutions
Services
Developers
Champions Corner
Customer Stories
Insights
Customer Advocacy Program
Badge Challenges
Resources
Resource Library
Hitachi University
Product Documentation
Product Downloads
Partners Portal
How To
Get Started
Earn Points and Badges
FAQs
Start a Discussion
Profile
My Contributions
List of Contributions
Profile
John Eicher
This individual is no longer active. Application functionality related to this individual is limited.
Contact Details
×
Enter Password
Enter Password
Confirm Password
John Eicher
This individual is no longer active. Application functionality related to this individual is limited.
Profile
Connections
Contacts
Contributions
Badges
List of Contributions
My Content
1 to 20 of 34 total
search criteria =
ALL
RE: Unzip file issue in Pentaho-spoon
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, ...
RE: Error when invoking API with Kettle Transformation through Java
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. ...
RE: Connecting to SalesForce API 43 from Pentaho 6.0.1.0-386 community edition
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 ...
RE: How to eliminate legacy execution engine?
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 ...
RE: Error when invoking API with Kettle Transformation through Java
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
RE: cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
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 ...
RE: Can't use directory path variables on Get data from XML step
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, ...
RE: Run a transform with HIVE2 in AEL
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 ...
RE: Clear log channel before job execution from BA Server
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 ...
RE: Issue with Setting up hadoop cluster in spoon
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 ...
RE: MongoDB Input Step Cursor error with 8.1 version
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 ...
RE: Python logs with ERROR message
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 ...
RE: Hi, Kettle integrated with Eloqua but OFFSET not working to retrive more than 50000 records
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? - ...
RE: Pentaho PDI ETL : error connection to mysql version 8
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
RE: How to convert epoch time to date field
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 ...
RE: Installing Pentaho EE using external MySQL for repository. Failure to start.
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, ...
RE: Installing Pentaho EE using external MySQL for repository. Failure to start.
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 ...
RE: pentaho hibernate on mysql empty
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 ...
RE: Hi, we have downloaded kettle v6.1 and tried to load our data through kettle v6.1 pentaho tool into DB, our data got loaded but we are receiving below warning: "AM org.apache.karaf.main.Main$KarafLockCallback lockAquired INFO: Lock acquired. Setting start
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
RE: Hi, we have downloaded kettle v6.1 and tried to load our data through kettle v6.1 pentaho tool into DB, our data got loaded but we are receiving below warning: "AM org.apache.karaf.main.Main$KarafLockCallback lockAquired INFO: Lock acquired. Setting start
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
«
1
2
»
© Hitachi Vantara LLC 2023. All Rights Reserved.
Powered by Higher Logic