2652256 - Online Backup in DB13 finishes with error SQL1092N | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2652256 - Online Backup in DB13 finishes with error SQL1092N

Symptom

Online backup when performing in DBA COCKPIT gives error SQL1092N:

30.05.2018 22:00:12 Job started
30.05.2018 22:00:12 Step 001 started (program RSDBAJOB, variant ***************, user ID *******)
30.05.2018 22:00:12 Backup_Dev:Database Backup to Device
30.05.2018 22:00:12 Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE       on server ****
30.05.2018 22:00:12 Backup_Dev:Parameter TESTMODE has not been set
30.05.2018 22:00:12 Backup_Dev:Parameter RUNTIME has not been set
30.05.2018 22:00:12 Backup_Dev:Parameter BACKUP_MODE has been set to "ONLINE"
30.05.2018 22:00:12 Backup_Dev:Parameter PARTITION has not been set
30.05.2018 22:00:12 Backup_Dev:Parameter BACKUP_TYPE has been set to ""
30.05.2018 22:00:12 Backup_Dev:Parameter COMPRESS has been set to ""
30.05.2018 22:00:12 Backup_Dev:Parameter INCLUDE LOGS has been set to "INCLUDE LOGS"
30.05.2018 22:00:12 Backup_Dev:Parameter NUMBER_BUFFERS has been set to " 0"
30.05.2018 22:00:12 Backup_Dev:Parameter BUFFER_SIZE has been set to " 0"
30.05.2018 22:00:12 Backup_Dev:Parameter PARALLELISM has been set to " 0"
30.05.2018 22:00:12 Backup_Dev:Parameter UTIL_IMPACT_PRIORITY has not been set
30.05.2018 22:00:12 Backup_Dev:Parameter FILE_PATH has been set to ******"
30.05.2018 22:00:14 Backup_Dev:Command ' BACKUP DATABASE <SID> ******* ONLINE TO ****** INCLUDE LOGS  'failed
30.05.2018 22:00:14 Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r
30.05.2018 22:00:14 Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP
30.05.2018 22:00:14 Backup_Dev:  Kernel Error ID:
30.05.2018 22:00:14 Backup_Dev:SYSID:
30.05.2018 22:00:14 Backup_Dev:  SY-SUBRC: 1208
30.05.2018 22:00:14 Backup_Dev:  SY-TABIX: 0
30.05.2018 22:00:14 Backup_Dev:  Message: ADBC error
30.05.2018 22:00:14 Backup_Dev:  Database:
30.05.2018 22:00:14 Backup_Dev:caused by
30.05.2018 22:00:14 Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method SSV_BACKUP
30.05.2018 22:00:14 Backup_Dev:line 66
30.05.2018 22:00:14 Backup_Dev:  Kernel Error ID:
30.05.2018 22:00:14 Backup_Dev:  SYSID: DEV
30.05.2018 22:00:14 Backup_Dev:  SY-SUBRC: 1208
30.05.2018 22:00:14 Backup_Dev:  Message: ADBC error
30.05.2018 22:00:14 Backup_Dev:  Command:BACKUP *********************
30.05.2018 22:00:14 Backup_Dev:  ******  " INCLUDE LOGS
30.05.2018 22:00:14 Backup_Dev:  Database:
30.05.2018 22:00:14 Backup_Dev:caused by
30.05.2018 22:00:14 Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
30.05.2018 22:00:14 Backup_Dev:  Kernel Error ID:
30.05.2018 22:00:14 Backup_Dev:  DB Error: Yes
30.05.2018 22:00:14 Backup_Dev:  SQL Code: 1092-
30.05.2018 22:00:14 Backup_Dev:  SQL Message: SQL1092N "USER" does not havetheauthority to perfo
30.05.2018 22:00:14 Backup_Dev:  rm the requested command or operation row=1
30.05.2018 22:00:14 Backup_Dev:  DB Object Exists: No
30.05.2018 22:00:14 Backup_Dev:  Duplicated Key: No
30.05.2018 22:00:14 Backup_Dev:  Internal Error: 1
30.05.2018 22:00:14 Backup_Dev:  Invalid Cursor: No
30.05.2018 22:00:14 Backup_Dev:  Unknown Connection: No
30.05.2018 22:00:14 Backup_Dev:  Connection Closed: No
30.05.2018 22:00:14 Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method  line 40
30.05.2018 22:00:14 Backup_Dev:terminated with error
30.05.2018 22:00:14 REASON=ADBC error
30.05.2018 22:00:14 Job finished

 SQL1092N_2_prime.png


Read more...

Environment

Linux/Unix

DB2 LUW

Product

SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

DB13 Online Backup DBACOCKPIT , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , How To

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.