[
https://issues.apache.org/jira/browse/RANGER-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dhaval B. SHAH updated RANGER-2978:
-----------------------------------
Fix Version/s: 2.1
> 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
> Priority: Major
> Fix For: 2.1
>
>
> 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)
