it4biz / pentaho-performance-monitoring Goto Github PK

Hi, I want to install this plugin manually as no connectivity with the internet. Can you enlist the steps to install manually?

I'm getting plugin running ok in my server but SQL queries are not parsed correctly since they have line breaks. i.e:

2015-06-22 12:22:02,293 #0: SqlTupleReader.readTuples [[Brand.Default].[Brand]]: executing sql [select
"D_Brand"."BookingSystem" as "c0"
from
"dbo"."D_Brand" as "D_Brand"
order by
....

Hi,

When i open this plugin pentaho gives this errors:
Error processing component (barTopSlowSQLQueriesComponent)
Error processing component (barTopFastSQLQueriesComponent)
And don't show anything!

My Pentaho server has no internet access, therefore no access to the marketplace. I downloaded the package manually from http://www.pentaho.com/marketplace/ and installed. Filled out the form, and there was an error, saying to contact it4biz.

Pentaho Server is running on a linux machine.

We have to create better docs and videos about the plugin.

It was an idea by Everton Roberto Denuncio at Pentaho Day 2015.

Contact:
Everton Roberto Denuncio
e-mail : [email protected]
twitter: @evertondenuncio

Criar sistema de envio de email agradecendo pela instalação realizada.

When the log is write fast the sequence of rows is lost.

"DIM_TIME"."MONTH_NAME" as "c2", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "DIM_TIME" as "DIM_TIME", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:26,777 #48: Segment.load: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "DIM_TIME"."YEAR_ID" as "c1", "DIM_TIME"."QTR_NAME" as "c2", "DIM_TIME"."MONTH_NAME" as "c3", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT", "DIM_TIME" as "DIM_TIME" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" and "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "CUSTOMER_W_TER"."TERRITORY", "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:26,778 #49: Segment.load: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "CUSTOMER_W_TER"."CUSTOMERNAME" as "c1", "DIM_TIME"."YEAR_ID" as "c2", "DIM_TIME"."QTR_NAME" as "c3", "DIM_TIME"."MONTH_NAME" as "c4", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT", "DIM_TIME" as "DIM_TIME" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" and "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "CUSTOMER_W_TER"."TERRITORY", "CUSTOMER_W_TER"."CUSTOMERNAME", "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:26,986 #48: , exec 208 ms
2015-01-20 16:38:27,224 #50: Segment.load: executing sql [select "CUSTOMER_W_TER"."CUSTOMERNAME" as "c0", "DIM_TIME"."YEAR_ID" as "c1", "DIM_TIME"."QTR_NAME" as "c2", "DIM_TIME"."MONTH_NAME" as "c3", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT", "DIM_TIME" as "DIM_TIME" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" and "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "CUSTOMER_W_TER"."CUSTOMERNAME", "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:27,224 #48: , exec+fetch 447 ms, 7 rows
2015-01-20 16:38:27,243 #47: , exec 448 ms
2015-01-20 16:38:27,243 #49: , exec 464 ms
2015-01-20 16:38:27,371 #50: , exec 146 ms
2015-01-20 16:38:27,371 #49: , exec+fetch 592 ms, 14 rows
2015-01-20 16:38:27,372 #47: , exec+fetch 596 ms, 3 rows
2015-01-20 16:38:27,372 #50: , exec+fetch 147 ms, 14 rows

Hola Rafael,

Que tal? Como puedo cojer los datos de garbage collector do Tomcat Pentaho?

Otra cosas, donde Saiku genera el log de quien has ejecutado una consulta? Quien has descargado, etc? Te acuerdas que tu has dicho que si el tiene y no hace falta utilizar el plugin de mi amigo.

Que mas te parece necesario monitorar con los plugins que hemos hecho?

Un saludo,

Caio

Hi,

I installed your two plugins , and I see the same information do you find getting modifying the log4j .
I've seen etls where do you find the information , and I have not gotten to see how to get the user.
After talking with Caio , we have seen that these data do not currently exist , and it would be a good improvement for the plugin .
The question is , how can we get this data for inclusion in the plugin?

Thanks,
Regards

There is no option to select United States during registration.

Endpoint: _jobCopyAndClearLogs
Step: Clear log Windows
Error: The path not working and the file is blocked by OS

hey this is a good product but i don't konw why it's donse't work
we use linus here is the log

I've installed Pentaho Performance Monitoring on Pentaho 5.0.1 CE server (Windows 2012 Server).
Installation runs ok and registration seems to be correct but when I start the plugin (after BAServer restart) and refresh data it hangs on loading screen.