question NN / Hive Audit Error - Ranger DB on Oracle in Support Questions

NN / Hive Audit Error - Ranger DB on Oracle

mkataria — Tue, 13 Sep 2016 21:24:26 GMT

We are running Ranger on Oracle. Faced a common error (NN logs and Hive logs)

ORA-12899: Value too large for column "RANGERDBA"."XA.AUDIT"."REQUEST.DATA" (actual: 2465, maximum:2000)

We changed the REQUEST_DATA to VARCHAR2(3000) from VARCHAR2(2000)

Now the new error is

ORA-12899: Value too large for column "RANGERDBA"."XA.AUDIT"."REQUEST.DATA" (actual: 3465, maximum:3000)

This a a fresh Installation on Oracle only and not migrated from MySql. In my past exp we had the same issue where the DB was migrated from MySql and there were some NON ASCII chars .. we fixed it by changing to VARCHAR2 (2000 CHAR) from VARCHAR2(2000).

Will the same solution be able to fix this. What can cause this issue.

Thanks Mayank

Re: NN / Hive Audit Error - Ranger DB on Oracle

pagrawa — Tue, 13 Sep 2016 21:39:54 GMT

What is the version of Ranger ?

Also, Can you try this ? : ALTER TABLE XA_ACCESS_AUDIT modify(REQUEST_DATA VARCHAR(4000) DEFAULT NULL,RESOURCE_PATH VARCHAR(4000) DEFAULT NULL)

Re: NN / Hive Audit Error - Ranger DB on Oracle

mkataria — Tue, 13 Sep 2016 21:47:28 GMT

Ranger 0.5.0.2.4

Will try your suggestion, however since the org error was ((actual: 2465, maximum:2000), do we still need to take it to 4000

thanks

Re: NN / Hive Audit Error - Ranger DB on Oracle

pagrawa — Tue, 13 Sep 2016 21:58:34 GMT

This shall allow you to store column value larger than 2465 in future(if required)

Ranger end patch is doing the same.

Let me know if it fails after increasing column length to 4000.