David Christiansen davidray
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Writing metadata for disease group 'TriSano' to /opt/installs/current/trisano-pentaho/biserver-ee/pentaho-solutions/TriSano/metadata_storage/dg9_metadata.xmi | |
| INFO 21-04 14:27:40,117 - CWM - Instantiated Pentaho (top level) package. | |
| Writing out new XMI file /opt/installs/current/trisano-pentaho/biserver-ee/pentaho-solutions/TriSano/metadata_storage/dg9_metadata.out | |
| INFO 21-04 14:27:48,706 - CWM - Instantiated Pentaho (top level) package. | |
| 2010/04/21 14:28:30:877 EDT [ERROR] PublisherUtil - null <java.lang.NumberFormatException: For input string: "<html> | |
| <head> | |
| <title>Error Initializing Pentaho</title> | |
| </head> | |
| <body bgcolor="white" dir="LTR"> |
davidray
/ gist:365995
Created
April 14, 2010 16:07
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| david@freshy:/opt/installs/warehouse$ sudo su postgres | |
| postgres@freshy:/opt/installs/warehouse$ psql -Xf warehouse_init.sql -U trisano_su trisano_warehouse | |
| BEGIN | |
| CREATE SCHEMA | |
| ALTER SCHEMA | |
| COMMIT | |
| BEGIN | |
| CREATE SCHEMA | |
| ALTER SCHEMA | |
| COMMIT |
davidray
/ gist:364704
Created
April 13, 2010 14:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| echo "===========================================" >> /root/refresh-log | |
| date >> /root/refresh-log | |
| echo "===========================================" >> /root/refresh-log | |
| cd /opt/csi/trisano-dw/warehouse | |
| ./etl.sh >> /root/refresh-log | |
| cd /opt/csi/trisano-pentaho/biserver-ee/pentaho-solutions/TriSano | |
| ./build_metadata.sh >> /root/refresh-log |
davidray
/ gist:356792
Created
April 5, 2010 20:03
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 16:05:30,724 ERROR [MondrianModel] Parse Failure | |
| mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' | |
| select NON EMPTY {[Measures].[Count]} ON columns, NON EMPTY {([Gender.Gender].[All Genders], [Ethnicity.Ethnicity].[All Ethnicities], [Disease diagnosis date.Date].[All Disease Diagnosis Dates], [Disease onset date.Date].[All Disease Onset Dates], [Investigation].[All Jurisdictions], [Disease].[All Diseases], [Age].[All Ages], [Race].[All Races], [Population Year].[All Population Years])} ON rows from [Morbidity Events] | |
| ' |
davidray
/ gist:356696
Created
April 5, 2010 18:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8"?> | |
| <DataSources> | |
| <DataSource> | |
| <DataSourceName>Provider=Mondrian;DataSource=Pentaho</DataSourceName> | |
| <DataSourceDescription>Pentaho BI Platform Datasources</DataSourceDescription> | |
| <URL>http://<%= biserver %>:<%= biserver-port %>/pentaho/Xmla?userid=joe&password=password</URL> | |
| <DataSourceInfo>Provider=mondrian</DataSourceInfo> | |
| <ProviderName>PentahoXMLA</ProviderName> | |
| <ProviderType>MDP</ProviderType> | |
| <AuthenticationMode>Unauthenticated</AuthenticationMode> |
davidray
/ gist:353218
Created
April 2, 2010 14:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 14:57:26,102 ERROR [MondrianModel] Parse Failure | |
| mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' | |
| select NON EMPTY {[Measures].[Count]} ON columns, NON EMPTY {([Gender.Gender].[All Genders], [Ethnicity.Ethnicity].[All Ethnicities], [Disease diagnosis date.Date].[All Disease Diagnosis Dates], [Disease onset date.Date].[All Disease Onset Dates], [Investigation].[All Jurisdictions], [Disease].[All Diseases], [Age].[All Ages], [Race].[All Races], [Population Year].[All Population Years])} ON rows from [Morbidity Events] | |
| ' | |
| at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) | |
| at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) | |
| at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) | |
| at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:579) | |
| at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:546) | |
| at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) |
davidray
/ gist:352180
Created
April 1, 2010 18:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 18:21:33,667 ERROR [MondrianModel] Parse Failure | |
| mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' | |
| select NON EMPTY {[Measures].[Count]} ON columns, NON EMPTY {([Gender.Gender].[All Genders], [Ethnicity.Ethnicity].[All Ethnicities], [Disease diagnosis date.Date].[All Disease Diagnosis Dates], [Disease onset date.Date].[All Disease Onset Dates], [Investigation].[All Jurisdictions], [Disease].[All Diseases], [Age].[All Ages], [Race].[All Races], [Population Year].[All Population Years])} ON rows from [Morbidity Events] | |
| ' | |
| at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) | |
| at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) | |
| at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) | |
| at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:579) | |
| at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:546) | |
| at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) |
davidray
/ gist:348143
Created
March 29, 2010 17:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 13:57:00,815 ERROR [Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0026 - Failed to retrieve object with name "ISolutionRepository" from the Pentaho object factory. | |
| org.pentaho.platform.api.engine.ObjectFactoryException: Failed to create an instance of object with key [ISolutionRepository]. | |
| at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.instanceClass(AbstractSpringPentahoObjectFactory.java:81) | |
| 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:487) | |
| at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:464) | |
| at org.pentaho.platform.plugin.action.kettle.KettleS |
davidray
/ gist:346366
Created
March 27, 2010 21:41
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <div style="margin-bottom: .3em;"> | |
| <%= form.text_field :activity_on, :size => 10, :class => "input_date" %> | |
| </div> | |
| <div style="margin-bottom: .3em;"> | |
| <%= form.text_field :end_on, :size => 10, :class => "input_date" %> | |
| </div> |
davidray
/ gist:335666
Created
March 17, 2010 20:10
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 16:11:36,352 ERROR [RuntimeContext] Error end: | |
| 16:11:37,612 ERROR [PMSFormula] an exception occurred | |
| org.jfree.formula.parser.ParseException: Lexical error at line 1, column 31. Encountered: "\'" (39), after : "" | |
| at org.jfree.formula.Formula.<init>(Formula.java:63) | |
| at org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:262) | |
| at org.pentaho.pms.mql.SQLGenerator.getBusinessColumnSQL(SQLGenerator.java:627) | |
| at org.pentaho.pms.mql.SQLGenerator.getTablesInvolved(SQLGenerator.java:368) | |
| at org.pentaho.pms.mql.SQLGenerator.getSQL(SQLGenerator.java:295) | |
| at org.pentaho.pms.mql.MQLQueryImpl.getQuery(MQLQueryImpl.java:172) | |
| at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.getQuery(MQLRelationalDataComponent.java:189) |