SAP Note 2205345 - SAP HANA DB Client: "SQL code: -9300" occurred while accessing table

Component : SAP HANA Clients (JDBC, ODBC) - SAP HANA Database

Solution : https://service.sap.com/sap/support/notes/2205345 (SAP Service marketplace login required)

Summary :
During a table migration to the HANA database, the error "SQL code: -9300" may appear due to issues with the SAP HANA SQLDBC Client, particularly when using DEFERRED_LOB_WRITING with large packets. This occurs in clients preceding SPS10 Revision 102 during operations involving large LOB data. Upgrade to at least Revision 102 to resolve the issue. Alternatively, disable DEFERRED_LOB_WRITING through DBSL profile setting (`dbs/hdb/deferred_lob_writing = 0`) or increase `dbs/hdb/cmd_buffersize` significantly to manage all LOB requests in a single packet.

Key words :
customer component han-db-cli sap hana clients, components han-db sap hana database priority correction, medium priority category program error validity, 2220929   sap hana sps 09 database maintenance revision 97, profile parameter dbs/hdb/cmd_buffersize = <size, sap notes 2184212   sap hana db, sps09 2066225   sap hana db, sps08 1523337   sap hana database 1, sps10 2093754   sap hana db, sap hana client reason

Related Notes :

2106186
2200357
2184212
2093754SAP HANA DB: Known issues detected in SPS09
2066225SAP HANA DB: Known issues detected in SPS08
1523337SAP In-Memory Database 1.0: Central Note
1514967SAP HANA 1.0: Central Note
2220929