org.quartz.JobExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text]

Oracle Community | 862805 | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    varbinary error in DBUM connector reconcile from Oracle target into MSSql

    Oracle Community | 7 years ago | 759294
    org.quartz.JobExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text]
  2. 0

    Error: Operand type clash: varbinary is incompatible with text

    Oracle Community | 3 years ago | 862805
    org.quartz.JobExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text]

    Root Cause Analysis

    1. org.quartz.JobExecutionException

      com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text]

      at com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run()
    2. com.thortech.xl
      QuartzWrapper$TaskExecutionAction.run
      1. com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run(Unknown Source)
      1 frame
    3. Thor.API.Security
      jbossLoginSession.runAs
      1. Thor.API.Security.LoginHandler.jbossLoginSession.runAs(Unknown Source)
      1 frame
    4. com.thortech.xl
      QuartzWrapper.execute
      1. com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
      1 frame
    5. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:203)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
      2 frames