Page History
...
Totalnum Scripts for Postgres and MSSQL have been updated to improve the Totalnum counter performance on very large(>1.5 million) ontology elements such as ACT medications, Debug messages have also been added for troubleshoot purposes
Totalnum Scripts Setup
In the Release_1-7/NewInstall/Metadata/ run the ant script to create the stored procedures. ant -f data_build.xml create_metadata_procedures_release_1-7
Run the stored procedures on your database. This can be done in two ways.
a. Run the ant command to execute the data_build.xml file with below specified target
- 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
b. Execute the
...
RunTotalNum stored procedure
...
manully against your database in from a sql Client. This can take several hours. Example Usage:
Oracle:
begin
RUNTOTALNUM('observation_fact','i2b2demodata');
end;
Note: If you get the error as: ERROR at line 1: ORA-01031: insufficient privilege, then run the command:
grant create table to (DB USER)
SQL server:
exec RUNTOTALNUM
PostgreSQL:
select RUNTOTALNUM('observation_fact','public')
– (replace 'public' by the schema name for the fact table)
– If using a schema other than public for metadata, you might need to run "set search_path to 'i2b2metadata','public' " first as well
...