[
https://issues.apache.org/jira/browse/RANGER-5084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17909028#comment-17909028
]
Mahalingam commented on RANGER-5084:
------------------------------------
During this operation there is an insert happening to the table x_trx_log_v2,
the table is found to be missing column OBJECT_NAME in it.
Insert Command:
{code:java}
Error Code: 904
Call: INSERT INTO x_trx_log_v2 (ID, ACTION, ADDED_BY_ID, CHANGE_INFO,
CREATE_TIME, CLASS_TYPE, OBJECT_ID, OBJECT_NAME, PARENT_OBJECT_CLASS_TYPE,
PARENT_OBJECT_ID, PARENT_OBJECT_NAME, REQ_ID, SESS_ID, SESS_TYPE, TRX_ID)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
{code}
bind => [15 parameters bound]
Table structure:
{code:java}
SQL> describe x_trx_log_v2
Name Null?
Type
----------------------------------------- -------- ----------------------------
ID
NOT NULL NUMBER(20)
CREATE_TIME
DATE
ADDED_BY_ID
NUMBER(20)
CLASS_TYPE NOT NULL
NUMBER(11)
OBJECT_ID
NUMBER(20)
PARENT_OBJECT_ID
NUMBER(20)
PARENT_OBJECT_CLASS_TYPE NOT NULL NUMBER(11)
PARENT_OBJECT_NAME
VARCHAR2(1024)
CHANGE_INFO
CLOB
TRX_ID
VARCHAR2(1024)
ACTION
VARCHAR2(255)
SESS_ID
VARCHAR2(512)
REQ_ID
VARCHAR2(30)
SESS_TYPE
VARCHAR2(30)
SQL>
{code}
If we go through the issue -
https://issues.apache.org/jira/browse/RANGER-4812 , The OBJECT_NAME column is
found to be present for the patches released for mysql, postgres but its not
present for Oralce To carry on with the installation, We are thinking of
updating DDL and include OBJECT_NAME VARCHAR2(1024) ?
In order to fix this issue, We have executed the following code to add the
column:
ALTER TABLE x_trx_log_v2 ADD COLUMN object_name VARCHAR(1024) DEFAULT NULL
After this addtion of the column, the installation happened successfully.
> Installation failed During the update of the ranger admin password - Oracle
> Schema
> ----------------------------------------------------------------------------------
>
> Key: RANGER-5084
> URL: https://issues.apache.org/jira/browse/RANGER-5084
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Affects Versions: 2.5.0
> Reporter: Mahalingam
> Priority: Major
>
> The installation of Apache Ranger reports a failure during the default ranger
> admin password change. Towards the end of the installation , The installation
> process invokes ChangePasswordUtil.java , to perform this operation. The full
> logs from ChangePasswordUtil.java is attached as rangerdblogmissingcol
>
> {code:java}
> Excerpts of log: 2024-11-12 07:34:31,363 [main] INFO
> o.a.r.p.c.ChangePasswordUtil (ChangePasswordUtil.java:55) main()2024-11-12
> 07:34:52,057 [main] INFO o.a.r.p.c.ChangePasswordUtil
> (ChangePasswordUtil.java:121) ==> ChangePasswordUtil.execLoad()2024-11-12
> 07:34:52,187 [main] ERROR o.a.r.p.c.ChangePasswordUtil
> (ChangePasswordUtil.java:265) Update Admin Password failure. Detail:
> javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse
> Persistence Services - 2.7.12.v20230209-e5c4074ef3):
> org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception:
> java.sql.SQLSyntaxErrorException: ORA-00904: "OBJECT_NAME": invalid
> identifier {code}
> Environment Setup: Apache Ranger 2.5.0
> Database: Oracle 19c
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
