NN / Hive Audit Error - Ranger DB on Oracle

[#1]

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

[#2 · Accepted solution]

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)

[#3]

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

[#4]

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.