Symptom
Attempting to use dbcc logtransfer with a a 3rd party CDC - change data capture solution.
- SAP Replication Server is not participating in your solution
- sa_role, replication_role are not properly assigned to login1> dbcc logtransfer
2> go
Msg 9112, Level 16, State 1
Server 'ASE_INSTANCE', Line 1
The DBCC LOGTRANSFER command must be invoked with at least 2 parameters. The DBCC LOGTRANSFER command is not executed.
1> -
SQL_ERROR SqlState: ZZZZZ NativeError: 10364 Message: [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Permission denied.
You must either be the database/object owner or possess any of the following roles in order to perform this operation:
'sa_role, replication_role'. [1022502] (ar_odbc_stmt.c:4772)
Read more...
Environment
- SAP Adaptive Server Enterprise 16.0
- SAP Adaptive Server Enterprise 15.7
Product
Keywords
replication, LTL, LTM, reserve, context, log, transfer, logtransfer, CDC, change data capture solution, Msg 9112 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.