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)
