Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

NN / Hive Audit Error - Ranger DB on Oracle

Solved Go to solution
Highlighted

NN / Hive Audit Error - Ranger DB on Oracle

Rising Star

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

Explorer

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)

View solution in original post

3 REPLIES 3

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

Explorer

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)

View solution in original post

Highlighted

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

Rising Star

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

Highlighted

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

Explorer

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.

Don't have an account?
Coming from Hortonworks? Activate your account here