[ 
https://issues.apache.org/jira/browse/OOZIE-1645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13882840#comment-13882840
 ] 

Hadoop QA commented on OOZIE-1645:
----------------------------------

Testing JIRA OOZIE-1645

Cleaning local git workspace

----------------------------

{color:green}+1 PATCH_APPLIES{color}
{color:green}+1 CLEAN{color}
{color:red}-1 RAW_PATCH_ANALYSIS{color}
.    {color:green}+1{color} the patch does not introduce any @author tags
.    {color:green}+1{color} the patch does not introduce any tabs
.    {color:green}+1{color} the patch does not introduce any trailing spaces
.    {color:green}+1{color} the patch does not introduce any line longer than 
132
.    {color:red}-1{color} the patch does not add/modify any testcase
{color:green}+1 RAT{color}
.    {color:green}+1{color} the patch does not seem to introduce new RAT 
warnings
{color:green}+1 JAVADOC{color}
.    {color:green}+1{color} the patch does not seem to introduce new Javadoc 
warnings
{color:green}+1 COMPILE{color}
.    {color:green}+1{color} HEAD compiles
.    {color:green}+1{color} patch compiles
.    {color:green}+1{color} the patch does not seem to introduce new javac 
warnings
{color:green}+1 BACKWARDS_COMPATIBILITY{color}
.    {color:green}+1{color} the patch does not change any JPA 
Entity/Colum/Basic/Lob/Transient annotations
.    {color:green}+1{color} the patch does not modify JPA files
{color:red}-1 TESTS{color}
.    Tests run: 1382
.    Tests failed: 0
.    Tests errors: 1

.    The patch failed the following testcases:

.      

{color:green}+1 DISTRO{color}
.    {color:green}+1{color} distro tarball builds with the patch 

----------------------------
{color:red}*-1 Overall result, please check the reported -1(s)*{color}


The full output of the test-patch run is available at

.   https://builds.apache.org/job/oozie-trunk-precommit-build/1031/

> Oozie upgrade DB command fails due to missing dependencies for mssql
> --------------------------------------------------------------------
>
>                 Key: OOZIE-1645
>                 URL: https://issues.apache.org/jira/browse/OOZIE-1645
>             Project: Oozie
>          Issue Type: Bug
>    Affects Versions: 4.0.0
>            Reporter: Ostap
>            Assignee: Ostap
>         Attachments: Fix_OozieDBCLI_for_mssql.patch, 
> Fix_OozieDBCLI_for_mssql_2.patch, Fix_OozieDBCLI_for_mssql_3.patch
>
>
> 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
> {quote}
> 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)
> {quote}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Reply via email to