ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dhaval Shah <dhavalshah9...@gmail.com>
Subject Re: Review Request 72817: RANGER-2978 : Ranger upgrade fails due to missing DB function.
Date Wed, 23 Sep 2020 05:54:05 GMT

This is an automatically generated e-mail. To reply, visit:

(Updated Sept. 23, 2020, 5:54 a.m.)

Review request for ranger, Ankita Sinha, bhavik patel, Gautam Borad, Jayendra Parab, Madhan
Neethiraj, Mehul Parikh, Pradeep Agrawal, and Velmurugan Periasamy.

Bugs: RANGER-2978

Repository: ranger


Ranger upgrade fails with below error :

*Error executing: call insert_statename_in_x_ranger_global_state(); 
java.sql.SQLSyntaxErrorException: FUNCTION ranger.getXportalUIdByLoginId does not exist
SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: FUNCTION ranger.getXportalUIdByLoginId
does not exist ErrorCode: 1305*

Issue : In patch 046-insert-statename-in-x-ranger-global-state.sql
Function **getXportalUIdByLoginId()**  is not define before invoking.

Affected DB Flavor : MySql, MS-SQL, Oracle, Postgres, SQL anywhere


  security-admin/db/mysql/patches/046-insert-statename-in-x-ranger-global-state.sql cdc0aa6eb

  security-admin/db/oracle/patches/046-insert-statename-in-x-ranger-global-state.sql 89c781d22

  security-admin/db/postgres/patches/046-insert-statename-in-x-ranger-global-state.sql b8b29eefd

  security-admin/db/sqlserver/patches/046-insert-statename-in-x-ranger-global-state.sql d76254b52

Diff: https://reviews.apache.org/r/72817/diff/1/

Testing (updated)

Sucessfully tested for Mysql, Oracle, Postgres, Sqlanywhere, MS-SQL


Dhaval Shah

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message