The following errors, which include references to the Adaptive Server error 7415, 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.
By default, the replicate Adaptive Server suspends all transaction processing when the destination database log segment size becomes greater than the Adaptive Server’s 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.
If the database is the RSSD, other serious consequences can occur. See “RSSD log device full”.
This problem is related to “DSI shuts down because replicate database log is full”, which occurs when the Adaptive Server log for the database is almost full.
This problem can also apply to Replication Server version
11.0.x.
Reduce the size of the log by dumping or truncating it as follows:
Manually dump the log using these commands in the RSSD:
> sp_helpdb northDB > go > dump tran northDB to ... > go > sp_helpdb northDB > go
If this step fails, truncate the log by executing dump tran with the truncate_only or no_log option.
