Installing InForm Adapter with existing InForm study databases
The InForm Server Adapter Windows service must be run only when using the ODM Export interface or the integration to Clintrial Integration Solution (CIS).
When InForm Adapter is installed on an InForm server and the InForm Server Adapter Windows service is run, it populates a database table with transaction XML for all studies on that server. This process can take several hours depending on the number of studies, their size, and the available resources on the machine where the InForm Server Adapter is installed.
While the transaction XML is being created, errors can occur as the InForm Server Adapter software is communicating with another application (for example, the Central Coding application or Clintrial Integration Solution (CIS) application). This process can also impact communication with other applications that use the InForm Adapter software.
To prevent errors from occurring while the transaction XML is being created, Oracle recommends you perform one of the following procedures:
- Allow the transaction XML to be created before running jobs from an application that communicates with the InForm server.
The InForm Server Adapter must populate a new database table in the InForm study schema with transaction XML. To do this, the study must be running. To verify that the transaction XML is created, execute the following queries against every study database:
- Select count(*) from pf_transactionhistory—Indicates the number of transactions in the study.
- Select count(*) from pfex_transactionxml—Indicates the number of transactions for which XML has been created.
When you first install InForm Adapter, no XML will have been created and the table pfex_transactionxml will not exist, because it is created by the InForm Server Adapter.
It may take up to a few hours for the associated application (CIS or customer-developed ODM client application) to receive all the transactions for the existing study.
- Add the InForm Server Adapter offline:
- Install the InForm software and InForm Adapter on a machine that is not being used for production.
- When all of the transaction XML files have been created, export the study and load it into a production database.
Note: These issues do not apply when you are adding a new study (a study that contains no data) to the InForm Adapter instance.