Page History
...
- In the Release_1-7/NewInstall/Metadata/ run the ant script to create the stored procedures.
- POSTGRESQL : ant -f data_build.xml db_metadata_run_total_count_postgresql
- ORACLE : ant -f data_build.xml db_metadata_run_total_count_oracle
- SQL SERVER : ant -f data_build.xml db_metadata_run_total_count_sqlserver
- Execute the RunTotalNum stored procedure on your database. This can take several hours.
Example Usage:
Oracle:
begin
RUNTOTALNUM('observation_fact','i2b2demodata');
end;
SQL server:
exec RUNTOTALNUM
PostgresSQL:
select RUNTOTALNUM('observation_fact','public')
-- (replace 'public' by the schema name for the fact table)
-- If using a sch
3. When finished, verify it is complete by checking that c_totalnum columns in your ontology tables contain numbers (not nulls).
These total counts
...
will be visible in the ontology browser in the web client.
ACT Ontology Setup
Anchor | ||||
---|---|---|---|---|
|
...