Dhaval B. SHAH created RANGER-2978: -------------------------------------- Summary: Ranger upgrade fails due to missing DB function. Key: RANGER-2978 URL: https://issues.apache.org/jira/browse/RANGER-2978 Project: Ranger Issue Type: Bug Components: Ranger Reporter: Dhaval B. SHAH Assignee: Dhaval B. SHAH
Ranger upgrade fails with below error : {code:java} 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{code} 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 -- This message was sent by Atlassian Jira (v8.3.4#803005)