java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]'SUBSTR' is not a recognized built-in function name.

Oracle Community | Matt1 | 2 years ago
  1. 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.
  2. 0

    Problem loading table in SQL server

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

    ODI - Error 11.1.1.6

    Oracle Community | 3 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 Load Plan errors

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

    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]'SUBSTR' is not a recognized built-in function name.

      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.executeQuery
      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.u(Unknown Source)
      6. weblogic.jdbc.sqlserverbase.ddde.executeQuery(Unknown Source)
      6 frames
    5. oracle.odi.query
      JDBCTemplate.executeQuery
      1. oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
      1 frame
    6. oracle.odi.runtime
      DataMovementTaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:94)
      2. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
      3. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
      3 frames
    7. 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)
      5 frames
    8. oracle.odi.runtime
      StartSessRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:376)
      1 frame
    9. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    10. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:309)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:301)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:865)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      5 frames
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame