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
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.
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'.  (ar_odbc_stmt.c:4772)
- SAP Adaptive Server Enterprise 16.0
- SAP Adaptive Server Enterprise 15.7
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 pageThis 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.