Oracle GoldenGate Error Messages

OGG-30082

The DBOPTIONS _rollbacktransactiononerror is enabled. This causes the transaction to get rolled back in case of any error. The CDR, HANDLECOLLISIONS and REPERROR features will not work in presence of this parameter.


Cause

ODBC DSN attribute TransactionErrorBehavior is internally set to 2 for supporting CDR, HANDLECOLLISIONS and REPERROR features. This setting will have an impact on performance. If the user is not interested in any of these features, user can specify the DBOPTIONS _rollbacktransactiononerror in the parameter file to avoid unnecessary performance degradation.


Action

Remove the DBOPTIONS _rollbacktransactiononerror parameter from the REPLICAT parameter file if the user is interested in any of the CDR, HANDLECOLLISIONS and REPERROR features.