Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-1645

Oozie upgrade DB command fails due to missing dependencies for mssql

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.0.0
    • Fix Version/s: 4.1.0
    • Component/s: None
    • Labels:
      None

      Description

      upgrade DB command fails with following stacktrace
      D:\hdp\oozie-4.0.0.2.0.6.0-1432\oozie-win-distro\bin>ooziedb.cmd upgrade -run

      Validate DB Connection
      DONE
      Check DB schema exists
      DONE
      Verify there are not active Workflow Jobs
      DONE
      Check OOZIE_SYS table does not exist
      DONE
      Upgrade SQL schema
      DONE
      Create OOZIE_SYS table
      DONE
      Post-upgrade COORD_JOBS new columns default values
      DONE
      Post-upgrade COORD_JOBS & COORD_ACTIONS status values
      DONE
      Post-upgrade MISSING_DEPENDENCIES column

      Error: Argument data type text is invalid for argument 1 of replace function.

      Stack trace for the error was (for debug purposes):
      --------------------------------------
      com.microsoft.sqlserver.jdbc.SQLServerException: Argument data type text is inva
      lid for argument 1 of replace function.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError
      (SQLServerException.java:197)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ
      erStatement.java:1493)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ
      LServerStatement.java:775)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute
      (SQLServerStatement.java:676)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4615)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe
      rverConnection.java:1400)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer
      verStatement.java:179)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS
      erverStatement.java:154)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ
      erStatement.java:633)
      at org.apache.oozie.tools.OozieDBCLI.postUpgradeTasks(OozieDBCLI.java:36
      1)
      at org.apache.oozie.tools.OozieDBCLI.upgradeDBTo40(OozieDBCLI.java:220)
      at org.apache.oozie.tools.OozieDBCLI.upgradeDB(OozieDBCLI.java:192)
      at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:119)
      at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:67)

        Attachments

          Activity

            People

            • Assignee:
              omaliuvanchuk Ostap
              Reporter:
              omaliuvanchuk Ostap
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: