Created 09-13-2016 02:24 PM
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
Created 09-13-2016 02:39 PM
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)
Created 09-13-2016 02:39 PM
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)
Created 09-13-2016 02:47 PM
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
Created 09-13-2016 02:58 PM
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.