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.
SAP Knowledge Base Article - Preview