There is a warmstandy replication environment:
Primary ASE: servername1
Secondary ASE: servername2
executed below sql script on the Primary ASE server: servername1
alter table test_tab modify owner dbo
The sql was successfully executed on servername1. However, the DSI EXEC went down with the following error:
ERROR #1028 DSI EXEC(134(1) Servername2.db) - dsiqmint.c(4719)
Message from server: Message: 4056, State 4, Severity 16 -- 'Login name dbo not found. Check and make sure an entry exists in Syslogins.
THREAD FATAL ERROR #5049 DSI EXEC(134(1) servername2.db2) - dsiqmint.c(4732)
The DSI thread for database 'servername2.db' is being shutdown. DSI received data server error #4056 which is mapped to STOP_REPLICATION. See logged data
server errors for more information. The data server error was caused by output command #0 mapped from input command #0 of the failed transaction.
The DSI thread for database 'servername2.db' is shutdown.
Dump stable queue get the output below, that show the command "alter table test_tab modify owner dbo" is not correct to transalated by Replication Agent.
sqlddl append first last 'ALTER TABLE dbo.test_tab MODIFY OWNER LOGINAME ONLY dbo'
ASE Adaptive Server Enterprise
Alter table, modify owner, DSI down, Loginame Only, sa_role , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.