java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'NULL'.

Oracle Community | Matt1 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    ODI Load Plan errors

    Oracle Community | 2 years ago | Matt1
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'NULL'.
  2. 0

    Problem loading table in SQL server

    Oracle Community | 5 years ago | 945471
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'.
  3. 0

    ODI - Error 11.1.1.6

    Oracle Community | 4 years ago | 18_4_Ever
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]CREATE TABLE permission denied in database 'master'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Fail to load data from Sql server to sql server database table using ODI 11.1.1.7

    Oracle Community | 3 years ago | user8630590
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'.
  6. 0

    ODI initial load

    Oracle Community | 2 years ago | Matt1
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]'SUBSTR' is not a recognized built-in function name.

    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. java.sql.SQLException

      [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'NULL'.

      at weblogic.jdbc.sqlserverbase.ddb_.b()
    2. weblogic.jdbc.sqlserverbase
      ddb9.a
      1. weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
      2. weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
      3. weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
      4. weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
      4 frames
    3. weblogic.jdbc.sqlserver
      ddj.m
      1. weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
      2. weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
      3. weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
      4. weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
      5. weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
      5 frames
    4. weblogic.jdbc.sqlserverbase
      ddde.execute
      1. weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source)
      2. weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
      3. weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
      4. weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
      5. weblogic.jdbc.sqlserverbase.ddel.r(Unknown Source)
      6. weblogic.jdbc.sqlserverbase.ddde.execute(Unknown Source)
      6 frames
    5. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
      2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
      3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
      4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
      4 frames
    6. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)
      6 frames
    7. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      1 frame
    8. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    9. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1068)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      4 frames
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame