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:
https://reviews.apache.org/r/72817/
-----------------------------------------------------------

(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
    https://issues.apache.org/jira/browse/RANGER-2978


Repository: ranger


Description
-------

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


Diffs
-----

  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/sqlanywhere/patches/046-insert-statename-in-x-ranger-global-state.sql
d81feca03 
  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


Thanks,

Dhaval Shah


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