Symptom
There is a warmstandy replication environment:
Primary ASE: servername1
Secondary ASE: servername2
executed below sql script on the Primary ASE server: servername1
use db
go
alter table test_tab modify owner dbo
go
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.
sysadmin dump_queue,102,1,-1,1,-2,client
go
......
sqlddl append first last 'ALTER TABLE dbo.test_tab MODIFY OWNER LOGINAME ONLY dbo'
Read more...
Environment
ASE Adaptive Server Enterprise
Product
Keywords
Alter table, modify owner, DSI down, Loginame Only, sa_role , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
About this page
This 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.