-----------------------------------------------------------
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
