java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot drop the table 'ODHYDVG.ODIDEVSTG.C$_0Account_Modified', because it does not exist or you do not have permission.

Oracle Community | 2996902 | 11 months 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 interface warning

    Oracle Community | 11 months ago | 2996902
    java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot drop the table 'ODHYDVG.ODIDEVSTG.C$_0Account_Modified', because it does not exist or you do not have permission.
  2. 0

    Invalid object name when using sql server target

    Oracle Community | 5 years ago | 244680
    java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'C_0XXINT_X1_PERSON_I'.
  3. 0

    Unable to login to planning v11.1.2.2

    Oracle Community | 4 years ago | Sethu
    java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'HSP_SYSTEMCFG'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Planning Outlineload Utility Fails

    Oracle Community | 2 years ago | 2659278
    java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Inva lid object name 'HSPSYS_PROPERTIES'.

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot drop the table 'ODHYDVG.ODIDEVSTG.C$_0Account_Modified', because it does not exist or you do not have permission.

      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:2128)
      5 frames
    7. oracle.odi.runtime
      StartSessRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
      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.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      5 frames
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame