-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/63115/
-----------------------------------------------------------
Review request for ranger, Ankita Sinha, Don Bosco Durai, bhavik patel, Gautam
Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan
Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
Bugs: RANGER-1820
https://issues.apache.org/jira/browse/RANGER-1820
Repository: ranger
Description
-------
**Problem Statement:** DB schema script updated through RR-62717 does not have
new db patch entry(029) in optimized sql server script. Similarly java patch
J10008 and J10011 need to be added.
**Proposed Solution:** Proposed solution is having insert statement for sql
patch 029 and java patch J10008,J10011 in
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql file.
**Note:** Patch for master branch shall be different than ranger-0.7 branch
patch as master branch script is already having changes related to java patch
J10008. Proposed patch for master branch is attached in Apache Jira RANGER-1820.
Diffs
-----
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
27257e3
Diff: https://reviews.apache.org/r/63115/diff/1/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin
DB user are created.
2) From a MSSQL Client tool executed
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql file
on database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema
creation and java patch execution. Ranger UI should work properly after
starting Ranger admin.
Actual Behaviour : DB schema creation and java patch execution was skipped and
patches were marked executed in x_db_version_h table.
Thanks,
Pradeep Agrawal
