SAP Knowledge Base Article - Preview

2847588 - Is dbcc logtransfer available in SAP ASE 16.0?

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.