SAP Knowledge Base Article - Preview

2448043 - SQL17260 Can't run sp_autoformat from within a transaction when calling sp_dump_history - SAP Solution Manager on SAP ASE

Symptom

You are monitoring SAP ASE databases on SAP Solution Manager 7.2. You find the following errors to occur incessantly in the SM21 system log on your Solution Manager system.

C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (17260) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't run sp_autoformat from w
C  ithin a transaction.
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]DUMP
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]----
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]CONFIG
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]------
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]ALTER DATABASE
C  ERROR: -1 in function StartSelect (execute) [line 25479]
C  (0) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]--------------
C  sql statement is ==> EXEC sybsystemprocs..sp_dump_history
C  dbdssyb: DBSL99 SQL17260
C  [ASE Error SQL17260][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't run sp_autoformat from within a transaction.
B  ***LOG BY2=> sql error 17260 performing OPC [dbds         437]
B  ***LOG BY0=> [ASE Error SQL17260][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't run sp_autoformat from within a transact
C  DbSlDisconnect hdl: 1
B

Also Similar issue can be reported at Dbacockpit in Database Dump History:

Exception CX_DBA_ADBC in class CL_DBA_RDI_QUERY method EXECUTE line 157
 Kernel Error ID: 
 WP ID: 1 
 WP PID: 64724
 Application Server: SVW-PIDEV01
 SYSID: SID
 SY-SUBRC: 1208 
 Message: ADBC error
 SQL statement: EXEC sybsystemprocs..sp_dump_history
 Database: +++SYBADM
 caused by
 Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT 
 Kernel Error ID: 
 DB Error: Yes
 SQL Code: 17260 
 SQL Message: [ASE Error SQL17260][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't run sp_autoformat from within a transaction.
 DB Object Exists: No
 Duplicated Key: No
 Internal Error: 1 
 Invalid Cursor: No
 Unknown Connection: No
 Connection Closed: No


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.2

Product

SAP Solution Manager 7.2

Keywords

SQL17260, sp_autoformat, sp_dump_history, SM21,804132 , KBA , sm_efwk , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , SV-SMG-SDD , Service Data Download , 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.