Learn more:
Wednesday, September 04, 2013
2013 Pentaho Community Meeting - Sintra - Portugal
Java Decompiler Plugin For Eclipse IDE
To decompile Java class in Eclipse IDE, you can download “Java Decompiler (Jad) Eclipse plugin“. With this plugin enabled in Eclipse IDE, when you click on any Java classes or F3 trace into the class, the plugin will decompile it automatically.
Learn more about it at:
http://www.mkyong.com/java/java-decompiler-plugin-for-eclipse/
Learn more about it at:
http://www.mkyong.com/java/java-decompiler-plugin-for-eclipse/
Marcadores:
Java Decompiler Plugin For Eclipse IDE
Saturday, August 17, 2013
Mac Tip: Force empty the Trash
Hi guys,
If you are having problems trying to clean up your Trash on Mac even when you are using the "force" you need to know this tip.
I tried a lot of times without success to clean up my Trash using the command line below:
MacBook-Air-de-Caio:~ caiomsouza$ sudo rm -rf ~/.Trash/*
After trying a lot, I discovery that if you press the Option button while you clean up the trash it will work and it will clean up bin files and others.
I found this tip in this website here.
The original text:
If you are having problems trying to clean up your Trash on Mac even when you are using the "force" you need to know this tip.
I tried a lot of times without success to clean up my Trash using the command line below:
MacBook-Air-de-Caio:~ caiomsouza$ sudo rm -rf ~/.Trash/*
After trying a lot, I discovery that if you press the Option button while you clean up the trash it will work and it will clean up bin files and others.
I found this tip in this website here.
The original text:
Sometimes the Trash on your Mac won't empty - even when you tell it to. Ever since Idragged and dropped a bunch of leftover Windows system files into my Mac's Trash bin, no matter how many times I tried to empty it, there those trashed files stayed, staring at me in defiance.
Luckily, The X Lab site offers a few options for force-emptying the Mac's Trash. Being acommand line gal, I used the old
rm -rf ~/.Trash/* technique in Terminal, but apparently holding down the Option key while emptying does the trick too. Here's to empty trash bins!
Marcadores:
Mac Tip: Force empty the Trash
Monday, August 12, 2013
Pentaho na Prática - Livro de Pentaho em Português (Completo)
Amigos,
O livro está finalizado desde Agosto de 2013.
Agora é comprar e se divertir.

Compra agora:
http://www.amazon.com.br/Pentaho-na-Pr%C3%A1tica-ebook/dp/B00CEQFDU0
O livro está finalizado desde Agosto de 2013.
Agora é comprar e se divertir.

Compra agora:
http://www.amazon.com.br/Pentaho-na-Pr%C3%A1tica-ebook/dp/B00CEQFDU0
Feliz Aniversário. São 7 anos do Blog.ProfessorCoruja.com
Amigo leitor,
Se meu blog fosse o meu filho ele estaria super triste comigo, mas felizmente ele é apenas um blog.
Esse ano eu esqueci do aniversário do Blog Professor Coruja, mas ainda em tempo vou comemorar escrevendo esse post especial.
O pior de tudo é que ano passado eu não lembrei e muito menos comemorei essa data tão importante.
A data do aniversário de 7 anos do blog é o dia 3 de Agosto de 2013, então hoje ele está com 7 anos e 9 dias, parece ontem quando eu começei a escrever e já se foram 7 anos, incrível como o tempo passa rápido.
Muito obrigado por fazer parte da história do Blog.ProfessorCoruja.com.
Se meu blog fosse o meu filho ele estaria super triste comigo, mas felizmente ele é apenas um blog.
Esse ano eu esqueci do aniversário do Blog Professor Coruja, mas ainda em tempo vou comemorar escrevendo esse post especial.
O pior de tudo é que ano passado eu não lembrei e muito menos comemorei essa data tão importante.
A data do aniversário de 7 anos do blog é o dia 3 de Agosto de 2013, então hoje ele está com 7 anos e 9 dias, parece ontem quando eu começei a escrever e já se foram 7 anos, incrível como o tempo passa rápido.
Muito obrigado por fazer parte da história do Blog.ProfessorCoruja.com.
Marcadores:
7 anos de blog
Examples of Format String @ Pentaho BI Suite
Hi Pentaho folks,
When you are creating an OLAP Cube you need to create a measure and define a Format String.
Below there are some examples.
When you are creating an OLAP Cube you need to create a measure and define a Format String.
Below there are some examples.
####,###,###$#,###$#,##0.00
Marcadores:
Format String
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = text
Hi Pentaho folks,
When I am teaching Pentaho to my students they always forget to put the primary key in the hierarchy and they error below will occur.
Like the example below:
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "dim_convenente"."convenente" as "c0", sum("fato_convenios_siconv"."m_valor_convenio") as "m0" from "dw"."dim_convenente" as "dim_convenente", "dw"."fato_convenios_siconv" as "fato_convenios_siconv" where "fato_convenios_siconv"."sk_convenente" = "dim_convenente"."convenente" group by "dim_convenente"."convenente"]
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.rolap.SqlStatement.handle(SqlStatement.java:336)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:236)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:318)
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:555)
at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:187)
at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:48)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:155)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:129)
... 5 more
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = text
Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Posição: 253
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)
How to solve it.
Put the primary key in the hierarchy.
When I am teaching Pentaho to my students they always forget to put the primary key in the hierarchy and they error below will occur.
Like the example below:
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "dim_convenente"."convenente" as "c0", sum("fato_convenios_siconv"."m_valor_convenio") as "m0" from "dw"."dim_convenente" as "dim_convenente", "dw"."fato_convenios_siconv" as "fato_convenios_siconv" where "fato_convenios_siconv"."sk_convenente" = "dim_convenente"."convenente" group by "dim_convenente"."convenente"]
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.rolap.SqlStatement.handle(SqlStatement.java:336)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:236)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:318)
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:555)
at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:187)
at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:48)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:155)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:129)
... 5 more
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = text
Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Posição: 253
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)
How to solve it.
Put the primary key in the hierarchy.
Marcadores:
Pentaho Errors
Caused by: java.lang.ClassNotFoundException: javassist.bytecode.ClassFile
Hi Pentaho Folks,
Last week when I executed ./workbench.sh on my Mac I've got this error:
Caused by: java.lang.ClassNotFoundException: javassist.bytecode.ClassFile
It also occurs in Linux Ubuntu.
MacBook-Air-de-Caio:schema-workbench caiomsouza$ ./workbench.sh
/Applications/Pentaho/psw-ce-3.5.0/schema-workbench
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
17:09:41,822 ERROR [Workbench] main
java.lang.NoClassDefFoundError: javassist/bytecode/ClassFile
at org.scannotation.AnnotationDB.scanClass(AnnotationDB.java:311)
at org.scannotation.AnnotationDB.scanArchives(AnnotationDB.java:294)
at org.pentaho.di.core.plugins.BasePluginType.findAnnotatedClassFiles(BasePluginType.java:238)
at org.pentaho.di.core.plugins.BasePluginType.registerPluginJars(BasePluginType.java:500)
at org.pentaho.di.core.plugins.BasePluginType.searchPlugins(BasePluginType.java:115)
at org.pentaho.di.core.plugins.PluginRegistry.init(PluginRegistry.java:420)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:121)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:68)
at mondrian.gui.Workbench.getDbMeta(Workbench.java:1225)
at mondrian.gui.Workbench.loadDatabaseMeta(Workbench.java:193)
at mondrian.gui.Workbench.(Workbench.java:132)
at mondrian.gui.Workbench.main(Workbench.java:2094)
Caused by: java.lang.ClassNotFoundException: javassist.bytecode.ClassFile
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 12 more
How to solve it:
I edited workbench.sh and add the line below:
CP="${CP}${PS}${MONDRIAN_HOME}/lib/javassist.jar"
I also put the javassist.jar on psw-ce-3.5.0/schema-workbench/lib
After that, It worked fine.
If you find a better way to solve it, please let me know it.
Last week when I executed ./workbench.sh on my Mac I've got this error:
Caused by: java.lang.ClassNotFoundException: javassist.bytecode.ClassFile
It also occurs in Linux Ubuntu.
MacBook-Air-de-Caio:schema-workbench caiomsouza$ ./workbench.sh
/Applications/Pentaho/psw-ce-3.5.0/schema-workbench
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
17:09:41,822 ERROR [Workbench] main
java.lang.NoClassDefFoundError: javassist/bytecode/ClassFile
at org.scannotation.AnnotationDB.scanClass(AnnotationDB.java:311)
at org.scannotation.AnnotationDB.scanArchives(AnnotationDB.java:294)
at org.pentaho.di.core.plugins.BasePluginType.findAnnotatedClassFiles(BasePluginType.java:238)
at org.pentaho.di.core.plugins.BasePluginType.registerPluginJars(BasePluginType.java:500)
at org.pentaho.di.core.plugins.BasePluginType.searchPlugins(BasePluginType.java:115)
at org.pentaho.di.core.plugins.PluginRegistry.init(PluginRegistry.java:420)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:121)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:68)
at mondrian.gui.Workbench.getDbMeta(Workbench.java:1225)
at mondrian.gui.Workbench.loadDatabaseMeta(Workbench.java:193)
at mondrian.gui.Workbench.
at mondrian.gui.Workbench.main(Workbench.java:2094)
Caused by: java.lang.ClassNotFoundException: javassist.bytecode.ClassFile
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 12 more
How to solve it:
I edited workbench.sh and add the line below:
CP="${CP}${PS}${MONDRIAN_HOME}/lib/javassist.jar"
I also put the javassist.jar on psw-ce-3.5.0/schema-workbench/lib
After that, It worked fine.
If you find a better way to solve it, please let me know it.
Caused by: java.lang.ClassNotFoundException: org.scannotation.AnnotationDB
Hi Pentaho Folks,
Last week when I executed ./workbench.sh on my Mac I've got this error:
Caused by: java.lang.ClassNotFoundException: org.scannotation.AnnotationDB
It also occurs in Linux Ubuntu.
MacBook-Air-de-Caio:schema-workbench caiomsouza$ ./workbench.sh
/Applications/Pentaho/psw-ce-3.5.0/schema-workbench
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
17:08:48,928 ERROR [Workbench] main
java.lang.NoClassDefFoundError: org/scannotation/AnnotationDB
at org.pentaho.di.core.plugins.BasePluginType.findAnnotatedClassFiles(BasePluginType.java:237)
at org.pentaho.di.core.plugins.BasePluginType.registerPluginJars(BasePluginType.java:500)
at org.pentaho.di.core.plugins.BasePluginType.searchPlugins(BasePluginType.java:115)
at org.pentaho.di.core.plugins.PluginRegistry.init(PluginRegistry.java:420)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:121)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:68)
at mondrian.gui.Workbench.getDbMeta(Workbench.java:1225)
at mondrian.gui.Workbench.loadDatabaseMeta(Workbench.java:193)
at mondrian.gui.Workbench.(Workbench.java:132)
at mondrian.gui.Workbench.main(Workbench.java:2094)
Caused by: java.lang.ClassNotFoundException: org.scannotation.AnnotationDB
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 10 more
How to solve it:
I edited workbench.sh and add the line below:
CP="${CP}${PS}${MONDRIAN_HOME}/lib/scannotation-1.0.2.jar"
I also put the scannotation-1.0.2.jar on psw-ce-3.5.0/schema-workbench/lib
Last week when I executed ./workbench.sh on my Mac I've got this error:
Caused by: java.lang.ClassNotFoundException: org.scannotation.AnnotationDB
It also occurs in Linux Ubuntu.
MacBook-Air-de-Caio:schema-workbench caiomsouza$ ./workbench.sh
/Applications/Pentaho/psw-ce-3.5.0/schema-workbench
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
17:08:48,928 ERROR [Workbench] main
java.lang.NoClassDefFoundError: org/scannotation/AnnotationDB
at org.pentaho.di.core.plugins.BasePluginType.findAnnotatedClassFiles(BasePluginType.java:237)
at org.pentaho.di.core.plugins.BasePluginType.registerPluginJars(BasePluginType.java:500)
at org.pentaho.di.core.plugins.BasePluginType.searchPlugins(BasePluginType.java:115)
at org.pentaho.di.core.plugins.PluginRegistry.init(PluginRegistry.java:420)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:121)
at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:68)
at mondrian.gui.Workbench.getDbMeta(Workbench.java:1225)
at mondrian.gui.Workbench.loadDatabaseMeta(Workbench.java:193)
at mondrian.gui.Workbench.
at mondrian.gui.Workbench.main(Workbench.java:2094)
Caused by: java.lang.ClassNotFoundException: org.scannotation.AnnotationDB
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
... 10 more
How to solve it:
I edited workbench.sh and add the line below:
CP="${CP}${PS}${MONDRIAN_HOME}/lib/scannotation-1.0.2.jar"
I also put the scannotation-1.0.2.jar on psw-ce-3.5.0/schema-workbench/lib
Subscribe to:
Posts (Atom)
