Pentaho Community Forums

how to set css style of CDE Date input component

yanshuai — Wed, 16 May 2012 14:17:13 GMT

hi, all, I'm a beginner of CDE, and I use date input component as follows:
Screenshot-3.jpg

how can I set its css style so that the date input box width looks much larger?
Screenshot-2.png

I have tried set start_day_layout css style, but it doesn't affect.

Attached Images

Screenshot-3.jpg (13.9 KB)
Screenshot-2.png (1.4 KB)

Change context root of administration console

bjork — Wed, 16 May 2012 14:10:55 GMT

I am trying to change the context root of the administration console from / to /admin. I have extended the org.pentaho.pac.common.server.JettyServer class with a new class overriding createServletContext() and configureServlets(Context servletContext) see below. I have changed the classpath in start-pac.sh to -cp $CLASSPATH org.pentaho.pac.server.JettyServerAdmin. However when I start the administration console it is still running under context root /

How can I change the context root?

Code:

package org.pentaho.pac.server;



import org.mortbay.jetty.handler.ContextHandlerCollection;

import org.mortbay.jetty.servlet.Context;

import org.mortbay.jetty.servlet.ServletHolder;



public class JettyServerAdmin extends JettyServer {



  public JettyServerAdmin() {

    super();

  }

  

  protected Context createServletContext() {

    ContextHandlerCollection contextHandlers = new ContextHandlerCollection();

    Context servletContext = new Context(contextHandlers, "/admin", Context.SESSIONS); //$NON-NLS-1$

    servletContext.setResourceBase( getResourceBaseName() ); 

    servletContext.setWelcomeFiles( getWelcomeFiles() ); 

    

    return servletContext;

  }

  

  public void configureServlets( Context servletContext ) {

        // add servlets

        ServletHolder defaultServlet = new ServletHolder(new DefaultConsoleServlet("/admin-ce", this)); //$NON-NLS-1$

        servletContext.addServlet(defaultServlet, "/admin/*"); //$NON-NLS-1$

        servletContext.addServlet(defaultServlet, "/admin/halt"); //$NON-NLS-1$

        

        ServletHolder welcomeServlet = new ServletHolder(new BrowserLocaleServlet());

        servletContext.addServlet(welcomeServlet, "/admin/browserlocalesvc"); //$NON-NLS-1$



        ServletHolder pacsvc = new ServletHolder(new org.pentaho.pac.server.PacServiceImpl());

        servletContext.addServlet(pacsvc, "/admin/pacsvc"); //$NON-NLS-1$



        ServletHolder schedulersvc = new ServletHolder(new org.pentaho.pac.server.SchedulerServiceImpl());

        servletContext.addServlet(schedulersvc, "/admin/schedulersvc"); //$NON-NLS-1$



        ServletHolder subscriptionsvc = new ServletHolder(new org.pentaho.pac.server.SubscriptionServiceImpl());

        servletContext.addServlet(subscriptionsvc, "/admin/subscriptionsvc"); //$NON-NLS-1$



        ServletHolder solutionrepositorysvc = new ServletHolder(new org.pentaho.pac.server.SolutionRepositoryServiceImpl());

        servletContext.addServlet(solutionrepositorysvc, "/admin/solutionrepositorysvc"); //$NON-NLS-1$

        

        ServletHolder jdbcdriverdiscoveryservice = new ServletHolder(new org.pentaho.pac.server.common.JdbcDriverDiscoveryServiceImpl());

        servletContext.addServlet(jdbcdriverdiscoveryservice, "/admin/jdbcdriverdiscoverysvc"); //$NON-NLS-1$



        ServletHolder hibernateconfigurationservice = new ServletHolder(new org.pentaho.pac.server.common.HibernateConfigurationServiceImpl());

        servletContext.addServlet(hibernateconfigurationservice, "/admin/hibernateconfigurationsvc"); //$NON-NLS-1$



      }

}

Oracle e CDE

Jose Sobral — Wed, 16 May 2012 13:54:35 GMT

Hello,
How to create a connection from a datasource with Oracle database in CDE.
I've tried sever always, but they are not recognized.

Thank you.

Sorry, any misspelling. My language is portuguese.

drill down in prpt charts

Ponb — Wed, 16 May 2012 13:49:27 GMT

when drilling down from Parent report to Child report , the parameters of the parent report are not hidden.

PDI: Looking for help to add a field of a previous row in a newl field

pgeers — Wed, 16 May 2012 13:30:03 GMT

As a new kettle / pdi user I am looking for help. I have a single column in a tabel where some elements are headers and some elements are details belonging to the header.
The header is always before the details. The number of detail recors are not known.

I would like to have the header info as an additional field at the subinfo row level. Any ides how this can be addressed best.

For An example of the column see link.

Thnx for the support.

gzip streaming task awesome, is there a regular zip version?

dhartford — Wed, 16 May 2012 13:14:41 GMT

Hey all,
I'm quite impressed with the gzip streaming task (direct to transformation, no pre-uncompression). With large files (5-10G+), this makes a huge difference from the old job-level approach of unzip file to a working directory first (that then becomes 20-30G+ raw), then read through, then cleanup afterwords.

Now, just gzip read the file as-is without an uncompress and cleanup process....and what's better is that I've been seeing 100k+ rows/sec throughput, 2x fold better than raw!

question:
Is there an equivalent for regular zip? I understand there are more challenges:
*Zip files can contain multiple files, while gzip only one (in the above scenario, assuming non-tar files). As such, need to regex/identify which file (dir depth?) within the zip file.
*password protected (optional), zip can also be password protected, and in my research there are multiple algorithms. Personally, I would be happy if this wasn't included initially since most setups already have a 'pre-process' file to unprotect first anyway.
*there is a chance of different compression algorithms, again, optional and I would be happy with basic/standard support.

p.s. I've been 'arrow-in-the-knee' deep in SSIS('05,'08), and I miss Pentaho Kettle ETL work :-)

Request For Kettle User's manual

fariborzgolara — Wed, 16 May 2012 11:05:34 GMT

Hello All

Could anybody tell me name of user's manual about defininig Job in kettle.
I want to create a job in kettle but unfortunately I don't have any good user's manual to advice me around this subject.

Thanks in advance

Http Post JSON input variables from source database table or csv

torosol — Wed, 16 May 2012 10:18:33 GMT

I have a JSON call I am making using Http Post and have a problem with the amount of data that is coming back and need to split the call into stages for each code param within the JSON call. The body of the Http post is saved in a .js file but I need to change one of the params so I can save the data returned for each id then move onto the next, I have over 13,000 different Code's that I need to call data for then save into a database.
Here is an example of the JSON call body in the input .js file;

Code:

{"jsonrpc": "2.0",

 "method": "DataReturn",

 "params": {"User": "user1",

            "Password": "pass1",

            "Codes": ["123455", "123456"],

            "Items": ["Data"

                     ]

           },

 "id":    1001

}

I have done some tests and one call comes back in 2 secs and can add 5 codes returns in 10-12 secs but over that I run into memory issues with the amount of data that is coming back and cannot save it so think it would be simplist if I can loop through a list of codes and save the data from each one in turn or can I save the data as it comes back?

Thanks

Looking for help on xml data extraction

anoop3525 — Wed, 16 May 2012 10:12:52 GMT

Hi All,

I am new to Pentaho-Kettle tool.. Here i am tring to import xml data into mysql db.

My xml is something like this:

="ADD" ID="40000859" StartDate="2007-01-28" TemplateType="Default"> <Description>Board GamesDescription>

- <Item ID="20020002" TemplateType="Default">
<Price>199.99Price>

<Price CurrencyCode="CAD">299.99Price>

Item>

- <StoreID>04241StoreID>

<StoreID>04242StoreID>

<StoreID>04243StoreID>

PriceChange>

Issue that i am facing;
1. <Price> node, the smae is repeating 2 times under item node. while specifing PriceChange/Item/Price just getting the first price that is 199.00, but i am looking for the second price node's value too.. that is 299.00

2. How to retrive the repeating node id values those are 04241,04242,04243

I am using :Pentaho,kettle -spoon stable release -4.2.0

Thanks for the help.

Anoop.

Translating UUID to number primary/foreign keys

Per — Wed, 16 May 2012 07:46:41 GMT

I am using PDI 4.2.1 and I am involved in migrating an Oracle 10i database to an SQL Server 2008 database.

In the old Oracle database there is around 40 tables using UUIDs as primary and foreign keys, stored in a CHAR(16 BYTE) fields. There is of course references between the tables with these UUIDs.

When migrating, the plan/requirement is to migrate the UUID primary and foreign keys to new generated numbers (digits only) and the strategi is to take the tables in sequence, one by one, one job/transformation per each table, and generate new number primary keys.

I am trying to figure out how to do this, as the foreign keys also have to be updated so I need some sort of lookup per each table.

How can I solved this, any help is appreciated?

- Per

A Special Thank you for the forum

pictofigo — Wed, 16 May 2012 06:03:06 GMT

This forum definitely deserves a "Thank you" for bringing out great ideas from people. We gave a topic to think and people came up with brilliant ideas.

When we say Thanx, we say it our way like this:

Thankyou.png

more we have uploaded for you here: http://bit.ly/LQw9SL

Keep your good work going.

Regards,

p!
Pictofigo
(http://www.pictofigo.com)
--World's best freehand drawing search engine

Attached Images

Thankyou.png (13.1 KB)

Collapse Pentaho 3.8 + BIRT

halter — Wed, 16 May 2012 05:39:15 GMT

Sorry for my english

I havean installation ofpentahocommunity 3.8 andBIRT.

There are about200 usersaccessing abirtreport. The reportisa HTML tableof "3Mb"

Every 2days I have torestarttomcatbecause the systemcollapses,then the userscannotlogin. After restarting tomcat, everything is perfect.

-> configuration TOMCAT:
Minimummemory:3000m
Maximummemory:6000m
Reserved Memory: 3000m

What do i doing?

--------------------------------------------------------------------
edit 16/05/2012:
SO: Red Hat

Connection leakage in pentaho

Surendar — Wed, 16 May 2012 04:26:24 GMT

Hi All,

Can anyone of you help,why the below error is throwing.when we run the kettle job.

Below is the report by oracle support.Please reply me asap.

File Name:
Error Message:
----------------------------
#### <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1334986056881> at weblogic.jdbc.common.internal.ConnectionEnv.setup(ConnectionEnv.java:318)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:344)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:322)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:438)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:317)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:93)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:342)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:360)
at org.pentaho.di.core.database.Database.initWithNamedDataSource(Database.java:386)
at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:409)
at org.pentaho.di.core.database.Database.normalConnect(Database.java:354)
at org.pentaho.di.core.database.Database.connect(Database.java:319)
at org.pentaho.di.core.database.Database.connect(Database.java:281)
at org.pentaho.di.trans.steps.combinationlookup.CombinationLookup.init(CombinationLookup.java:729)
at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52)
at java.lang.Thread.run(Thread.java:619)
----------------------------
The above error message indicates that a connection which was reserved by the application, but was not released, was forcibly evicted by WebLogic Server. This means that somewhere within your application you have a connection leak and the connection which is being acquired is not being closed correctly after it has been used. In an application servers, when con.close is called on a connection, it is returned to the data-source and is made available for any other application requests which calls for the JDBC connection when DataSource.getConnection() is called.
In this scenario, after acquiring the connection the application needs to close the connection reference by calling con.close after it utilizes it completely. Failure to do so will result in a connection leak which would ultimately exhaust JDBC connections on the application server and sessions at the database end. With the current evidence on hand we can see that the same is not being done within the application. According to the stack trace present on the SR, we can see that the connection is being acquired at the following class.
-- org.pentaho.di.core.database.Database.initWithNamedDataSource(Database.java:386)
Following the same, however it is not being closed off. Additionally, please note that this error message means that the connection was found to be leaking and hence was forcibly released back into the connection pool by WebLogic. This feature is activated when we set the Inactive Connection Timeout in datasource properties. With this setting in place you will have a stable environment; however the resolution would be to find the connection leak within the application and mitigate the same.
With reference to the same, please consult with your application team/architects to understand the flow and lifecycle of the connection reference acquired within your application. This would enable you to determine where the leak is happening and mitigate the same.

How to hide Datasource / metadata model in PUC when creating new report

Nick — Tue, 15 May 2012 21:36:49 GMT

Hi,

I have two metadata models available in Pentaho User Console. These two metadata models show up as available DATASOURCEs when I select new Report.

Is there a way to hide one of these two datasources/metadata models to be available to the user to use it for report creation?

Please find below the screen shot of the same.
Thanks,
Nick.puc.jpg

Attached Images

puc.jpg (30.2 KB)

CDE: Autocomplete components and prpt in an iframe

flamierd — Tue, 15 May 2012 19:13:37 GMT

Preface: Love all the work that has went into CDE/CDF and I'm not trying to bust anyone's chops, but I always assume I'm doing something wrong first and it's been a real pain to do this correctly.

Ok, I decided to make a simple dashboard to do auto completes on our customer names and spit out a single page report on various data related to them including sales and trends.

So I created a CDE dashboard, created a row and two columns, named them, then created a datasource to retrieve the customer names, a text component to give the user a prompt and an "Auto complete component". I connected the component up to the data and all was fine except:

1. Alignment of the text component was vertical-align: top as was the auto complete box. Though the auto complete box actually extended outside the row at the top, cutting off the top border of the box.
2. So I created a css style and applied it to the row expecting it to be inherited, background-color was, that's about it.
3. Applied the style to the columns (divs) and received the same result.
4. Firebug showed me that my css class was having keys filtered out.
5. So I changed the text component to a simple html

with the class, instant fix for that. However the auto complete would not respond to any attempts to get it 'down'.
6. Created a spacer row with the same back color, that sort of fixed it, had to correct the text html (prompt) with different padding.
7. This screwed up the rounded corners however...so...I finally gave up and moved to the Simple Autocomplete Component

Simple Autocomplete Component

1. This looked better, though I had to change the datasource to accept the search parameter which made more sense to me.
2. Looking good. The thing played nicely in the column. Everything was looking good.
3. Created my report at this time and a simple parameter. Set the parameter in the Simple Autocomplete and set a listener in the PRPT component.
4. First issue was when I selected the item in the autocomplete before the accordian window closed the report tried to refresh, ie: the fireChange went off with the list out.
5. And because of this it was was sending only the letters typed into the box. ie: if I had typed "fed" and had selected "Federal Express" it was pushing "fed" into the
parameter and nothing was found.
6. I discovered this by unhiding the parameter box in the PRPT Component.
7. I was also expecting the additional customer ID number I had passed as part of the query not the display name, just as a regular dropdown would give me when the value was queried. This is probably not a bug just something that isn't part of the component.
8. So I removed the "parameter" from the autocomplete component, stuck in a PostExecute function, set the parameter variable to the getValue() of the autocomplete component and fired the change.
9. This did not work.
10. There is some problem with the report in an iframe wherein the parameter is getting initially ignored when the report refreshes. I haven't tried to debug it beyond noting that if I show the parameters in the PRPT component, the proper value shows up, but the report fails, however it DOES run after I hit the "View Report" button in the report viewer.
11. I removed the iFrame option from the PRPT component and now it just works sweet. Still alot of work and a great deal of sludging through web console to come up with a simple screen.

Hope this helps someone.

Btw: This is in the latest version of Firefox with 4.5 BI and the latest (I believe version of ctools)

SHA-2 Hash

aysen — Tue, 15 May 2012 17:32:59 GMT

Apologies if this is something I missed in my forum search but could not find:

I need to hash encrypt a field in a transformation using SHA-2/256. Is this possible using Kettle?

Thanks in advance, Jay

Using Oracle with the CDE

Jose Sobral — Tue, 15 May 2012 17:32:26 GMT

Hello,

I'm using Pentaho BI Server with the CDE, but when creating dashboardswith CDE and Oracle 11g, there not appear the datasources that I created.
Does anyone know if there is any special configuration for Oracle?
The driver is correct, because I can create reports.
I have used Microsoft SQL Server, and got success.

Thank you.

Sorry, any misspelling. My language is portuguese.

jndi.jpg

Attached Images

jndi.jpg (14.6 KB)

Publish a report with a user other than joe

fragume — Tue, 15 May 2012 16:31:41 GMT

I have a user named user1 and I want him to be running the published reports. Currently always was publishing reports with joe / password and would like two things:
1. - How I can do to make the user1 can run a report without having to enter the console user joe and use the option to share?
2. - How I can publish the reports with a more generic user, other than joe / password as is the default?

Please help me.
Thanks a lot!

Heap Exhaustion - Is this a typical issue?

w00te — Tue, 15 May 2012 15:30:41 GMT

Description of Problem:

I'm running a scheduled job every 30 minutes (controlled by the start step of the Job which is itself launched using Kitchen).

The only transformation called by the job queries a web service, gets a very large XML stream, passes it into a stored procedure, and repeats. Additional steps aside from the REST Client and Call DB Procedure steps include logging, some minor "Modify Java Script Value" steps, and a couple small Table Input steps.

This job executes correctly around 14 times when run from Kitchen over the course of a day, and then it gets a Java Heap exception as shown below.

I would like to know:

Is this a known problem when using large streams/strings as returned from the REST Client step?
Is there anything I can do to determine what exactly is leaking? (because there must be a leak since it works 14 times through prior to this).
Can anyone think of a way to mitigate this kid of problem or leak within Kettle?

Thank you in advance, and here is the exception message:

ERROR 14-05 17:17:41,998 - EAN WS REST - UnexpectedError:
ERROR 14-05 17:17:41,999 - EAN WS REST - java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Unknown Source)
at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source)
at java.lang.AbstractStringBuilder.append(Unknown Source)
at java.lang.StringBuilder.append(Unknown Source)
at com.sun.jersey.core.util.ReaderWriter.readFromAsString(ReaderWriter.java:172)
at com.sun.jersey.core.util.ReaderWriter.readFromAsString(ReaderWriter.java:157)
at com.sun.jersey.core.provider.AbstractMessageReaderWriterProvider.readFromAsString(AbstractMessageReaderWriterProvider.java:114)
at com.sun.jersey.core.impl.provider.entity.StringProvider.readFrom(StringProvider.java:73)
at com.sun.jersey.core.impl.provider.entity.StringProvider.readFrom(StringProvider.java:58)
at com.sun.jersey.api.client.ClientResponse.getEntity(ClientResponse.java:553)
at com.sun.jersey.api.client.ClientResponse.getEntity(ClientResponse.java:506)
at org.pentaho.di.trans.steps.rest.Rest.callRest(Rest.java:172)
at org.pentaho.di.trans.steps.rest.Rest.processRow(Rest.java:389)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Unknown Source)
ERROR 14-05 17:17:42,000 - Execute Incremental Update - Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
Error cancelling statement
Invalid state, the Statement object is closed.
ERROR 14-05 17:17:42,021 - Execute Incremental Update - org.pentaho.di.core.exception.KettleDatabaseException:
Error cancelling statement
Invalid state, the Statement object is closed.
at org.pentaho.di.core.database.Database.cancelStatement(Database.java:639)
at org.pentaho.di.core.database.Database.cancelQuery(Database.java:619)
at org.pentaho.di.trans.steps.sql.ExecSQL.stopRunning(ExecSQL.java:244)
at org.pentaho.di.trans.Trans.stopAll(Trans.java:1352)
at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2244)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:64)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Invalid state, the Statement object is closed.
at net.sourceforge.jtds.jdbc.JtdsStatement.checkOpen(JtdsStatement.java:220)
at net.sourceforge.jtds.jdbc.JtdsStatement.cancel(JtdsStatement.java:817)
at org.pentaho.di.core.database.Database.cancelStatement(Database.java:633)
... 6 more

Simultaneous Kettle Jobs Execution

ccverak — Tue, 15 May 2012 14:58:49 GMT

I pretend to scale my app and some part of the process includes to run kettle jobs simultaneously by some processing clients, in some point transformations need to perform combination lookup on some shared table (let's suppose "clients_table"), this table grows quickly due to all posible clients are unknown, so they are inserted as the show up. Combination lookup on simultaneously executing jobs (let's say 2 but could be more than that, each per client) over this table, it is presenting concurrency issues because of "duplicate entry key xxx" error, i suppose that happens while inserting non existing clients (when combination lookup didn't find them in the table to retrieves it's id). It's a fact that every time processing clients executes kettle jobs will transfer new clients so above problem it's very common. I wonder if i'm breaking kettle philosophy or i'm missing something, i've read about diferents extrategies on combination lookup step (table maximum + 1 or autoincrement) or making kettle transformations transactional could that be my solution????, (i think what's going on is that combination lookup step isn't transactional), please give me some ideas, PS: I'm using Kettle 4.2 and MySql 5.2

Is it a bug? - rewriteBatchStatements

codek — Tue, 15 May 2012 12:21:23 GMT

Hi,

I noticed that if you use rewriteBatchStatements=true with the mysql driver, and have a large commit size, then you blow the max_prepared_stmt_count limit.
( however this limit can be easily increased )

I wondered, is that expected? I guess it is. I guess if you have a commit size of 1000, and 30 fields, then you're going to use 30,000 bind variables right?

( this only applies with the 5.x driver, not the 3.x one )

Dan

prpt component & execute prpt component

yanshuai — Tue, 15 May 2012 11:40:56 GMT

hi, all, does PRPT component have some difference with execute PRPT componen? What''s the difference?

Problem with Cross tab report in PRD 3.8

renjitab — Tue, 15 May 2012 10:46:03 GMT

Hi,
I am using cross tab in PRD 3.8.3. I am facing a problem in this.

Below is the data which we queried from database:

COL1 COL2 COL3
A 1 11-NOV
B 2 11-NOV
A 3 14-NOV
C 4 14-NOV
D 5 14-NOV
E 6 14-NOV
F 7 14-NOV
B 8 14-NOV
G 9 14-NOV

And the below is the report which is being generated using the above data:

A B
11-NOV 1 2
14-NOV 3 4 5 6 7 8 9

Above report has the following problems:
1) Columns names(C,D,E,F,G) are not being displayed. This is because there is no data for 11-Nov however there is data for other dates.
2) Value for 14-NOV and B is 8 but in the report it is coming as 4. Its taking the value in sequence.

Is there any configuration to rectify these in PRD??

Thanks

Problem with Cross tab report in PRD 3.8

renjitab — Tue, 15 May 2012 10:26:50 GMT

Execute Row SQL script -- Oracle says "invalid character"

juliocgut — Tue, 15 May 2012 10:25:58 GMT

Hello forum!

I am trying to use the Execute Row SQL script to do the following:

- I have a table that contains a CLOB field in which SQL scripts are stored
- I read this CLOB field into Kettle
- I use the Kettle field as source for the Execute Row SQL script.

The issue is that Oracle complains about "invalid character" (ORA-00911). The script has several SQL sentences separated originally by /. I have tried both / and ; but to no avail.
It only seems to work when there's only one sentence, cannot seem to make it work with multiple.
I have also tried executing the script with a normal SQL tool and it works fine.

Any ideas?

BTW, this is still good old v3.2. We're on the road to migration to 4.x but still not there.

Many thanks,

--
Julio.

Connection attempt failed: Communications link failure

thanura — Tue, 15 May 2012 07:12:22 GMT

I have downloaded the trial version of Pentaho EE and looks like its not going to work for me. I'm getting this error while I try to create a new data connection, and this is my first one.
ERROR: Connection attempt failed: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

I can connect to Pentaho default database on jdbc:mysql://localhost:3306/hibernate, but when I try to connect to jdbc:mysql://localhost:8888/dwh it give this error. I can connect to this database using phpMyadmin or any other client.

I tried adding the tomcat permission, and I tried changing my.cnf to bind to all host of my mysql server, copy the jdbc driver to all necessary and also to unnecessary folders of Pentaho installation :). Nothing helps

My OS is Mac OSX Lion, and I'm using MAMP installation's mysql server.

Please help me need to do this proof of concept to my manager so we can decide weather to buy Pentaho or not.

Pentaho 3.8 not showing data

rider555 — Tue, 15 May 2012 06:16:31 GMT

Am still using 3.8, as we still need Mondrian for our office reporting needs. I recently created a new tableset and a new schema. The data started third week of April, and has been working ever since. PDI is set to truncate the data over and over to make sure the data won't be doubled. By May 14, we noted that the data stopped appearing in 3.8 up until May 8. According to the database, the data is up-to-date. We have two Pentaho BI suite 3.8, one is the production and one is a staging, both on separate servers. Both show the same problem. Oddly enough, we have an old Pentaho 3.0 suite still active, but it shows the data all the way to the 15th. What could I be doing wrong? Please help.

Is run log in the correct order?

jcstewar — Tue, 15 May 2012 01:13:14 GMT

I have an issue with a transformation not working correctly, when I look at the run log I see my two sql execute components in the wrong order. If they executed in the order it's showing then it would cause the problem I am having but wanted to confirm that log is always in the order executed since they have the same time.

If the order is right, any idea why second component would execute first when it is dependent on the first?

HBase read with date range in start and stop key

rajpal — Mon, 14 May 2012 23:27:01 GMT

Using PDI(4.3 preview) Big data input/output and have a HBase table with key starting as date in format yyyyMMdd. Now while reading data from HBase, is it possible to read data from 20120501 to 20120515 date range? I tried putting these in start and stop key but didn't work as expected. Also, tried regex in the start key which also didn't work. Spoon picks only the start key and stop key column entry is not making any difference. Always output is from start till current date.

Any suggestions?

Thanks,
Raj

Want to use Steel Wheels practice data - how to get it on system

dougleppard — Mon, 14 May 2012 21:19:14 GMT

We have a corporate account and I have a login. But the example steel wheels is not on it and I don't want to practice on corporate data. How do I get the steel wheel data loaded on my system to practice on it? I don’t want to have to do an install.

Transform Verification

cnv_Ben — Mon, 14 May 2012 21:14:17 GMT

When I run "verify this transformation" from within Spoon I consistently see the Remark "file specifications are not checked". What is this telling me and what, if anything, should I do to rectify this?

Thank you!
running CE 4.2.1 on Win7

MQL related question - what should be the syntax

Nick — Mon, 14 May 2012 17:38:49 GMT

Hi,
I am trying to add a condition where some fields are ANDed and then there is one condition which should be ORed.

In plain sql it would be like
WHERE
TABLEA.COLA = 23
AND TABLEA.COLB = 2012
AND (TABLEB.COLA = 20932598 OR TABLEA.COLC = 20932598)

In MQL I added it like:

AND ( [TABLEA.COLA] = 23;
[TABLEA.COLB] = 2012;
( OR ( [TABLEB.COLA] = 20932598 ;
[TABLEA.COLC] = 20932598 )
)
)

Caused by: org.pentaho.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0007 - An unknown error occurred with the formula
AND ( [TABLEA.COLA] = 23; [TABLEA.COLB] = 2012; ( OR ( [TABLEB.COLA] = 20932598; [TABLEA.COLC] = 20932598 ) ) ). See the log for details.
at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:240)
at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:414)
at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:362)
at org.pentaho.platform.plugin.services.connections.metadata.sql.SqlMetadataQueryExec.executeQuery(SqlMetadataQueryExec.java:80)

Please suggest how this can be implemented.

Thanks,
Nick

truncate not working the second time

jcstewar — Mon, 14 May 2012 14:59:47 GMT

Running against sql server 2005, I am trying to truncate a table in one execute sql component and insert from a select in the next execute sql component. The first time I run the transformation it works fine, even when there is data in the table. The next time I run it I get a primary key error...I can run the sql in a query tool over and over without issue. I have tried putting begin trans and commit, nothing seems to help. Any advice to this newbe would be appreciated.

---issue resolved, you can ignore---

How to deal with datetime with millisecond in Kettle?

tonyhong — Mon, 14 May 2012 14:58:03 GMT

I want to get the processing time for mapping(sumtransformation) with milliseconds. Does anyone have any suggestions? Thanks.

Split field with names and values

danilo.massa — Mon, 14 May 2012 14:15:20 GMT

Hello,
I have a "simple" problem ... in an excel file I have a column let us call it "metadata", inside this column there is a string that contain some "field name" followed by its values in this form:

Last value: 5;Last sum: 15;Previous value: 23 and so on

The format is quite simple in the Excel column taht I need to parse, the field name is followed by a colon and the semicolon is the fileds separator, but ... a row can contain the name/value pairs in different order and some row can contain different name/value pairs.

For example:
Last value: 5;Last sum: 15;Previous value: 23;Edited: 23/04/2012;Created: 12/12/2012
Last value: 2;Previous value: 12;Edited: 20/04/2012;Created: 07/12/2012;Last sum: 1
Previous value: 12;Edited: 20/04/2012;Created: 07/12/2012

In a few world:
- the field names are unknown
- the order is not fixed
- some fields can be present or not

I need to process this excel field and obtain a new file where the column "metadata" is correctly splitted and grouped. So if the excel metadata column contain:

Last value: 5;Last sum: 15;Previous value: 23;Edited: 23/04/2012;Created: 12/12/2012
Last value: 2;Previous value: 12;Edited: 20/04/2012;Created: 07/12/2012;Last sum: 1
Previous value: 4;Edited: 17/04/2012;Last Value:3

I need to have as result something like:

Last value: 5;Last sum: 15;Previous value: 23;Edited: 23/04/2012;Created: 12/12/2012;
Last value: 2;Last sum: 1;Previous value: 12;Edited: 20/04/2012;Created: 07/12/2012;
Last Value: 3;Last sum: ;Previous value: 4;Edited: 17/04/2012;Created: ;

i.e. all the fields in order (no matter what order) and the eventually missing field "filled" with and "empty value" or costant sring (no matter) ...

I think that the problem can be summarized as: how can I extract field and values name from a file where every row contain name/values pairs and the name is basically unknow?

Thank to everyone can suggest a solution ...

Regards
Danilo

Create job using java API

iyotov — Mon, 14 May 2012 11:50:06 GMT

Hi, can anyone tell me(or give a link with an example) how to create job by using Java API? I should add two steps to the job, first step should be "Job Scheduling(START)" and second "Transformation". Also I have to pass some parameters to the transformation. And I want to do this using java api, only the transformation is already created and saved on the file system.

OLAP4J Datasource (XMLA) against Mondrian fails

ThomasWiesner — Mon, 14 May 2012 10:11:24 GMT

Hello,

i've figured out, additional to

http://forums.pentaho.com/showthread...ith-SOAP-Fault,

that a xmla connection to Mondrian fails with a related SOAP-Fault (see attachment).

It seems to me that the olap4j datasources are not very well supported or bugy in report designer 3.9 !?

Can anybody give me some feedback, if this will be better supported in further versions of report designer !?

Kind regards, Thomas Wiesner

Attached Files

olap4J_mondrian_exception.txt (5.4 KB)

Vietnamese accent not supports

thirumurugandesinghu — Mon, 14 May 2012 08:30:42 GMT

Filter criteria.jpg

Hi everybody

I am using BI-Server 3.0. Kindly note the above Screen-shot the filter criteria SALESMAN list out words in both VIETNAMESE language format and ENGLISH language format. When I choose the word which is in English language format and runs the report It returns the Output in PDF format file. Instead of that When I choose the Vietnamese word and runs the report. It returns the result as in the below Screen-shot.

Screenshot.jpg

How to solve the above issue? Any one help me to get out of this Issue..

Thanks in Advance

Attached Images

Filter criteria.jpg (9.5 KB)
Screenshot.jpg (20.8 KB)

BI Server 3.0 Does not support Vietnamese Accent Character

Arunmadhavan — Mon, 14 May 2012 06:54:13 GMT

Hi All,

Fortunately am using BI Server 3.0 due to compulsion based on requirement. In parameter of the reports, shows some issue i.e., it works fine when using normal English words but it repeats when using the Vietnamese accent characters. For example, if parameter 'Customer Name' contains both the English and Vietnamese characters. Once we select the Customer Name contains the English word it shows the correct result. When we select the Customer Name contains the Vietnamese accent characters once again the parameter displays. The following screen shots denotes the issue

Anybody help us to resolve this issue...

Cheers
Arunmadhavan

Attached Images

Screenshot1.jpg (26.4 KB)

Same problem with conditional priority

juliee — Sun, 13 May 2012 16:41:16 GMT

Hey hi X3n0n,

I am trying to implement the same type of conditional priorities that you mention A AND (B OR C). Did you get something to work for managing this ?
Please let me know. Thanks in advance.

Regards,
Julie

Can a second parameter depend on the first one?

imontalt — Sun, 13 May 2012 10:05:52 GMT

I have two parameters in a report, both of them are based on 'Selects' from two diferent tables, and both are drop-down controls

param1: Select Distinct F1 from table Table1 -> the user will choose a value

I would need that the second parameter woul be like this:

param2: Select Distinct M1 from Table2 where M2= param1, so the second drop-down control will show only the corresponding values...

I don't know how to do this!

How to connect PDI 4.2.1 to Oracle 11G

sean — Sun, 13 May 2012 06:32:24 GMT

Hi Expert,

Could anybody tell me how to connect from pdi 4.2.1 to oracle 11g 11.2.0.3.0 (64-bit) using OCI?

Appreciated to your feedback.

Kind Regards,

Sean

Read whole unstructured text file and store it in 1 field

Perito — Sat, 12 May 2012 12:21:38 GMT

Hello,

I am trying to build a transformation that extracts information from an unstructured text file. My solution to this problem is the following:

1. Read the whole text file and store the whole content into 1 field. The file contain blank lines in the middle of the text
2. Find patterns using regexes within the content of the field
3. Fill a list of fields with the strings that match the patterns

My question is how to read the whole content of a text file and store it in only one field. Any suggestion?

Thanks!

How could remove records from destination which have already deleted from source

fariborzgolara — Sat, 12 May 2012 11:37:39 GMT

Hi
I have 2 tables : source table and destination table.
I've already inserted all of the records from source table into destination table, afterwards I've deleted some records from source table.
How could I delete that records from destination table which I've deleted from source table ?

Note: I want to do this action by Kettle.does any body could help me ?

Thanks

Combining one and many lines to an output

udamnit — Sat, 12 May 2012 11:25:13 GMT

Hello All,

I would like to know if someone could point me in the right direction, I have been playing with Spoon ETL for a short while now and just finding it impossible to figure out a solution to my problem any guidance would be appreciated;

I have attached a file provided by my electricity retailer; I would like to get the data into a workable format so I can collect the data collected on a daily basis and import to a SQL database.

the file consists of a line identifier (100, 200, 300, 900) and I would like to collate each of the lines to ensure the required data is captured on each line for this example there is one 100 line, one 200 line and many 300 lines the desired output would be that for each 300 line that the above 200 line and 100 lines is appended to the beginning of the dataline;

In Australia the filetype is standard amongst electricity retailers and file specification exists, but trying to get the data into a workable format is very difficult. the file specification is here; http://www.aemo.com.au/~/media/Files...0002%20pdf.pdf

RecordIndicator	VersionHeader	DateTime	FromParticipant	ToParticipant	RecordIndicator	NMI	NMIConfiguration	RegisterID	NMISuffix	MDMDataStreamIdentifier	MeterSerialNumber	UOM	IntervalLength	RecordIndicator	IntervalDate	IntVal1	IntVal2	IntVal3	IntVal4	IntVal5	IntVal6	IntVal7	IntVal8	IntVal9	IntVal10	IntVal11	IntVal12	IntVal13	IntVal14	IntVal15	IntVal16	IntVal17	IntVal18	IntVal19	IntVal20	IntVal21	IntVal22	IntVal23	IntVal24	IntVal25	IntVal26	IntVal27	IntVal28	IntVal29	IntVal30	IntVal31	IntVal32	IntVal33	IntVal34	IntVal35	IntVal36	IntVal37	IntVal38	IntVal39	IntVal40	IntVal41	IntVal42	IntVal43	IntVal44	IntVal45	IntVal46	IntVal47	IntVal48	IntVal49	IntVal50	IntVal51	IntVal52	IntVal53	IntVal54	IntVal55	IntVal56	IntVal57	IntVal58	IntVal59	IntVal60	IntVal61	IntVal62	IntVal63	IntVal64	IntVal65	IntVal66	IntVal67	IntVal68	IntVal69	IntVal70	IntVal71	IntVal72	IntVal73	IntVal74	IntVal75	IntVal76	IntVal77	IntVal78	IntVal79	IntVal80	IntVal81	IntVal82	IntVal83	IntVal84	IntVal85	IntVal86	IntVal87	IntVal88	IntVal89	IntVal90	IntVal91	IntVal92	IntVal93	IntVal94	IntVal95	IntVal96	QualityMethod	ReasonCode	ReasonDescription	UpdateDateTime	MSATSLoadDateTime
100	NEM12	2.01E+11	ABCMP	RETAILER	200	ABC1234567	E1K1Q1	1	E1	N1	1583	KWH	15	300	20070801	1558.712	1534.083	1508.636	1177.353	1113.294	1356.493	1446.134	1494.883	1402.962	1372.989	1432.878	1413.578	1522.154	1541.171	1528.717	1539.835	1540.979	1561.351	1453.379	1407.185	1413.5	1474.688	1451.26	1494.023	1530.999	1570.418	1559.591	1536.3	1491.417	1491.112	1514.988	1550.184	1525.674	1550.861	1557.186	1558.83	1559.805	1547.316	1569.184	1553.132	1558.719	1545.424	1543.384	1543.831	1544.61	1472.09	1494.821	1516.02	1570.395	1570.447	1570.935	1548.487	1529.651	1485.687	1490.034	1498.028	1542.346	1524.653	1541.562	1514.451	1519.4	1526.201	1548.342	1464.92	1361.833	1435.802	1416.961	1431.579	1489.341	1392.169	1505.813	1504.755	1479.057	1489.257	1391.421	1462.786	1544.082	1588.363	1650.675	1588.085	1644.887	1685.703	1721.565	1596.902	1598.841	1591.782	1189.614	1093.649	1029.607	988.671	1022.096	1028.525	1021.246	1006.829	1060.068	981.843	A			2.01E+13	2.01E+13

Any guidance would be appreciated, if you can point me to any examples that would be great.

Attached Files

Nem12.zip (47.5 KB)

stripping a URL from a field

joe0855 — Sat, 12 May 2012 10:29:22 GMT

Hello all,

What is the best way to strip away the URL from the following text field (single quotes not included):

'Get 10% off your entire order! Coupon code: SAT10. Click here!'

Using the above example, I only want to keep ''

In advance, thanks!

Joe

"Custom" cross validation

R_Rossi — Sat, 12 May 2012 10:22:17 GMT

Is there anyway to generate a "custom" cross validation? I need to create folds that contain certain records (not random as the traditional CV), so for example in 5-fold CV:
Fold 1: Records that have "001" as ZIP Code
Fold 2: Records that have "002" as ZIP Code
....

Is this possible? Maybe using Knowledge Flow?
If not, is there a method to obtain the same results (so the same Accuracy values and ROC curves) repeating evaluation with custom dataset that I could create?

trim white spaces not working

helioshimojo — Fri, 11 May 2012 21:26:05 GMT

There is "trim type" in text file input step. Is that supposed to remove white spaces?
I´ve tried both, left and right and none seem to work.

I have these results:

"00 "
"11 "
"23 "
"44 "

I want to remove these white spaces. How can I do this?
I don´t understand how that happens, because I have a field with same type, format and length specs and works right:

"12"
"123"
"1234"
"12345"

Issue trying to connect to database repo using JDBC - PDI4.3.0

tnewman — Fri, 11 May 2012 18:44:46 GMT

Enterprise Registry Creation - Connection Error

fanner71 — Fri, 11 May 2012 17:57:22 GMT

Below error when trying to connect to Enterprise Repository:

org.pentaho.di.core.exception.KettleException:
com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: Unauthorized
The server sent HTTP status code 401: Unauthorized

at org.pentaho.di.repository.pur.PurRepository.connect(SourceFile:337)
at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:251)
at org.pentaho.di.ui.repository.controllers.RepositoriesController$3.run(RepositoriesController.java:215)
at java.lang.Thread.run(Unknown Source)
Caused by: com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: Unauthorized
at com.sun.xml.ws.transport.http.client.HttpTransportPipe.checkStatusCode(HttpTransportPipe.java:222)
at com.sun.xml.ws.transport.http.client.HttpTransportPipe.process(HttpTransportPipe.java:179)
at com.sun.xml.ws.transport.http.client.HttpTransportPipe.processRequest(HttpTransportPipe.java:93)
at com.sun.xml.ws.transport.DeferredTransportPipe.processRequest(DeferredTransportPipe.java:105)
at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:629)
at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:588)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:573)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:470)
at com.sun.xml.ws.client.Stub.process(Stub.java:319)
at com.sun.xml.ws.client.sei.SEIStub.doProcess(SEIStub.java:157)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:109)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89)
at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:140)
at $Proxy45.sync(Unknown Source)
at org.pentaho.di.repository.pur.PurRepository.connect(SourceFile:294)
... 3 more

Need a single column from a CSV

cajames — Fri, 11 May 2012 16:33:04 GMT

I am currently stuck working on a transform that will read in a CSV from a folder. I need to get profile_id field from this file, but will be unable to know what other fields the CSV will contain as it is a report that will be generated by other people. This job will be running every 3 min to create email list from my data warehouse, with the source CSV is being generated from MicroStrategy.

How can I read in the file and only receive the profile_id field if I don't know that the field order is or what other fields will be present?

Thanks in advance

confused about drilldowns on cde

fatbob — Fri, 11 May 2012 16:33:02 GMT

Help? Ive been stuck on this all day. I cant get my head around why its not working. Im new to cde and am trying to make a bar chart that when a bar is clicked on opens another bar chart, preferably in the same window although for simplifying things, a different window is ok to begin with... I think theres something wrong with either the parameters or the click action code...

I created 2 rows in the cde layout. The first bar chart works fine. For the second one, my sql query looks like this

select stat,percent from table1
where sname = ${Sname}

I then, on the data sources screen, clicked parameters and entered Arg0: Sname Val0: NameA Type0: String
Then on Components I add Simple parameter, Name Sname Property value NameA
Next on the bar chart component for the 2nd chart I set listener to Sname and click parameters then put Arg0: Sname Val0: Sname (and do the other bits - width, height etc)
Last step I go to the 1st chart and set clickable to True and Click Action code is like this:-

function (s){

Dashboards.fireChange('Sname',s);
}

When i run the preview, both charts show as the 2nd is using the default value i set which was NameA but when I click anything on the top chart, the 2nd one says no data found.

Being new, I am confused and not sure what I have done wrong?
Bit more info, both bar charts use different sql data sources but the same database table.

If anyone understands my description can they offer some help please? :confused:

Need an example for "Add filenames to result"

wlstolzus — Fri, 11 May 2012 15:52:22 GMT

I am trying to build a job that processes a list of files. The files can be found using a file mask.
However, I want to process the files one at a time, possibly in a specific order.

It looks like the "Add filenames to result" widget would be perfect to gather the list of
files, so I don't have to know in advance how many files there are.

But I can't figure out how to use the results of this step. And I can't find any examples, either.

Is there an example in the sample files I can look at? Or does someone have an example?

Werner

Spoon transformation logging

cnv_Ben — Fri, 11 May 2012 15:34:19 GMT

I am working with a KTR which sources a series of text files, refortmats/transforms as necessary, and loads the results to a DB Table. To enable the KTR to function "cleanly", I added a "Write to Log" Step after the DB Table in an effort to capture any DB errors -usually Primary key violations. This is working correctly as far as viewing the errors in the Spoon logging window but is this information recorded anywhere? The Write to log Step includes a Write to log parameter where I specified a location and file name. I expected this to write the transform results to this file but that is not the case.

Is Write to log the correct way to capture the Transform activity? Is "Text file output" a better way of doing this? Should I configure logging of the Transform itself from within the calling Job?

Thank you for your help!
Ben

sort rows and unique

dnrickner — Fri, 11 May 2012 15:24:03 GMT

I'm trying to use a Sort rows step to only keep unique rows. It works fine until I change the number of copies to start, say 2. In that scenario, my duplicate rows all pass through it. Is this a bug or a feature limitation? I'm guessing it has to do with distributing the rows to the number of copies you specify.

Steps execution profile for advanced optimization

lorenzo-s — Fri, 11 May 2012 15:17:45 GMT

Hi. I can't find something in Kettle that can give me more information about a tranformation execution than "Step metrics" panel.
I have a transformation involving multiple sources (DB, CSV) for lookups, very fast transformations (formulas, add constants, etc) and very low ones (Javascript with very complex code).
I know steps are executed in parallel, but I want to know the timestamp each step "see" the first input row and the timestamp each step "deliver" the last output row. Is that possibile? I have to "discover" bottlenecks and quantify their criticality...

JNDI for classic report engine

kaushiks — Fri, 11 May 2012 14:03:12 GMT

I'm developing a Java web application running on tomcat. I'v integrated a report using Pentaho Report SDK 3.8, the report displays fine with JDBC configuration, but how do we configure it using JNDI? It works fine with JNDI data source in PRD. But in report engine I get the following exception:-

Code:

 ParentException: java.lang.UnsupportedOperationException: Not supported by BasicDataSource

    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1062)

    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.JndiConnectionProvider.createConnection(JndiConnectionProvider.java:142)

    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:184)

    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:239)

    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)

    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)

    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:421)

    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:183)

    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:130)

    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)

    at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)

    at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performSubReportQuery(DefaultFlowController.java:260)

    at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForSubreport(ProcessState.java:444)

    at org.pentaho.reporting.engine.classic.core.states.process.InlineSubreportProcessor.process(InlineSubreportProcessor.java:130)

    at org.pentaho.reporting.engine.classic.core.states.process.EndGroupHandler.commit(EndGroupHandler.java:52)

    at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.commit(ProcessState.java:831)

    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processPrepareLevels(AbstractReportProcessor.java:427)

    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.performStructuralPreprocessing(AbstractReportProcessor.java:594)

    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:496)

    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1522)

    at com.ReportServlet.execute(RepSe.java:97)

    at com.ReportServlet.doGet(RepSe.java:49)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

    at java.lang.Thread.run(Thread.java:679)

I added the following resource to context.xml file of tomcat

Code:


name="jndiname" password="pass" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/db" username="root"/>

Pentaho installation with postgres and Windows

conrado — Fri, 11 May 2012 12:56:22 GMT

Hi,

I have some problems with pentaho installation. When i try to access to http://localhost:8080/pentaho the following error occurs:

14:47:31,032 ERROR [Logger] Error: Pentaho
14:47:31,032 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0014 - Error mientras se intentaba ejecutar la secuencia de arranque por org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener
org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error mientras se intentaba ejecutar la secuencia de arranque por org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:350)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:291)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:208)
at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:137)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.pentaho.platform.repository.hibernate.HibernateUtil
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.internalGetRootFolder(DbBasedSolutionRepository.java:968)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.init(DbBasedSolutionRepository.java:112)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.(DbBasedSolutionRepository.java:97)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.instanceClass(AbstractSpringPentahoObjectFactory.java:78)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:117)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:72)
at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:557)
at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:533)
at org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener.loadMondrianProperties(MondrianSystemListener.java:60)
at org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener.startup(MondrianSystemListener.java:46)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:342)
... 28 more

The version is "biserver-ce-4.5.0-stable"
Can anyone help me?
Tanks os much

Problemas no Pentaho 3.10 - PacService.ERROR_0023 - BD POSTGRESQL 8.2.9

Orlando — Fri, 11 May 2012 12:24:31 GMT

Amigos estou com o seguinte problema na instalação do Pentaho 3.10 no Windows XP

Faço a instalação do Java 7, adiciono as variaveis Java_Home / PATCH / CLASSPATCH

Insta-lo o POSTGRESQL 8.2.9 - verifico se esta conectando com o DB pelo pgMANANGER III

Copio os arquivos para pasta *jar para pasata Java/jre/lib/ext

Insta-lo o PENTAHO 3.10 - rodo o start-pentaho.bat, funciona 100%

Mas quando vou na administração do PENTAHO start-pac ocorre o seguinte erro:

Connection refused: connect

Unable to refresh database connection list: PacService.ERROR_0023 - Failed to
get a Data Source: Cannot open connection

Unable to refresh security information: The call failed on the server; see
server log for details

Vi varios pedidos de ajuda nos outros foruns, mas sem uma resposta para tal erro.

Fico no aguardo de dicas para solucionar tal problema...

at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:367)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:285)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:835)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:638)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:202)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:226)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
... 34 more
Caused by: java.sql.SQLException: socket creation error
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnectio
n(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 39 more
08:12:51,421 INFO [UpdateChecker] New update(s) found: 2.4.7 [http://www.terracotta.org/confluence...ache+Core+2.4]. Please chec
k http://ehcache.org for the latest version.
08:12:52,107 WARN [JDBCExceptionReporter] SQL Error: -80, SQLState: 08000
08:12:52,107 ERROR [JDBCExceptionReporter] socket creation error
08:12:52,107 ERROR [/] Exception while dispatching incoming RPC call
com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstr
act org.pentaho.pac.common.UserRoleSecurityInfo org.pentaho.pac.client.PacServic
e.getUserRoleSecurityInfo() throws org.pentaho.pac.common.PacServiceException' t
hrew an unexpected exception: org.springframework.transaction.CannotCreateTransa
ctionException: Could not open Hibernate Session for transaction; nested excepti
on is org.hibernate.exception.JDBCConnectionException: Cannot open connection
at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:378)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:581)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:188)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:224)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:367)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:285)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:835)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:638)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:202)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:226)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate
.exception.JDBCConnectionException: Cannot open connection
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:599)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
at org.springframework.transaction.support.TransactionTemplate.execute(T
ransactionTemplate.java:125)
at org.pentaho.platform.engine.security.userroledao.hibernate.UserRoleDaoTransactionDecorator.getUsers(UserRoleDaoTransactionDecorator.java:117)
at org.pentaho.pac.server.UserRoleMgmtService.getUsers(UserRoleMgmtServi
ce.java:153)
at org.pentaho.pac.server.PacServiceImpl.getUserRoleSecurityInfo(PacServiceImpl.java:124)
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 com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:5
... 19 more
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:558)
... 29 more
Caused by: java.sql.SQLException: socket creation error
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnectio
n(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:423)
... 34 more
08:12:52,141 WARN [JDBCExceptionReporter] SQL Error: -80, SQLState: 08000
08:12:52,141 ERROR [JDBCExceptionReporter] socket creation error
08:13:14,687 INFO [HttpMethodDirector] I/O exception (java.net.ConnectException
) caught when processing request: Connection refused: connect

Internationalization/Localization issue in Pentaho Report Designer 3.8.3

karthikpai — Fri, 11 May 2012 11:44:41 GMT

Hi,

We are using BI Server 4.1 GA Enterprise Edition .

We translated all the reports in 7 different languages,and for that we used property files.
If the translation has any special character present it's not get displayed properly on Browser.
For Spanish “Informe de cÃ³digos de barras de actives” is got displayed instead of “Informe de códigos de barras de actives”
Hence, for special characters translationis inaccurate.
Please let us know if this a reported issue for pentaho? Is Pentaho unable to identify special characters?

Is any workaround possible?

Any help will be appreciated.

Thanks!

Fore_color

Abhitha — Fri, 11 May 2012 11:42:07 GMT

Hi,

Using the style and format_string we can change the background colour of the measures...How do we change the foreground colour or the font colour ?

Need a solution for this problem in Analysis report(legacy) or MDX or using XML and not in report designer.

Thanks,
Abhitha:)

How to crate report with unknown number of fields?

nafigator — Fri, 11 May 2012 09:14:09 GMT

How to create report in report designer with unknown number of fields?

How to create drill down and crosstab reports in pentaho reporting

MaheshKrishna — Fri, 11 May 2012 05:06:54 GMT

Hi all, I am new to Pentaho Rporting , I need to create a drill down report and creoss tab report can any one help me on this......:)

Specified query not executable here - pentaho reporting - BI Server

shahink — Fri, 11 May 2012 04:59:04 GMT

So i've designed a report in Pentaho Report Designer 3.9 and previewed it and ran it on my machine and everything works fine.
I have an input paramater that is a dropdown list and gets its values from a query called Vertical-List.
Now the drop down works on my machine. However, when i publish the report to the Online interface and try to access it, I get a message that says *The Specified query "Vertical-List" is not executable here * i dont know what that means and what to do. It worked this morning and suddenly it stopped working.
Please help a brother out.

Weka 3.6.7 and 3.7.6 releases

Mark — Fri, 11 May 2012 02:49:59 GMT

Hi everyone!

New versions of Weka are available for download from the Weka homepage:

* Weka 3.6.7 - stable book 3rd edition version. It is available as ZIP, with Win32 installer, Win32 installer incl. JRE 1.6.0_32, Win64 installer, Win64 installer incl. 64 bit JRE 1.6.0_32 and Mac OS X application.

* Weka 3.7.6 - development version. It is available as ZIP, with Win32 installer, Win32 installer incl. JRE 1.6.0_32, Win64 installer, Win64 installer incl. 64 bit JRE 1.6.0_32 and Mac OS X application.

Both versions contain a significant number of bugfixes, it is recommended to upgrade to the new versions. Stable Weka 3.6 receives bug fixes only. The development version receives bug fixes and new features.

Weka homepage:
http://www.cs.waikato.ac.nz/~ml/weka/

Pentaho data mining community documentation:
http://wiki.pentaho.com/display/Pent...+Documentation

Packages for Weka>=3.7.2 can be browsed online at:
http://weka.sourceforge.net/packageMetaData/

The Pentaho Weka micro site at http://weka.pentaho.com/ will be updated to reflect the new releases soon.

Note:
It might take a while before Sourceforge.net has propagated all the files to its mirrors.

What's new in 3.7.6?

Some highlights
---------------

In core weka:

* Weka 3.7 is now GPL 3.0.
* Weka releases now available on Maven central
* Logistic now has an option to use conjugate gradient descent rather than quasi-Newton with BFGS updates.
* weka.classifiers.bayes.NaiveBayesMultinomialText - naive Bayes multinomial classifier that operates directly on string attributes.
* Appender component for the Knowledge Flow that can append sets of instances together.
* SubstringLabeler component for the Knowledge Flow that can use substring or regex matching on string attribute values to assign various user defined nominal values to a new "label" attribute.
* SubstringReplacer component for the Knowledge Flow that can replace substrings or regex matches with user supplied strings in string attribute values.
* Sorter component for the Knowledge Flow that implements a streaming merge sort that writes a sorted in-memory buffer to a file when full. Can sort descending or ascending on multiple attributes.
* DatabaseSaver can now truncate the target table if desired.
* Area under the precision-recall curve evaluation metric.
* Package manager's cache refresh mechanism is now much faster.
* Package manager now checks for new versions of existing packages on the server as well as entirely new packages.
* Random forest now has an option to print all the ensemble trees as part of its output.

In packages:
* cascadeKMeans package - weka.clusterers.CascadeSimpleKMeans, contributed by Martin Guetlein.
* weka.classifiers.functions.RBFRegressor added to the RBFNetwork package
* jsonFieldExtractor package - Knowledge Flow step to extract one or more fields from repeating blocks of JSON text into new attributes.

As usual, for a complete list of changes refer to the changelogs.

Cheers,
The Weka Team

sort order of bar chart or Group details data

rmadou — Thu, 10 May 2012 23:12:28 GMT

Hi my fellow Pentahoers,

My question is, how can I define the sort order of the data in either a chart element or the details section of a Group element in a report.

The question is coming about because of the following situation:

I am trying to match the sort order of data in a chart with a table in the group element in a report. What is happening is the data on the chart (a stacked bar chart) is sorting the data in one direction and the details of the group element is sorting it in the opposite direction. If you look at the attached image you'll see that the lowest data element in the stacked chart (the blue HEM data) corresponds with the top of the Group details data (and with the top of the chart legend for that matter). I would love to be able to reverse either the sort order in the chart or the Group details band, or sort them both in a particular way that will line up.

Any suggestions?

chart and table example.jpg

Attached Images

chart and table example.jpg (15.9 KB)

HBase data read with contains clause in key

rajpal — Thu, 10 May 2012 19:22:56 GMT

For HBase input, does "Start Key Value for table scan" under configure query tab applies "contains" clause? For example, I have record with keys "AA-BB-CC-DD" , "AB-BB-BD-DD" and "BB-AA-CC-DD". How to configure query such that all the records with key starting with "A" could be read from HBase? Similarly, how all records whose key contains 'BB".
I tried with "A" in the start key but didn't yield the expected result.

I'm using CE 4.3 preview.

UPDATE: PDI works as I initially thought i.e. its matches the starting part of key with the string provided in "Start Key Value" field. Mistake is on my part to miss it first attempt.

Still unable to make it work with wildcard i.e reading records with matching multiple key patterns i.e. A[AB]

Thanks,

Introduce variable value as field value in a table output

rcanalytics — Thu, 10 May 2012 18:25:36 GMT

Hi, I created a transformation that extracts the system time in PST and set it in a variable called job_timestamp, with the scope of valid in JVM.

In the next transformation I want to be able use the variable ${job_timestamp} as one of the field values in a table output , some thing like this :
test_variable_insert.ktr

Basically I used the Calculator step to add a new field and set that field value to the value of the variable job_timestamp.
but I get this error :Unable to find the first argument field 'extract_timestamp for calculation #1

It looks like I cannot use a variable in a Calculator step ? How can I do something in this line to add a new field in the table output that gets its value from a variable.

Appreciate any inputs to help ! Thanks.

Attached Files

test_variable_insert.ktr (22.6 KB)

String extraction with regex

vipex — Thu, 10 May 2012 16:52:43 GMT

Hello,

I have a text field where I want to extract a specified portion of text (with regex) and put in a new field.

I've tried with "regex evaluation" and "Replace in string" but seems to not work =/

Some hint?

RegEx expression not working

wlstolzus — Thu, 10 May 2012 15:19:13 GMT

I am trying to build a simple file split process using a regular expression to determine which lines to keep and which to discard.

The regular expression is this: ^[0-9]{6}
This looks for 6 digits between 0 and 9, starting at the beginning of the line.

My text file input defines one field for the entire line, and passes this to the regex. From the regex, it goes
to a filter which uses the "result" from the regex to determine where to send the line.

When I run this, all the lines go into the "True" file, and none go into the "False" file. I have tested this regular
expression on the file, and it works there.

I have attached the transformation and a sample file, so you can see what I am trying to do.

Does anyone know why this doesn't work?

Attached Files

PullAllDataLines3.ktr (20.7 KB)
mspcashgpc2.txt (10.5 KB)

Pop up so user can set variable on the fly (job)

helioshimojo — Thu, 10 May 2012 14:48:26 GMT

It might be a silly question.

I have a job that depending on the user decision, it has different paths.
But I couldn´t find a way to ask the user (pop up) to set a variable when he runs the job.
I want to ask the user everytime he runs the job to place a value to the variable.

How can I do this?

labels not displayed in excel format

yoruichi — Thu, 10 May 2012 14:40:50 GMT

hello,

I'm using report designer.

I've created a report containing many group headers, content of groups header isn't displayed in excel format
even if visible is equals to true.

This content is visible in all other formats.

What to do so that content becomes visible with excel

thanks in advance

Problem postal code Geomap

M4rs — Thu, 10 May 2012 13:08:28 GMT

Hi all,

I wanted to have a preview of Geomap with some datas...and I get a problem.
I wanted to display some datas for some departments. For this, I used postal codes of my country.

But, instead of appear in my country, bubbles appear in the USA. I think the USA must have same postal code, but I want to display my datas in my country, and I don't know how...

If somebody could help me, it will be very nice :)

Thank you very much :)

Benjamin

Simple MDX Query against MS SASS 12 fails with SOAP-Fault

ThomasWiesner — Thu, 10 May 2012 11:51:53 GMT

Hello,

i'm working on a proof concept using pentaho report designer with an OLAP datasource connected to a MS SASS 12. The first step was trying a simple MDX Query in the datasource editor of the designer.

I've configured following datasource:

Data -> Add datasource -> OLAP -> OLAP4J

And added the following database connection:

Generic Database
Access: Native (JDBC)

Connection-URL: jdbc:xmla:Server=http://192.168.100.20/olap/msmdpump.dll;Catalog='Analysis Services Tutorial';Cube='Analysis Services Tutorial'
Custom Driver: org.olap4j.driver.xmla.XmlaOlap4jDriver
User and password are set.

The test was ok. In the datasource i added the following query:

SELECT Measures.MEMBERS ON COLUMNS FROM [Analysis Services Tutorial]

While starting the preview for this connection, i'll get the following exception (see full exception in attachments):

java.lang.RuntimeException: org.olap4j.OlapException: XMLA provider gave exception: [^]

XMLAnalysisError.0xc10f0006

XML parsing failed at line 15, column 10: Ungültiges qualifiziertes Zeichen.
.

Request was:

xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" [^]
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> [^]

SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> [^]
DISCOVER_DATASOURCES

<::PENTAHO-REPORTING::HOSTNAME>
<::PENTAHO-REPORTING::PORT>1521
<::PENTAHO-REPORTING::DATABASE-TYPE>GENERIC
<::PENTAHO-REPORTING::NAME>MS SASS
Analysis Services Tutorial
<::PENTAHO-REPORTING::DATABASE-NAME>
Data

If i try this query within a simple java class using OLAP4J with same connection parameters, i got no errors. I also figured out, that in this case the request looks like

xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" [^]
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> [^]

SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> [^]
DISCOVER_DATASOURCES

Analysis Services Tutorial
Data

It seems , that the pentaho reporting properties are not allowed !?

Has anybody a hint or a solution for this problem ?

Kind regards,

Thomas Wiesner

Attached Files

ms_sass_exception_with_pentaho.txt (10.1 KB)

сервера cs нового поколения понравится всем игрокам

useffuttAcile — Thu, 10 May 2012 10:45:53 GMT

Хотелось бы начать с того, что этот форум читал давно и вот решил зарегистрироваться. Спасибо администраторам этого сайта, за то что он всегда настолько всем интересен. И всем юзерам данного проекта оценить сервера CS и сайт нового поколенения, посвещённый этой захватывающей игре. Там работает хорошая команда специалистов, которая поддерживает сайт на высшем уровне качества. Постоянный онлайн и множество положительных эмоций. Если интересно можете перейти по одной из кнопок: новости киберспорта играть бесплатно в CS онлайн

union role

fabioroma — Thu, 10 May 2012 10:40:11 GMT

I have created two roles one which can access "SER038 - Direzione Generale" and second which can access "SER037 - Assistenza Farmaceutica Area Ospedaliera" and tried creating a union of those two roles...but it doesn't work, can anyone help me?

Write a field value in details band ONLY IF is different from previous

lorenzo-s — Thu, 10 May 2012 10:23:49 GMT

Hi everyone. My report looks like:

Code:

John Doe | Area one |  23

John Doe | Area two | 678

Jack Til | Area one |  12

Jack Til | Area two | 567

Is it possible to display the same data, but hiding names when equal to previous row, ie:

Code:

John Doe | Area one |  23

         | Area two | 678

Jack Til | Area one |  12

         | Area two | 567

Hooking php script out from prd?

cunk111 — Thu, 10 May 2012 08:52:13 GMT

Hi everyone,

Hello, I've looked for Pentaho Report Designer hook possibilities but without much success and my English skills are reaching their limits.
I'd like to hook a PHP script triggered by the generation of a batch of monthly reports.

Could you please if it is natively feasible ?

Best regards,

pentaho BI server is running but not able to access pentaho/home from using url

cseprabhat — Thu, 10 May 2012 08:33:14 GMT

Hi All,

I am not able to access http://localhost:8080/pentaho/home from a browser. I tried after restarting pentaho but no luck. Pentaho mysql server at port 3307 was not starting.

here is a log from ../pentaho/mysql/data/mysqld.log file

120510 12:27:33 mysqld_safe Starting mysqld.bin daemon with databases from /usr/local/pentaho/mysql/data
120510 12:27:33 [Note] Plugin 'FEDERATED' is disabled.
^G/usr/local/pentaho/mysql/bin/mysqld.bin: Can't find file: './mysql/plugin.frm' (errno: 13)
120510 12:27:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120510 12:27:33 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120510 12:27:33 mysqld_safe mysqld from pid file /usr/local/pentaho/mysql/data/nmltradusbe06.pid ended

Any kind of help is appreciated.

Mondrian Error:Internal error: Error while instantiating dialect

lxzjsj — Thu, 10 May 2012 07:35:10 GMT

Icreatethedimension table,and configuretheSchemaconfiguration file,Mysql database,the following error,Tracking procedures to determine the access database,Idonotknowwhat the problem iscaused by :
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while instantiating dialect
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:942)
at mondrian.olap.Util.newInternal(Util.java:2261)
at mondrian.olap.Util.newError(Util.java:2277)
at mondrian.spi.impl.JdbcDialectFactory.createDialect(JdbcDialectFactory.java:132)
at mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:278)
at mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:278)
at mondrian.spi.DialectManager$CachingDialectFactory.createDialect(DialectManager.java:377)
at mondrian.spi.DialectManager$DialectManagerImpl.createDialect(DialectManager.java:237)
at mondrian.spi.DialectManager.createDialect(DialectManager.java:80)
at mondrian.rolap.RolapConnection.(RolapConnection.java:227)
at mondrian.rolap.RolapSchema.(RolapSchema.java:205)
at mondrian.rolap.RolapSchema.(RolapSchema.java:233)
at mondrian.rolap.RolapSchema.(RolapSchema.java:54)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:1094)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:900)
at mondrian.rolap.RolapConnection.(RolapConnection.java:160)
at mondrian.rolap.RolapConnection.(RolapConnection.java:90)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:524)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
at org.apache.jsp.WEB_002dINF.queries.test_jsp._jspx_meth_jp_005fmondrianQuery_005f0(test_jsp.java:129)
at org.apache.jsp.WEB_002dINF.queries.test_jsp._jspService(test_jsp.java:70)
... 36 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at mondrian.spi.impl.JdbcDialectFactory.createDialect(JdbcDialectFactory.java:124)
... 58 more
Caused by: java.util.regex.PatternSyntaxException: Unclosed group near index 22
(\\Q([^\\Q]+)\\E)

Mondrian Error:Internal error: Error while instantiating dialect

lxzjsj — Thu, 10 May 2012 07:33:32 GMT

Beginner Star Schema

Emannuel — Thu, 10 May 2012 05:47:59 GMT

Hi,

I'm using Schema Workbench 3.3.0. This is my first time doing a schema with more than one table and i just can't make this work. This is the xml file:

The fact table is adop14p and i'm using a column called "chave" to count in a measure. The dimension table is called "financeiras" and i want to make a dimension using de column called "descricao". The tables are related through the columns "financeira". The relation is one to one.

Table adop14p
columns: chave, financeira and others

Table financeiras
columns: financeira, descricao

i,m stuck and any help will be useful.

How to bind report header to report field?

nafigator — Thu, 10 May 2012 04:52:21 GMT

Hi all, I have a problem with creating report. I have wide report from sql query with grouped by horizontally data. I need add additional header to report, and set date for every 4 fields in report, like on the image. How I can do it? Thank you.

Attached Images

Безымянный.jpg (22.3 KB)

How to create multiple connections in a Schema workbench

rcanalytics — Wed, 09 May 2012 22:43:02 GMT

Hi! I using the Schema workbench to create some cubes. I created a jdbc connection say db1 and I was able to create a cube and do analysis on it.

Now I am trying to create a new jdbc connection to a different database with out losing the first connection that I already have (i.e db1) ? I dont see how I could create multiple connections in a schema workbench . Any one knows ?

Appreciate your insights ?

PDI 4.1.0 runs OK on windows7 machine - PDI 4.3.0 will not

tnewman — Wed, 09 May 2012 21:09:35 GMT

Hi,

Just downloaded latest version (CE 4.3.0). Unzipped on Linux machine (java version "1.6.0_24").

I map drive on laptop to the directory for this version and I try to run Spoon.bat. All I get is splash screen and then hangs.

I can run 4.1.0 just fine on windows using same method (map to Linux directory) and it runs fine. I have JRE7 on laptop which is what some solutions said was required. In the spoon.bat, i have increased the Xmx to 1024 - again another solution suggested but no dice.

In my "User/name" windows directory there are '.kettle' and '.pentaho' directories - Do I have to delete these to run the latest version? (and they get recreated?)

The funny thing is I had downloaded 4.4.0 (dev version ) and everything worked great - no modifications needed. I did notice it put an entry in the .pentaho/ VERCHECK file for 4.4.0 but this did not happen for 4.3.0.

Any ideas?

Stream Lookup Error - you can't use the 'integer-pair' algorithm when you ..

karlis_peterson — Wed, 09 May 2012 17:38:15 GMT

Again - newbie question. I am querying a view using a Table Input step:

SELECT
MOINSTID
, TIMERECORDED
, DISKUSAGE
, EVENTLOGERRORS
, MEMORYUSAGE
, RESOURCECONTENTION
, SYSTEMPAGING
, PROCESSORUTILIZATION
, WMIAVAILABILITY
FROM _PATROL__NT_OS_NT_HEALTH_ST_VIEW

Then the next step is a "Stream Lookup" which I have another Table input that queries another view:

SELECT
MOINSTID
, DEVICENAME
, SOURCEIP
FROM _PATROL__NT_OS_NT_HEALTH_CFG_VIEW

The Stream lookup step uses the field "MOINSTID" from the first Table Input (this is an integer), then uses the lookup field "MOINSTID" (this is also an integer) which is from the second Table input that has a hop into the Lookup Stream. So I am trying to grab the DEVICENAME from the second Table Input.

Seems very straight forward, but I get the following errors:

you can't use the 'integer-pair' algorithm when you have more than one key or value-field or value in not an integer.

Please advise. Thanks gurus!

CCC Bar chart values position not working?

fatbob — Wed, 09 May 2012 15:17:48 GMT

Hello

Im new to using the cde but Im trying to do a simple task. On a bar chart, the values are currently displaying in the centre of the bars but I want them to appear on the right. I assume the 'Values position' needs to be set to 'Right' for this? Changing this value to any of the options makes no difference to the position of the values on the bars. Is there something I am doing wrong?

As a second, slightly more complicated question is it possible to replace the values with images?

When will we get support for external stylesheets?

diddy — Wed, 09 May 2012 13:01:39 GMT

There are many posts about "Does PRD have CSS support?", external stylesheets, etc. I read the argument that PRD handles styles slightly different than CSS ... ok, fine, but why does this prevent somebody from creating a PRD version of external stylesheets as a first step? JasperReports and BIRT have their own version of external style sheets as well, so why can PRD not have it? Frankly, maintaining many reports without external stylesheets is a pain. Also, redefining the same style for every element within one report is even time consuming [yeah, I know, there is the copy format function, but it's not the same]. So, if there is no JIRA case yet [which I doubt] I am happy to create one. Please let me know.
Thanks,
Diddy

untraceable unwanted filtering of records in table output step on my pc

michieliooo — Wed, 09 May 2012 10:01:32 GMT

Hi all, I am loading data from a file (csv or xls), and some fields contain numbers with decimal places, like 0,5 (dutch format). On the input step I assign the number field type (length 3, precision 2) to it, format #.#. When I do a preview I see all rows: some containing values like 0,5 and some are 0,0. The output table writes these records to the table; the relevant field has numeric (3,2) datatype. When I run my job it shows that all records of the input files have been succesfully written to the output tabel. However the table contains only those records that contain numbers like 0,0. They show up like just '0' in the table. Here comes a weird thing: this problem only occurs on my pc. When I run the job on my collegue's pc it processes al records just fine. We both use a windows 7 SP 1 machine, and have the same regional settings for numbers etc. Why are the records with the 0,5 value skipped on my pc? ANy ideas would be greatly appreciated. Cheers Michiel

Mondrian 3.4.1, Schema Workbench and Agg Designer stable available on SourceForge

dmoran — Wed, 09 May 2012 04:36:38 GMT

Stable Builds of Mondrian, Schema Workbench and Aggregation Designer have been published on SourceForge.net and are available for download.

Please try them out, report bugs and give feedback.

Mondrian 3.4.1-stable - Download - Change Log
Schema Workbench 3.4.1-stable - Download - Change Log
Pentaho Aggregation Designer 1.4.0-stable - Download - Change Log
Release Notes - Download

Stable builds represent the final stage of development for a Community Edition (CE) release. The term stable refers to a version of software that has been through enough community testing to reasonably assume there are no showstopper problems, or at least that any problems are known and documented. If you are going to put a CE release into production, you will want to use a stable build.

CE builds are not supported by Pentaho. If you require support or enterprise features, Pentaho Enterprise Edition (EE) may be the right chioce for you. EE evaluation software may be downloaded from http://www.pentaho.com/download. Pentaho Enterprise Editions extend Pentaho's open source business intelligence (BI) capabilities with additional software and support designed to save your organization time and resources.

FYI - Also posted:
Pentaho BI Suite 4.5 Stable:
http://forums.pentaho.com/showthread.php?p=281519

Pentaho Data Integration 4.3.0 Stable:
http://forums.pentaho.com/showthread.php?p=281532

Pentaho Reporting engine and SDK 3.9.0 Stable:
http://forums.pentaho.com/showthread.php?p=281522

Doug

Jfreechart Combined chart in Report Designer

richardgear — Wed, 09 May 2012 04:09:46 GMT

Hi,

Is report designer support the combined chart that two chart share a common domain axis (x-axis)? This chart is available in Jfreechart library.

Thank you for your advice.

Reading parameter value in Chart Post-Processing Script

richardgear — Wed, 09 May 2012 03:56:58 GMT

Hi,

Can the Chart Post-Processing Script access the parameter value defined in Report Designer? If yes, how?

Thank you.

PDI/Kitchen is running...but not running???

rider555 — Wed, 09 May 2012 03:51:53 GMT

Ok...oddest thing, and I'm trying to pinpoint where the problem is.

I have several ETL jobs that need running at the end of the day. According to my set logs, everything ran like clockwork. I set the time at 1:10am. Ok right? When I come in at 9am, I check the data if the system was able to load the data. Oddest thing is that there is no data loaded. I check the logs, its all said it was loaded, but it really wasn't so I ran the ETL to load. Loads successfully, data ok.

I set the time to 4:30am and 7:30am in subsequent days. Problem remains the same. I keep loading manually. Can anyone give me an idea why this is happening? Please? Thanks.

Take note, network accesses are ok, considering I don't do any changes when I run it manually. I'm at a loss as to why this is happening.

Open Formula - issues with null values

jcags — Wed, 09 May 2012 02:13:58 GMT

I have a table which lists customers in the first column and then their sales for each month in the following columns. I have set up total sums on the bottom of the page to calculate the total of each column (ie the total sales each month). I am now trying to create a total sum that will add up the values across a row, to show the total sales for the customer for the last year. I am using the 'open formula' function, using the =SUM() expression and then filling in the fields I want summed together.

If all of the fields have a value then it adds them together as expected. However many of these fields are actually going to be empty, where there are no sales for a customer for a month. On these lines the sum returns nothing. It seems even if some fields have a value in it, if even one field is null it will not give a summed amount. I have tried setting the 'if-null' property on the fields I am summing together to 0 but it has no effect. I have also included the NVR() command in my select statement to force null values to appear as 0s. This has not worked either.

Can anyone assist with this problem?

Better Data for Better Analytics

MattCasters — Wed, 09 May 2012 01:10:28 GMT

Dear Kettle friends,
Thursday May 10th, in a few days, I’ll be joining my friend Kasper Sørensen (the founder and lead architect of DataCleaner, a Human Inference data profiling project) in our web seminar (webinar). We’ll be going over a bit of history, our cooperation model as well as the architecture behind the new data quality features.
Register here: http://www.pentaho.com/resources/eve...ter-analytics/
Kasper will also be doing 3 cool live demos on the subjects of data profiling and data quality.
I hope you’ll be able to join the crowd this Thursday May 10th, 10am PST (Los Angeles), 1pm EST (New York) or 7pm CET (Brussels).
We’ll be doing our best to answer your data quality questions simultaneously with the presentation.
See you there!
Cheers,
Matt

More...

Ayuda esquemas mondrian y MDX

lauradvf — Tue, 08 May 2012 21:45:59 GMT

Hola,

soy novata en la creación de esquemas mondrian que posteriormente voy a visualizar con Jpivot y me surgen unas dudas.

- si yo tengo una tabla de hechos con datos de varios fechas (dd-mm-aaaa), y quiere crear un esquema con los datos de una año concreto. Como la fecha va a ser una dimensión de mi cubo, ¿cómo especifico en el esquema el año concreto? ¿O es algo que debe especificar en otro fichero una vez publicado el cubo con sentencias MDX?

Muchas gracias.

Trying to bridge two tables.

concordus — Tue, 08 May 2012 21:05:34 GMT

Have three tables. Reading from 3 CSVs. Two have different information(client name and carrier code) and one has information from both client name and carrier code, plus more.

I want to put these CSVs into 3 different databases and have the third one have two foreign keys pointing to the other tables (using their auto_incremented id as the FK values).

I tried populating the three tables and doing just big UPDATE WHERE clause with SQL Script but that takes waaay to long.

Is there a step where I can just simply bridge two tables like this? Which step is it? I'm looking though the steps and can't find anything. Is using the SQL code my only option?

Thank you!

Possible BUG 3.9 PRD CDA DataSource (No lawsuits)

flamierd — Tue, 08 May 2012 21:04:07 GMT

The CDA DataSource seems to have issues with parameters when they are not strings. This particular error returns when the parameters are Numeric. When the CDA parameters are changed to "String" there is no issue.

org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: For parameter p_week_1 Expected number, but got class java.lang.String
at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaQueryBackend.parameterToString(CdaQueryBackend.java:96)
at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaQueryBackend.queryData(CdaQueryBackend.java:253)
at org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaDataFactory.queryData(CdaDataFactory.java:170)
at org.pentaho.reporting.ui.datasources.cda.CdaDataSourceEditor$CdaPreviewWorker.run(CdaDataSourceEditor.java:254)
at java.lang.Thread.run(Unknown Source)

File Exists step

cnv_Ben — Tue, 08 May 2012 21:00:37 GMT

I have a working KTR which uses Get file names to read in a series of Source files and passes the results to a File exists step. I attached both a Copy rows to result and Abort step to File exists so, if no files are found, my KTR terminates gracefully rather than fails. Is there a way to have the Abort stream write some message to a "dedicated" log file, or send an e-mail message? I have included text in the "Abort message" field but would rather have a specific "no files found" log, if possible.

Thank you!
~Ben

Looking for TimeSeriesForecasting plugin source

Bob Cotton — Tue, 08 May 2012 20:59:10 GMT

I would like to make some modifications to the TimeSeriesForecasting source. Can someone point me to the source repo? I've found the maven repos (with source) but I also need build tool artifacts.

Thanks
- Bob