java.sql.BatchUpdateException: ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000)

Oracle Community | 2839955 | 2 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Error while migrating SQL Server database to Oracle

    Oracle Community | 2 years ago | 2839955
    java.sql.BatchUpdateException: ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000)

    Root Cause Analysis

    1. java.sql.BatchUpdateException

      ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.close
      1. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1335)
      2. oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3753)
      3. oracle.jdbc.driver.OraclePreparedStatement.alwaysOnClose(OraclePreparedStatement.java:10342)
      4. oracle.jdbc.driver.OracleStatement.hardClose(OracleStatement.java:1633)
      5. oracle.jdbc.driver.OracleStatement.hardClose(OracleStatement.java:1622)
      6. oracle.jdbc.driver.OraclePreparedStatement.hardClose(OraclePreparedStatement.java:10300)
      7. oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1612)
      8. oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1541)
      9. oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:77)
      10. oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:78)
      10 frames
    3. oracle.dbtools.migration
      WorkbenchController.handleEvent
      1. oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.GeneratePreparedStatement.cleanUp(GeneratePreparedStatement.java:244)
      2. oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.MetadataFileParser.cleanUp(MetadataFileParser.java:290)
      3. oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.MetadataFileParser.loadData(MetadataFileParser.java:245)
      4. oracle.dbtools.migration.workbench.plugin.SQLServer2000DoOfflineCaptureLoad.populateSourceModel(SQLServer2000DoOfflineCaptureLoad.java:264)
      5. oracle.dbtools.migration.workbench.plugin.SQLServer2000DoOfflineCaptureLoad.loadSourceModel(SQLServer2000DoOfflineCaptureLoad.java:142)
      6. oracle.dbtools.migration.workbench.plugin.SQLServer2000OfflineCapturer.captureInitializeImpl(SQLServer2000OfflineCapturer.java:178)
      7. oracle.dbtools.migration.capture.AbstractOfflineCapturer.captureInitialize(AbstractOfflineCapturer.java:49)
      8. oracle.dbtools.migration.workbench.core.WorkbenchController.doOfflineCapture(WorkbenchController.java:241)
      9. oracle.dbtools.migration.workbench.core.WorkbenchController.processOfflineOutput(WorkbenchController.java:209)
      10. oracle.dbtools.migration.workbench.core.WorkbenchController.handleEvent(WorkbenchController.java:116)
      10 frames
    4. oracle.ide.controller
      IdeAction.actionPerformed
      1. oracle.ide.controller.IdeAction.performAction(IdeAction.java:524)
      2. oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:855)
      3. oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:496)
      3 frames
    5. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
      5. javax.swing.AbstractButton.doClick(AbstractButton.java:302)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
      7. javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092)
      8. java.awt.Component.processMouseEvent(Component.java:5517)
      9. javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
      10. java.awt.Component.processEvent(Component.java:5282)
      11. java.awt.Container.processEvent(Container.java:1966)
      12. java.awt.Component.dispatchEventImpl(Component.java:3984)
      13. java.awt.Container.dispatchEventImpl(Container.java:2024)
      14. java.awt.Component.dispatchEvent(Component.java:3819)
      15. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
      16. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
      17. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
      18. java.awt.Container.dispatchEventImpl(Container.java:2010)
      19. java.awt.Window.dispatchEventImpl(Window.java:1791)
      20. java.awt.Component.dispatchEvent(Component.java:3819)
      21. java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
      22. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
      23. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
      24. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
      25. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
      26. java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
      26 frames