Symptom
ENABLE_BULK_LOAD=BCP and dboption 'select into / pllsort' = false causes error message:
com.sybase.jdbc4.jdbc.SybSQLException: Bad row data received from the client while bulk copying into object XXX partition XXX in database X. Received a row of length XXX whilst maximum or expected row length is XXX .
at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4237)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3346)
at com.sybase.jdbc4.tds.Tds.getDoneResult(Tds.java:4044)
at com.sybase.jdbc4.tds.Tds.processLanguageDoneResult(Tds.java:5740)
at com.sybase.jdbc4.tds.Tds.initBCP(Tds.java:5712)
at com.sybase.jdbc4.jdbc.SybBCP.bcpInit(SybBCP.java:845)
at com.sybase.jdbc4.jdbc.SybBCP.bcpSendCommon(SybBCP.java:1228)
at com.sybase.jdbc4.jdbc.SybBCP.bcpSendRow(SybBCP.java:1238)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.addBulkBatch(SybPreparedStatement.java:1590)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.addBatch(SybPreparedStatement.java:1638)
Read more...
Environment
- SAP Sybase Software Developer Kit (SDK) 15.7 SP120
- SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
- jConnect
- JDBC 7.07
- JDBC 16 ( is version 7.07 )
- java
Product
Keywords
CR#821530, CR821530, CR# 821530, java, jconn4.jar, bulk, bulkload, load, insert, update, addBatch(), , KBA , BC-SYB-SDK , SDK , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.