...

1. In the Release_1-7/NewInstall/Metadata/ run the ant script to create the stored procedures.
   1. POSTGRESQL : ant -f data_build.xml db_metadata_run_total_count_postgresql
   2. ORACLE : ant -f data_build.xml db_metadata_run_total_count_oracle
   3. SQL SERVER : ant -f data_build.xml db_metadata_run_total_count_sqlserver
2. Execute the RunTotalNum stored procedure on your database. This can take several hours.
3. 1.         
4. 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
act-ontolog act-ontolog

...