Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-2978

Ranger upgrade fails due to missing DB function.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1.0, 3.0.0
    • Component/s: Ranger
    • Labels:
      None

      Description

      Ranger upgrade fails with below error :

      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

       

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dhavalshah9131 Dhaval Shah
                Reporter:
                dhavalshah9131 Dhaval Shah
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: