java.util.concurrent.ExecutionException: com.sybase.jdbc4.jdbc.SybSQLException: RAISERROR executed: Valid table types: TABLE, BASE, SYSTEM, VIEW, GLOBAL TEMPORARY or null

Oracle Community | 2655038 | 2 years ago
  1. 0

    Error while trying to reverse engineer Sybase IQ in ODI 12c

    Oracle Community | 2 years ago | 2655038
    java.util.concurrent.ExecutionException: com.sybase.jdbc4.jdbc.SybSQLException: RAISERROR executed: Valid table types: TABLE, BASE, SYSTEM, VIEW, GLOBAL TEMPORARY or null
  2. 0

    Hello, We try to use Liquibase in our project. We are generating the change set from an existing schema. When applying the change set to create the schma on a fresh databsae, we get the exception to follow. Apparently one of the column name seems too long (more than 28 characters) for Sybase. This is due to the brackets that are added at some point to quote the name of the column. When running the SQL to create them manually, it works as the name itself is short enough. This same issue has been already raised a long time ago in CORE-197, but it's closed without a fix. Could you check this please ? Thanks. Here is the call stack with the exception we get: {code:java} Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set : Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [DB].[FILTER_COMPONENT_DBF] ([TIMESTAMP] DATETIME NULL, [M_IDENTITY] NUMERIC(10) NOT NULL, [M_REFERENCE] NUMERIC(10) NOT NULL, [M_OPERATOR] numeric(2) NOT NULL, [M_FILTER_COMPONENT_PARENT__ID] NUMERIC(10) NOT NULL): The identifier that starts with '[M_FILTER_COMPONENT_PARENT__I' is too long. Maximum length is 28. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:564) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:70) at liquibase.Liquibase.update(Liquibase.java:195) at liquibase.Liquibase.update(Liquibase.java:174) ... 31 more Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [DB].[FILTER_COMPONENT_DBF] ([TIMESTAMP] DATETIME NULL, [M_IDENTITY] NUMERIC(10) NOT NULL, [M_REFERENCE] NUMERIC(10) NOT NULL, [M_OPERATOR] numeric(2) NOT NULL, [M_FILTER_COMPONENT_PARENT__ID] NUMERIC(10) NOT NULL): The identifier that starts with '[M_FILTER_COMPONENT_PARENT__I' is too long. Maximum length is 28. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1206) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:528) ... 37 more Caused by: com.sybase.jdbc4.jdbc.SybSQLException: The identifier that starts with '[M_FILTER_COMPONENT_PARENT__I' is too long. Maximum length is 28. at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4013) at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3103) at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:79) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:290) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272) at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2594) at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2581) at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:1293) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:310) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 41 more Process finished with exit code -1 {code}

    JIRA | 1 year ago | feng yang
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [DB].[FILTER_COMPONENT_DBF] ([TIMESTAMP] DATETIME NULL, [M_IDENTITY] NUMERIC(10) NOT NULL, [M_REFERENCE] NUMERIC(10) NOT NULL, [M_OPERATOR] numeric(2) NOT NULL, [M_FILTER_COMPONENT_PARENT__ID] NUMERIC(10) NOT NULL): The identifier that starts with '[M_FILTER_COMPONENT_PARENT__I' is too long. Maximum length is 28.
  3. 0

    How to implement EJB timer service in Wildfly AS 8 for a datasource

    Stack Overflow | 2 years ago
    com.sybase.jdbc4.jdbc.SybSQLException: There is already an object named 'JBOSS_EJB_TIMER' in the database.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java/XML/SQL - SQL in XML won't run in JDBC (Sybase) driver

    Stack Overflow | 8 months ago | lincolnadym
    com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name ' '.
  6. 0

    Sybase throws Exception "there is already another cursor with the name XXX" when Executing SELECT Query in multi-threading environment

    Stack Overflow | 10 months ago | Ashish Pancholi
    com.sybase.jdbc4.jdbc.SybSQLException: There is already another cursor with the name 'jconnect_implicit_134' at the nesting level '0'.

    Root Cause Analysis

    1. com.sybase.jdbc4.jdbc.SybSQLException

      RAISERROR executed: Valid table types: TABLE, BASE, SYSTEM, VIEW, GLOBAL TEMPORARY or null

      at com.sybase.jdbc4.tds.Tds.processEed()
    2. com.sybase.jdbc4
      SybDatabaseMetaData.getTables
      1. com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4013)
      2. com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3103)
      3. com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:79)
      4. com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:290)
      5. com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272)
      6. com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2409)
      7. com.sybase.jdbc4.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java:147)
      8. com.sybase.jdbc4.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaData.java:4286)
      9. com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getTables(SybDatabaseMetaData.java:2972)
      9 frames
    3. com.sunopsis.dwg
      Reverse.getMetaData
      1. com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1567)
      2. com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1517)
      2 frames
    4. com.sunopsis.graphical
      SwingWorker$1.call
      1. com.sunopsis.graphical.frame.edit.EditFrameSnpModel$9.doInBackground(EditFrameSnpModel.java:2720)
      2. com.sunopsis.graphical.tools.utils.swingworker.SwingWorker$1.call(SwingWorker.java:240)
      2 frames
    5. Java RT
      FutureTask.run
      1. java.util.concurrent.FutureTask.run(FutureTask.java:262)
      1 frame
    6. com.sunopsis.graphical
      SwingWorker.run
      1. com.sunopsis.graphical.tools.utils.swingworker.SwingWorker.run(SwingWorker.java:278)
      1 frame
    7. oracle.ide.dialogs
      ProgressBar.run
      1. oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:920)
      1 frame
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:744)
      1 frame