While trying to replicate data from an ASE table to an IQ table owned by DBA, the connection to IQ comes DOWN

Symptom

After inserting data into the source ASE table, the connection to the Sybase IQ <target database> database comes down and replication does not occur. The RS log reports the following error:

T. 2006/09/18 11:06:52. (28): Command(s) to 'asiqsample.asiqsample':
T. 2006/09/18 11:06:52. (28): 'insert into test2 (id, fname)
values (1, 'George')'
E. 2006/09/18 11:06:52. ERROR #1028 DSI EXEC(115(1) asiqsample.asiqsample) - 
dsiqmint.c(3034)
	Message from server: Message: 2706, State 0, Severity 11 --
'ASA Error -141: Table 'test2' not found'. 
H. 2006/09/18 11:06:52. THREAD FATAL ERROR #5049 DSI EXEC(115(1)
asiqsample.
asiqsample) - dsiqmint.c(3041)
	The DSI thread for database 'asiqsample.asiqsample' is being shutdown.
DSI received data server error #2706 which is mapped to
STOP_REPLICATION. See logged data server errors for more information.
The data server error was caused by output command #1 mapped from input
command #1 of the failed transaction.
I. 2006/09/18 11:06:52. The DSI thread for database 'asiqsample.asiqsample'

Solution

When the target table owner is anyone other than the connection maintenance user rsuser, the replication definition must specify the appropriate Replicate Table Owner for the replicate (target) table.

Once the replication definition has been updated appropriately, right-click the target database connection within RSM and select Resume. Check the Resume DSI and Skip first transaction boxes and select OK.

The Target database connection should return to an UP state within RSM. The RSM may need to be refreshed to reflect the state change.