com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

Oracle Community | user4783187 | 2 years ago
  1. 0

    ODI 10.1.3.6 Error

    Oracle Community | 2 years ago | user4783187
    com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
  2. 0

    How to see rejected rows in Essbase

    Oracle Community | 6 years ago | 774120
    com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
  3. 0

    Text to MSSQL  problem

    Oracle Community | 8 years ago | 642770
    com.microsoft.sqlserver.jdbc.SQLServerException: Could not bulk insert. Invalid column number in format file 'd:\odi_temp_file/SALESBILL2000_20090127.TXT.fmt'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error creating versions in a solution

    Oracle Community | 8 years ago | matt_sh
    com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'EXT_VERSION'.
  6. 0

    Executing interface for a SQL Server 2000 target

    Oracle Community | 7 years ago | 702926
    com.microsoft.sqlserver.jdbc.SQLServerException: Cannot use empty object or column names. Use a single space if necessary.

  1. abrazeneb 2 times, last 3 months ago
19 unregistered visitors
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. com.microsoft.sqlserver.jdbc.SQLServerException

    String or binary data would be truncated.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
  2. com.microsoft.sqlserver
    SQLServerPreparedStatement.executeUpdate
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
    2. com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
    3. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
    4. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
    5. com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
    7. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
    8. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
    9. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
    9 frames
  3. com.sunopsis.sql
    SnpsQuery.executeUpdate
    1. com.sunopsis.sql.SnpsQuery.executeUpdate(Unknown Source)
    1 frame
  4. com.sunopsis.dwg
    SnpTxt.setStringWithXRefs
    1. com.sunopsis.dwg.dbobj.generated.GeneratedSnpOrigTxt.insertAction(Unknown Source)
    2. com.sunopsis.dwg.DwgObject.insert(Unknown Source)
    3. com.sunopsis.dwg.DwgObject.insert(Unknown Source)
    4. com.sunopsis.dwg.dbobj.SnpTxt.setString(Unknown Source)
    5. com.sunopsis.dwg.dbobj.SnpTxt.a(Unknown Source)
    6. com.sunopsis.dwg.dbobj.SnpTxt.setStringWithXRefs(Unknown Source)
    6 frames
  5. com.sunopsis.graphical
    fj.actionPerformed
    1. com.sunopsis.graphical.frame.b.it.bH(Unknown Source)
    2. com.sunopsis.graphical.frame.bp.r(Unknown Source)
    3. com.sunopsis.graphical.frame.b.fj.actionPerformed(Unknown Source)
    3 frames
  6. 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.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
    6. java.awt.Component.processMouseEvent(Component.java:5517)
    7. javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
    8. java.awt.Component.processEvent(Component.java:5282)
    9. java.awt.Container.processEvent(Container.java:1966)
    10. java.awt.Component.dispatchEventImpl(Component.java:3984)
    11. java.awt.Container.dispatchEventImpl(Container.java:2024)
    12. java.awt.Component.dispatchEvent(Component.java:3819)
    13. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
    14. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
    15. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
    16. java.awt.Container.dispatchEventImpl(Container.java:2010)
    17. java.awt.Window.dispatchEventImpl(Window.java:1791)
    18. java.awt.Component.dispatchEvent(Component.java:3819)
    19. java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
    20. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
    21. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
    22. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
    23. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
    24. java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
    24 frames