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

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".

GRC Access Control for HANA DB

• Repository Object Sync

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