davidray

# Database administrative login by UNIX sockets
local all postgres ident sameuser
 
# TYPE DATABASE USER CIDR-ADDRESS METHOD
 
# "local" is for Unix domain socket connections only
local all david ident sameuser
local all nedss trust
# IPv4 local connections:
host all all 127.0.0.1/32 md5

davidray

 sudo cat /proc/cpuinfo
[sudo] password for david: 
processor	: 0
vendor_id	: GenuineIntel
cpu family	: 6
model		: 15
model name	: Intel(R) Pentium(R) Dual  CPU  E2200  @ 2.20GHz
stepping	: 13
cpu MHz		: 1200.000
cache size	: 1024 KB

davidray

ERROR:  relation "warehouse_a.dw_patients" does not exist
CONTEXT:  SQL statement "CREATE VIEW trisano.dw_morbidity_patients_view AS
            SELECT * FROM warehouse_a.dw_patients
            WHERE is_morbidity_patient"
PL/pgSQL function "swap_schemas" line 50 at EXECUTE statement

davidray

postgres@trisano-bi:/opt/trisano-bi/warehouse$  psql -Xf warehouse_init.sql trisano_dw
psql:warehouse_init.sql:18: ERROR:  schema "trisano" already exists
psql:warehouse_init.sql:19: ERROR:  role "trisano_su" does not exist
psql:warehouse_init.sql:20: ERROR:  language "plpgsql" already exists
psql:warehouse_init.sql:22: ERROR:  role "trisano_su" does not exist
psql:warehouse_init.sql:23: ERROR:  role "trisano_ro" does not exist
psql:warehouse_init.sql:27: ERROR:  relation "current_schema_name" already exists
TRUNCATE TABLE
INSERT 0 1
psql:warehouse_init.sql:34: ERROR:  relation "etl_success" already exists

davidray

14:27:35,029 ERROR [MQLRelationalDataComponent] Error end:
14:27:35,041 ERROR [RuntimeContext] ba0f691f-3feb-11de-b094-83c247aac0ad:RUNTIME:context-174145862-1242239253913:preview.xaction RuntimeContext.ERROR_0012 - ActionDefinition for MQLRelationalDataComponent did not execute successfully
14:27:35,042 ERROR [SolutionEngine] ba0f691f-3feb-11de-b094-83c247aac0ad:SOLUTION-ENGINE:preview.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed
14:28:19,690 ERROR [MQLRelationalDataComponent] Error Start: Pentaho Pentaho Platform Engine Core TRUNK-SNAPSHOT.development
14:28:19,690 ERROR [MQLRelationalDataComponent] d4ef2410-3feb-11de-b094-83c247aac0ad:COMPONENT:context-1149394405-1242239299000:InMemorySolutionSQLBaseComponent.ERROR_0006 - Could not execute InMemorySolution
org.postgresql.util.PSQLException: ERROR: syntax error at or near "ORDER"
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(Q

davidray

2009-05-13 16:51:09 EDT ERROR:  syntax error at or near "ORDER" at character 846
2009-05-13 16:51:09 EDT STATEMENT:  SELECT DISTINCT 
	          MorbidityEvents.investigating_jurisdiction AS COL0
	         ,MorbidityEvents.investigator AS COL1
	         ,MorbidityDiseases.disease_name AS COL2
	         ,MorbidityPatients.last_name AS COL3
	         ,MorbidityPatients.first_name AS COL4
	         ,MorbidityPatients.birth_date AS COL5
	
	FROM trisano.dw_morbidity_diseases_view MorbidityDiseases RIGHT OUTER JOIN 

davidray

-- execute("CREATE INDEX people_fts_vector_index ON people USING gist(vector);")
   -> 0.0040s
   -> 0 rows
-- execute("CREATE FUNCTION people_trigger() RETURNS trigger AS $$\n                      begin\n                        new.vector :=\n                          setweight(to_tsvector('pg_catalog.english', coalesce(new.first_name,'')), 'B') ||\n                          setweight(to_tsvector('pg_catalog.english', coalesce(new.last_name,'')), 'B') ||\n                          setweight(to_tsvector('pg_catalog.english', coalesce(new.first_name_soundex,'')), 'A') ||\n                          setweight(to_trake aborted!
ActiveRecord::ActiveRecordError: ERROR: language "plpgsql" does not exist: CREATE FUNCTION people_trigger() RETURNS trigger AS $$
                      begin
                        new.vector :=
                          setweight(to_tsvector('pg_catalog.english', coalesce(new.first_name,'')), 'B') ||
                          setweight(to_tsvector('pg_catalog.english', coalesce(new.last_

davidray

(in /home/david/trisano-enterprise)
Copying Community files to /home/david/ee-dist
cp -Rf /home/david/trisano/distro /home/david/ee-dist
cp -Rf /home/david/trisano/lib /home/david/ee-dist
cp -Rf /home/david/trisano/README /home/david/ee-dist
cp -Rf /home/david/trisano/CONTRIBUTORS /home/david/ee-dist
cp -Rf /home/david/trisano/COPYING /home/david/ee-dist
cp -Rf /home/david/trisano/avr /home/david/ee-dist
cp -Rf /home/david/trisano/webapp /home/david/ee-dist
Merging EE bits

davidray

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html class="noscript" xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=<%= Comatose.config.content_type %>"/>
    <title>Comatose Admin</title>
    <%= stylesheet_link_tag 'comatose_admin' %>ß
    <%= javascript_include_tag :defaults %>
    <%= javascript_include_tag 'comatose_admin' %>
    <%= javascript_include_tag "jquery", :cache => false %>

davidray

<script type="text/javascript" >
   $(document).ready(function() {
      $("#markItUp").markItUp(mySettings);
   });
</script>

<%= error_messages_for :page %>

<% form_for :page, @page do |f| %>
<table class="page-form" cellpadding="0" cellspacing="0">