Profile

Ravikumar Kamma

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

Contact Details

My Content

1 to 20 of 23 total

RE: Is it possible to save data from two different etl streams in the same excel file, but in different tabs?

Posted By Ravikumar Kamma 11-14-2019 15:38
Found In Community: Pentaho \ view thread
@Sergio Ribeiro​  Thanks

RE: Is it possible to save data from two different etl streams in the same excel file, but in different tabs?

Posted By Ravikumar Kamma 11-13-2019 17:35
Found In Community: Pentaho \ view thread
@Sergio Ribeiro​  ​ I​ tried to create two sheets in same workbook, it always overwrite the first sheet. ​ I dont know what I am missing. ​Could you please point out some documentation?

RE: How to pass parameters to kjb file when running using Kitchen.bat

Posted By Ravikumar Kamma 04-05-2019 09:34
Found In Community: Pentaho \ view thread
define your parameters in kettle.properties file and read that in your job.

RE: Incomparable types "java.util.Date" and "java.lang.String"

Posted By Ravikumar Kamma 04-04-2019 06:48
Found In Community: Pentaho \ view thread
When I was migrating from 6.1 to 8.x I realized that Pentaho refined the way they handle meta data. I faced such error where it was working fine in lower version and giving error in higher. Check data type properly.

RE: Nombre de jours ouvrés sans les jours fériés

Posted By Ravikumar Kamma 04-04-2019 06:42
Found In Community: Pentaho \ view thread
1. If you consider Mon-Fri as a working days in a week then there is a function in calculator step (Date A - Date B (working days)). 2. If you are having additional holidays in between then that you have to pass as input and subtract that from #1

RE: Newbie - Issue with All Spoon Transformations

Posted By Ravikumar Kamma 04-03-2019 11:20
Found In Community: Pentaho \ view thread
Not sure what is the problem but Please try below steps if it works 1. Close spoon 2. Delete .kettle folder from user directory 3. Run spoon again

RE: java.lang.OutOfMemoryError: GC overhead limit exceeded error

Posted By Ravikumar Kamma 03-12-2019 08:44
Found In Community: Pentaho \ view thread
A few days back I was having same problem. I was reading data(6000000) from CSV and loading into MongoDB after multiple lookups, sorting, grouping. Even after adjusting PENTAHO_DI_JAVA_OPTIONS parameters it was giving GC overhead limit exceeded error. So I decided to process in batch. In your case If ...

RE: Error connecting steps via middle mouse button

Posted By Ravikumar Kamma 03-11-2019 17:43
Found In Community: Pentaho \ view thread
I am using PDI 8.2 on windows 10, It is working fine for me.

RE: How to run a Job using Kettle.bat file?

Posted By Ravikumar Kamma 02-25-2019 13:48
Found In Community: Pentaho \ view thread
It seems it is not able to read the transformation. Place your root job and all transformation in the same folder and Try by giving filename like this. $(Internal.Entry.Current.Directory)/ If this is not a problem then please provide more information. ~Ravik

RE: SQL Statement using variables in PDI

Posted By Ravikumar Kamma 02-20-2019 12:43
Found In Community: Pentaho \ view thread
Please try this SELECT * FROM $(asset) WHERE `Serial Number` = $(serial) It seems it is causing a problem because you have space in your column name. I tried in MySQL, it works. ~Ravik

RE: Replace Number (0) with NULL

Posted By Ravikumar Kamma 02-19-2019 14:29
Found In Community: Pentaho \ view thread
use  Null if step ~Ravik

RE: Fields not found in MongoDB output from Kafka consumer

Posted By Ravikumar Kamma 02-19-2019 09:15
Found In Community: Pentaho \ view thread
I am not able to understand much from the error. Could you please try mentioning DB and collection name in Output option. Not sure if variable substitution is supported here. ~Ravik

RE: External JS library behaviour in CDE

Posted By Ravikumar Kamma 02-15-2019 16:48
Found In Community: Pentaho \ view thread
Yes, It is enabled. I understood the problem. First dashboard is without RequireJs support while the second one is with RequireJs. Thank you.

External JS library behaviour in CDE

Posted By Ravikumar Kamma 02-15-2019 16:06
Found In Community: Pentaho \ view thread
Hi All, I am using Pentaho 8.2 on windows 10. I have two CDE dashboard. Both are deployed on same server. I am calling momentjs library in both of them. Dashboard one works without any problem. Dashboard two gives an error for require.js:8 Uncaught Error: Mismatched anonymous define() module: When I ...

RE: JOB with Transformation fails from PUC

Posted By Ravikumar Kamma 02-07-2019 13:32
Found In Community: Pentaho \ view thread
I found that CSV has generated at system local directory with path C:\home\<> The path I had given to Text file output step was $(Internal.Entry.Current.Directory)/testCSV Need to understand why it generated at system local directory. Mentioning Data Integration in case someone reply. Thanks, Ravik

RE: JOB with Transformation fails from PUC

Posted By Ravikumar Kamma 02-07-2019 12:17
Found In Community: Pentaho \ view thread
I tried in Pentaho 8.2 PUC. It is running without any error. I hope you are using this for reading your kettle. $(Internal.Entry.Current.Directory)/ .ktr I tried to generate a CSV file in PUC using job/kettle, it is running without any error but I am not able to see any generated CSV in the same directory. ...

RE: Pentaho 8.2 Error while accessing charts

Posted By Ravikumar Kamma 02-05-2019 09:55
Found In Community: Pentaho \ view thread
Hello Duarte Leao Thanks. It seems the problem was with Browser cache.

Pentaho 8.2 Error while accessing charts

Posted By Ravikumar Kamma 02-04-2019 14:17
Found In Community: Pentaho \ view thread
Hello All, Whenever I access any chart from CDE I gets this error and execution stops. ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /common-ui/resources/web/compressed/pentaho/type/Context.js not found in plugin common-ui I checked, Context.js is not available ...

RE: PDI 8.2 broken steps (CE)

Posted By Ravikumar Kamma 01-30-2019 11:13
Found In Community: Pentaho \ view thread
It seems other users are also facing the same problem but as of now, no solid solution is posted. I found this while searching [PDI-17785] Annotate Stream/Shared Dimension step - null pointer exception when mouseover steps on Design panel - Pentah… PDI-17785 Thanks Ravik

RE: PDI-17785

Posted By Ravikumar Kamma 01-30-2019 10:49
Found In Community: Pentaho \ view thread
I also faced the same problem. It seems someone has provided a temp workaround for same [PDI-17785] Annotate Stream/Shared Dimension step - null pointer exception when mouseover steps on Design panel - Pentah…