Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

NN / Hive Audit Error - Ranger DB on Oracle

avatar
Expert Contributor

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

avatar
Contributor

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

avatar
Contributor

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)

avatar
Expert Contributor

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

avatar
Contributor

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.