You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Dhaval Shah <dh...@gmail.com> on 2020/08/29 15:47:01 UTC
Review Request 72817: RANGER-2978 : Ranger upgrade fails due to
missing DB function.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72817/
-----------------------------------------------------------
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
-------
Thanks,
Dhaval Shah
Re: Review Request 72817: RANGER-2978 : Ranger upgrade fails due to
missing DB function.
Posted by Madhan Neethiraj <ma...@apache.org>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72817/#review221747
-----------------------------------------------------------
Ship it!
Ship It!
- Madhan Neethiraj
On Aug. 29, 2020, 3:47 p.m., Dhaval Shah wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72817/
> -----------------------------------------------------------
>
> (Updated Aug. 29, 2020, 3:47 p.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
> -------
>
>
> Thanks,
>
> Dhaval Shah
>
>
Re: Review Request 72817: RANGER-2978 : Ranger upgrade fails due to
missing DB function.
Posted by Pradeep Agrawal <pr...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72817/#review221752
-----------------------------------------------------------
Please confirm is it tested for all db flavors ?
- Pradeep Agrawal
On Aug. 29, 2020, 3:47 p.m., Dhaval Shah wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72817/
> -----------------------------------------------------------
>
> (Updated Aug. 29, 2020, 3:47 p.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
> -------
>
>
> Thanks,
>
> Dhaval Shah
>
>
Re: Review Request 72817: RANGER-2978 : Ranger upgrade fails due to
missing DB function.
Posted by Dhaval Shah <dh...@gmail.com>.
-----------------------------------------------------------
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