You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ranger.apache.org by "Dhaval B. SHAH (Jira)" <ji...@apache.org> on 2020/08/28 15:19:00 UTC

[jira] [Created] (RANGER-2978) Ranger upgrade fails due to missing DB function.

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)