SAP Knowledge Base Article - Preview

2917349 - jConnect: ENABLE_BULK_LOAD=BCP or LOG_BCP and db 'select into / pllsort' = false fails to insert data. 2nd addBatch() causes error 4837 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 - SDK for SAP ASE

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

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

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.