SAP Knowledge Base Article - Preview

2660843 - DSI went down with ERROR #1028 DSI EXEC


There is a warmstandy replication environment:

Primary ASE:  servername1

Secondary ASE: servername2

executed below sql script on the  Primary ASE server: servername1

use db
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.

sysadmin dump_queue,102,1,-1,1,-2,client


sqlddl append first last 'ALTER TABLE dbo.test_tab MODIFY OWNER LOGINAME ONLY dbo'



ASE Adaptive Server Enterprise


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


 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.