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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.