SAP Knowledge Base Article - Preview

2158234 - Backup taken using the DBA Planning Calendar in transaction DBACOCKPIT finishes with error SQL1092N

Symptom

Backups taken using the DBA Planning Calendar in transaction DBACOCKPIT (or directly calling transaction DB13) finish with the following errors:

SQL Message: SQL1092N Therequested command or operation failed because the user ID does not have the authority toperform the requested command or operation. User ID

The error in the job log looks like:

Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r
Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 0
Backup_Dev:  Kernel Error ID:

Backup_Dev:  Message: ADBC error
Backup_Dev:  Database:
Backup_Dev:caused by
Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method SSV_BACKUP
Backup_Dev:  Message: ADBC error
Backup_Dev:caused by
Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
Backup_Dev:  Kernel Error ID:
Backup_Dev:  DB Error: Yes
Backup_Dev:  SQL Code: 1092-
Backup_Dev:  SQL Message: SQL1092N Therequested command or operation failed bec
Backup_Dev:  ause the user ID does not have the authority toperform the requested
Backup_Dev:  command or operation. User ID: "xxx row=1
Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method  line 40
Backup_Dev:terminated with error
REASON=ADBC error

In the database log db2diag.log, the following error comes up:

<Timestamp>                             LEVEL: Severe
PID     :                  TID :            PROC : db2fmp64.exe
INSTANCE:                NODE : 000
HOSTNAME:
EDUID   :
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1291
MESSAGE : SQL1092N  The requested command or operation failed because the user
          ID does not have the authority to perform the requested command or
          operation.  User ID: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1092   sqlerrml: 6
 sqlerrmc: SAPPID
 sqlerrp : sqlubCon
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
 sqlstate:


Read more...

Keywords

permissions, DB13, SYSADM_GROUP, SYSCTRL_GROUP, SYSMAINT_GROUP , KBA , BC-DB-DB6-DBA , Database Administration , 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.