java.sql.BatchUpdateException

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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web840

  • via Oracle Community by 2839955, 1 year ago
    ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000)
  • via Atlassian JIRA by Arno Koehler, 11 months ago
    ORA-12899: value too large for column "CROWDUSER"."SERVERPROPERTY"."VALUE" (actual: 257, maximum: 255)
  • via Atlassian JIRA by Arno Koehler, 1 year ago
    ORA-12899: value too large for column "CROWDUSER"."SERVERPROPERTY"."VALUE" (actual: 257, maximum: 255)
  • Stack trace

    • java.sql.BatchUpdateException: ORA-12899: value too large for column "ORASQL"."SS2K_SYSPROPERTIES"."VALUE" (actual: 3605, maximum: 1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1335) at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3753) at oracle.jdbc.driver.OraclePreparedStatement.alwaysOnClose(OraclePreparedStatement.java:10342) at oracle.jdbc.driver.OracleStatement.hardClose(OracleStatement.java:1633) at oracle.jdbc.driver.OracleStatement.hardClose(OracleStatement.java:1622) at oracle.jdbc.driver.OraclePreparedStatement.hardClose(OraclePreparedStatement.java:10300) at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1612) at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1541) at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:77) at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:78) at oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.GeneratePreparedStatement.cleanUp(GeneratePreparedStatement.java:244) at oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.MetadataFileParser.cleanUp(MetadataFileParser.java:290) at oracle.dbtools.migration.workbench.plugin.sqlserverofflinecapture.MetadataFileParser.loadData(MetadataFileParser.java:245) at oracle.dbtools.migration.workbench.plugin.SQLServer2000DoOfflineCaptureLoad.populateSourceModel(SQLServer2000DoOfflineCaptureLoad.java:264) at oracle.dbtools.migration.workbench.plugin.SQLServer2000DoOfflineCaptureLoad.loadSourceModel(SQLServer2000DoOfflineCaptureLoad.java:142) at oracle.dbtools.migration.workbench.plugin.SQLServer2000OfflineCapturer.captureInitializeImpl(SQLServer2000OfflineCapturer.java:178) at oracle.dbtools.migration.capture.AbstractOfflineCapturer.captureInitialize(AbstractOfflineCapturer.java:49) at oracle.dbtools.migration.workbench.core.WorkbenchController.doOfflineCapture(WorkbenchController.java:241) at oracle.dbtools.migration.workbench.core.WorkbenchController.processOfflineOutput(WorkbenchController.java:209) at oracle.dbtools.migration.workbench.core.WorkbenchController.handleEvent(WorkbenchController.java:116) at oracle.ide.controller.IdeAction.performAction(IdeAction.java:524) at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:855) at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:496) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.