Mahalingam created RANGER-5002:
----------------------------------
Summary: Installation with Oracle failed during schema
vx_principal creation
Key: RANGER-5002
URL: https://issues.apache.org/jira/browse/RANGER-5002
Project: Ranger
Issue Type: Bug
Components: admin
Affects Versions: 2.5.0
Reporter: Mahalingam
During the installation of the apache Ranger we got the following exception:
Environment Setup: Apache Ranger 2.5.0
Database: Oracle 19c
{code:java}
2024-11-09 23:25:46,863 [JISQL] /usr/lib/jvm/java-17-openjdk-amd64/bin/java
-Djava.security.egd=file:///dev/urandom -cp
/usr/share/java/ojdbc10.jar:/opt/ranger/ranger-2.5.0-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver oraclethin -cstring
jdbc:oracle:thin:@//***:1521/*** -u 'usename' -p '********' -noheader -trim
-input
/opt/ranger/ranger-2.5.0admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
-c \;
SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: ORA-00932:
inconsistent datatypes: expected - got CLOB ErrorCode: 932
SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: ORA-00932:
inconsistent datatypes: expected - got CLOB ErrorCode: 932
2024-11-09 23:25:51,191 [E] ranger_core_db_oracle.sql file import failed!
2024-11-09 23:25:51,192 [I] Unable to create DB schema, Please drop the
database and try again
2024-11-09 23:25:51,192 [JISQL] /usr/lib/jvm/java-17-openjdk-amd64/bin/java
-Djava.security.egd=file:///dev/urandom -cp
/usr/share/java/ojdbc10.jar:/opt/ranger/ranger-2.5.0-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver oraclethin -cstring
jdbc:oracle:thin:@//**:1521/**** -u 'username' -p '********' -noheader -trim -c
\; -query "delete from x_db_version_h where version = 'CORE_DB_SCHEMA' and
active = 'N' and updated_b y=***';"
2024-11-09 23:25:52,978 [E] CORE_DB_SCHEMA import failed!
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
