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
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.