1_3 - rc1problem

[billybob]

Hi - I've been told there is an AUG group similar to this, but have
been unable to find it. For this, the post will have to be here.

We are running the 1_3 RC1 upgrade here at Children's @ Denver. We
have an Oracle install on a SUN Solarus box.

When trying to run the following command (pg 7 of the CRC upgrade
documentation) 'ant -f data_build.xml db_data_upgrade_1-3', ant
targets a SQL file, which runs the following:

CREATE TABLE CODE_LOOKUP (
TABLE_CD VARCHAR2(1000) NOT NULL,
COLUMN_CD VARCHAR2(1000) NOT NULL,
CODE_CD VARCHAR2(4000) NOT NULL,
NAME_CHAR VARCHAR2(4000) NULL
);

insert into code_lookup(table_cd,column_cd,code_cd,name_char) select
'OBSERVATION_FACT',dim_column,concept_Cd,name_char from FACT_LOOKUP;

insert into code_lookup(table_cd,column_cd,code_cd,name_char) select
distinct 'PATIENT_DIMENSION',dim_column,concept_Cd,name_char from
patient_dim_lookup;

insert into code_lookup(table_cd,column_cd,code_cd,name_char) select
'VISIT_DIMENSION',dim_column,concept_Cd,name_char from
visit_dim_lookup;


// Create Lookup table
CREATE TABLE "CRC_DB_LOOKUP"
( "C_DOMAIN_ID" VARCHAR(255 ),
"C_PROJECT_PATH" VARCHAR(500),
"C_OWNER_ID" VARCHAR(255 ),
"C_DB_FULLSCHEMA" VARCHAR(255 ),
"C_DB_DATASOURCE" VARCHAR(500 ),
"C_DB_SERVERTYPE" VARCHAR(255 ),
"C_DB_NICENAME" VARCHAR(500),
"C_DB_TOOLTIP" VARCHAR(500) ,
"C_COMMENT" text,
"C_ENTRY_DATE" DATEtime,
"C_CHANGE_DATE" DATEtime,
"C_STATUS_CD" CHAR(1 ),
CONSTRAINT "CDL_PK" PRIMARY KEY ("C_DOMAIN_ID",
"C_PROJECT_PATH", "C_OWNER_ID")
)


The problem lies herein: visit_dim_lookup, patient_dim_lookup,
FACT_LOOKUP all do NOT exist. Am I missing something with my
install?

If another forum is more appropriate, please let me know.

Thank you,

[billybob]

For those that may be running into the same thing - it appears this
was an error in the build. They are working on a re-release of the
CRC build.

[Aaron Abend]

Thanks for posting, Brian! Since only individuals with an approved academic credential are permitted to join the AUG it is very helpful to have information posted back to this public forum where other people can get to it.

Thanks!

Aaron