Adaptive Server last-chance Threshold Passed

Occurs when the last-chance threshold is reached. This error includes references to the Adaptive Server error 7415.

Symptom

These errors are recorded in the Replication Server error log:

I. 2006/06/13 10:45:07. Message from server: Message: 7415, State: 1,
Severity: 10 - - ‘The transaction log in database northDB is almost full.
Your transaction is being suspended until space is made available in the
log.’.
E. 2006/06/13 10:45:07. ERROR #5046 DSI(axp st.northDB) - /dsioqid.c(1638)
When executing the rs_get_lastcommit function in database ‘axp st.northDB’,
received data server errors. See logged data server errors for more
information.

Explanation

By default, the replicate Adaptive Server suspends all transaction processing when the destination database log segment size becomes greater than the Adaptive Server last-chance threshold. The last-chance threshold is a parameter that keeps the log from expanding to greater than the maximum size of the log.

This problem is related to Data Server Interface (DSI) shutting down because the replicate database log is full. If the database is the Replication Server System Database (RSSD), other serious consequences can occur.

Solution

Reduce the size of the log by dumping or truncating it:

Manually dump the log using these commands in the RSSD:
```
> sp_helpdb northDB
> go
> dump tran northDB to ...
> go
> sp_helpdb northDB
> go
```
where northDB is the replicate database with a full log.
If this step fails, truncate the log by executing dump tran with the truncate_only or no_log option.