User guide

UPDATE mvf_ts_config SET execution_time = 'NEVER' WHERE module_name =
'CREATE_CC_CONFLICT_JOB'
4. To refresh cached data, type
UPDATE map_ref_count SET ref_count = ref_count + 1 WHERE name =
'DATABASE_UPDATE_REF'
Disabling tx object creation5.
Important!
This topic applies only when the IMPAX site archives to an IMPAX Data Center.
When IMPAX 6.4 is installed or upgraded, issues can arise due to the creation of Transaction or tx
objects (DICOM objects used to synchronize status changes across multiple IMPAX clusters). To prevent
these issues, you must disable support for these objects.
To disable tx object creation in an IMPAX Oracle database
1. Log in as the oracle user (Solaris) or as the AgfaService user (Windows).
2. On Solaris, copy dosr.trigsql.oracle as /usr/mvf/etc/dosr.trigsql.oracle.MIS101670.
or
On Windows, copy dosr.trigsql.sqlserver as c:\mvf\etc\dosr.trigsql.oracle.MIS101670.
3. Log into SQLPlus as the dbadmin user.
4. On Solaris, type @/usr/mvf/etc/dosr.trigsql.oracle.MIS101670.
or
On Windows, type @c:\mvf\etc\dosr.trigsql.oracle.MIS101670.
5. Type quit.
6. Type regrant-oracle (Solaris) or bash regrant-oracle (Windows).
To disable tx object creation in an IMPAX SQL Server database
1. Log in as the AgfaService user.
2. Copy dosr.trigsql.sqlserver as c:\mvf\etc\dosr.trigsql.sqlserver.MIS101670.
3. In SQL Server, using a tool such as Query Analyzer or Management Studio, open the
C:\mvf\etc\dosr.trigsql.sqlserver.MIS101670 file.
4. Click Execute.
5. In Query Analyzer or Management Studio, run sp_grant_permission.
AS300 Upgrade Guide—IMPAX 6.2 or later to IMPAX 6.4 50
AGFA COMPANY CONFIDENTIAL