[
https://issues.apache.org/jira/browse/RANGER-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17200579#comment-17200579
]
Dhaval B. SHAH commented on RANGER-2978:
----------------------------------------
Commit link :
Master :
[https://github.com/apache/ranger/commit/f754f832fefb2d04053b37dc02024ea251d052cf]
Ranger 2.1 :
[https://github.com/apache/ranger/commit/5ec9fbd0b78595084dc847f7fdc9da0506f6c482]
> 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.0, 3.0.0
>
>
> 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)
