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


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 , KBA , sm_efwk , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

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