SAP HANA node restarted after incorporating row level security in analytic privilege

520 Views

Hi,

Our HANA node has restarted after we incorporated row based security on cost center field using analytic privilege with repository procedure. Inside repository procedure, based on SESSION_USER respective Cost Center will be fetched from a HANA DB table whish is having around 20 K entries.

This analytic privilege is assigned to a general role which in turn is available for all users.

This resulted in the below crash dump , pointing to procedure call.

Could any one please let me know the root cause for this issue.

[CRASH_SHORTINFO] exception short info: (2016-03-13 14:35:59 032 Local)

SIGNAL 6 (SIGABRT) caught, sender PID: 98902, PID: 98902, thread: 581942599[thr=122700]: JobWrk3984, value int: 0, ptr: 0x0000000000000000, time: 2016-03-13 14:35:59 000 Local

[CRASH_EXTINFO] extended exception info: (2016-03-13 14:35:59 033 Local)

----> Dump of siginfo contents <----

signal: 6(SIGABRT)

code: -6(SI_TKILL: signal send by tkill)

sender pid: 98902

own pid: 98902

sender uid: 1002

own uid: 1002

value(int): 0 (0x0)

value(ptr): 0x0000000000000000

[CRASH_CONTEXT] context info: (2016-03-13 14:35:59 033 Local)

----> Crashing context information <----

ContextStack at (0x00007fcd07f574e0)

stack: 7fcd07b59000-7fcd07f58fff, size 4194304

guard: 7fcd07b49000-7fcd07b58fff, size 65536

last known stack pointer cur: 0, max: 0

ctx addr: 0x00007eec564d7020, ctx link: 0x00007eec564d7020, ctx owner: 0x00007eec564d7020

ctx name: JobWrk3984, ctx type: thread, ctx id: 581942599

ctx command text:

{

SQL: CALL "_SYS_BIC"."XXXXXXX.general.app-fin-gl-pcsviz/SP_FIN_PCSVIZ_CC_MNGR_COST_CTR_AUTH"(?)

Thanks

Regards,

Jeswanth