After inserting data into the source ASE table, the connection the Sybase IQ <target database> database comes down and replication does not occur. The RS log reports the following error:
T. 2004/11/08 11:06:52. (28): Command(s) to 'asiqsample.asiqsample':
T. 2004/11/08 11:06:52. (28): 'insert into test2 (id, fname) values (1, 'George')'
E. 2004/11/08 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. 2004/11/08 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. 2004/11/08 11:06:52. The DSI thread for database 'asiqsample.asiqsample'
is shutdown.
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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
