Troubleshooting the Stream Environment

Note: This section is only relevant when configuring the BI Interface for installation on two separate databases.

If data replication does not work, please consult the following troubleshooting list:

To verify that the capture process is working, check that the status in table DBA_CAPTURE on source database is enable. If the status is disabled, an error will appear in the ERROR_MESSAGE field of this table
To verify that instantiation is properly set on the replicated tables, check that all replicated tables are DBA_CAPTURE_PREPARED_TABLES on the source database and that they are in the DBA_APPLY_INSTANTIATED_OBJECTS on the target database
To verify that the propagation process is working, check that the status in table DBA_PROPAGATION on source database is enable. If the status is disabled, an error will appear in ERROR_MESSAGE field of this table
To verify that the apply process is working, check that the status in table DBA_APPLY on the target database is enabled. If the status is disabled, an error will appear in the ERROR_MESSAGE field of this table and in the DBA_APPLY_ERROR table on the target database
To verify that the views show proper data, check that no errors exist in the t_raw_data_fields_log table on the CA Business Service Insight target database