SAP Knowledge Base Article - Preview

2750395 - V8000 SP08 on HDB: GRC Role sync job fails with DBQSQL_SQL_ERROR accessing table GRACROLEORG

Symptom

Category Installation error

Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 05.02.2019 14:22:20

Short Text
SQL error "SQL code: 129" occurred while accessing table "GRACROLEORG".

What happened?
Database error text: "SQL message: transaction rolled back by an internal
error: TrexUpdate failed on table 'SAPABAP1:GRACROLEORG' with error:
Attribute load
failed;index=RDH::SAPABAP1:GRACROLEORGen,attribute=$trexexternalkey$, rc=6923
- enforce TX rollback"

The termination occurred in ABAP program or include

"CL_GRAC_USER_REP==============CP", in "SET_ROLE_ORGLEVEL". The
main program was "GRAC_ROLEREP_ROLE_SYNC".

In the source code, the termination point is in line 84 of program or
include "CL_GRAC_USER_REP==============CM00H".
The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure
"SET_ROLE_ORGLEVEL" "(METHOD)".
This exception was not handled locally or declared in the RAISING
clause in the procedure's signature however.
The procedure is in program "CL_GRAC_USER_REP==============CP". The source
code begins in line 1 of
(include) program "CL_GRAC_USER_REP==============CM00H".


Read more...

Environment

GRC Access Control for HANA DB

  • Repository Object Sync

Product

SAP Access Control 12.0

Keywords

6923, 129, SQL 129, rc=6923, TX rollback , KBA , GRC-SAC-ARA , Access Risk Analysis , GRC-SAC-ARQ , Access Request , GRC-ACP , GRC Access Control Plug-In , Problem

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.