tool.ImportTool: Encountered IOException running import job: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand data type uniqueidentifier is invalid for min operator.

incubator-sqoop-user | alo alt | 5 years ago
  1. 0

    Re: [sqoop-user] Error while sqoop-import

    incubator-sqoop-user | 5 years ago | alo alt
    tool.ImportTool: Encountered IOException running import job: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand data type uniqueidentifier is invalid for min operator.
  2. 0

    Re: [sqoop-user] Error while sqoop-import

    incubator-sqoop-user | 5 years ago | alo alt
    tool.ImportTool: Encountered IOException running import job: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand data type uniqueidentifier is invalid for min operator.
  3. 0

    Re: [sqoop-user] Error while sqoop-import

    incubator-sqoop-user | 5 years ago | alo alt
    tool.ImportTool: Encountered IOException running import job: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand data type uniqueidentifier is invalid for min operator.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: [sqoop-user] Error while sqoop-import

    incubator-sqoop-user | 5 years ago | alo alt
    tool.ImportTool: Encountered IOException running import job: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand data type uniqueidentifier is invalid for min operator.
  6. 0

    Expoting Dataset to a xml file giving error in DBunit

    Stack Overflow | 5 years ago | bhasker
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'user'.

  1. Andreas Häber 2 times, last 1 month ago
7 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    Operand data type uniqueidentifier is invalid for min operator.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
  2. com.microsoft.sqlserver
    SQLServerStatement.executeQuery
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
    2. com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
    3. com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
    4. com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
    5. com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
    7. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
    8. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
    9. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
    9 frames
  3. com.cloudera.sqoop
    DataDrivenDBInputFormat.getSplits
    1. com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:189)
    1 frame
  4. Hadoop
    JobClient$2.run
    1. org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:944)
    2. org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:961)
    3. org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170)
    4. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:880)
    5. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833)
    5 frames
  5. Java RT
    Subject.doAs
    1. java.security.AccessController.doPrivileged(Native Method)
    2. javax.security.auth.Subject.doAs(Subject.java:396)
    2 frames
  6. Hadoop
    UserGroupInformation.doAs
    1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
    1 frame
  7. Hadoop
    Job.waitForCompletion
    1. org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:833)
    2. org.apache.hadoop.mapreduce.Job.submit(Job.java:476)
    3. org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:506)
    3 frames
  8. com.cloudera.sqoop
    Sqoop.run
    1. com.cloudera.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:121)
    2. com.cloudera.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:181)
    3. com.cloudera.sqoop.manager.SqlManager.importTable(SqlManager.java:405)
    4. com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:350)
    5. com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
    6. com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
    6 frames
  9. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
    1 frame
  10. com.cloudera.sqoop
    Sqoop.main
    1. com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
    2. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
    3. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
    4. com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
    4 frames