Pages

Google Ads

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:

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!

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

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.

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.


#
###,###,###
$#,###
$#,##0.00

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.

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.

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