SAP Knowledge Base Article - Preview

2660843 - DSI went down with ERROR #1028 DSI EXEC

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.