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 for Me (Login required).

Search for additional results

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