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