sql error -9300 performing SEL on table

[vijay_battula2]

We are in the process of upgrade/migration of our EHP6 system (running on Oracle with HP-UX IA 64) to EHP8 (Hana DB). In the down time phase of the upgrade (in the MAIN_NEWBAS/TABIM_UPG  phase), I am getting the below error.

I already looked into the note ‘2205345 - SAP HANA DB Client: "SQL code: -9300" occurred while accessing table <table_name>’ . Our Hana client version is 1.00.112 . Also tried with Hana client version 1.00.120  as recommended by the note…but issue not resolved.

If anyone encountered this kind of issue, please let us know the fix .

Hana DB version: 1.00.112

Hana Client Verson: 1.00.112 (tried with 1.00.120 too)

Rtrans version: 745_Rel Patch 115

SAP Kernel Rel: 745_Rel patch 100

Lib_dbsl (Hana db) : 1.0.100 (also tried with 116 patch)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
MAIN IMPORT ERRORS and RETURN CODE in SAPILEN618GAERP608X2.QB8
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4 ETW000 [ dev trc,00000] sc_p=60000000010dd590,no=24,idc_p=6000000001142900,con=0,act=1,slen=72,smax=256,#vars=0,stmt=60000000012cf630,table=FPLAYOUTT
4 ETW000 [ dev trc,00000] stmtid = <3/FPLAYOUTT /1610612864/20141020135833>
4 ETW000 [ dev trc,00000] SELECT * FROM "FPLAYOUTT" ORDER BY "NAME" , "STATE" , "LANGUAGE" , "ID" ;
4 ETW000 [ dbtrtab ,00000] ***LOG BY4=>sql error -9300 performing SEL on table FPLAYOUTT
4 ETW000 [ dbtrtab ,00000] ***LOG BY0=>Internal SQLDBC error
2EETW000 sap_dext called with msgnr "1":
2EETW000 ---- db call info ----
2EETW000 function: db_setget
2EETW000 fcode: RT_GET (0)
2EETW000 tabname: FPLAYOUTT
2EETW000 len (char): 0
2EETW000 key:
2EETW000 ok fetches: 67176
2EETW000 last entry: REXCJP_PAYMENTREPORT AW
2EETW000 retcode: 1
2EETW000 sql error: -9300 Internal SQLDBC error
2EETW125 SQL error "-9300" during "" access: "Internal SQLDBC error"
1 ETP111 exit code : "12"

*******************************************************************

Thanks

VIjay B

[vijay_battula2]

I already tried all options mention in the note '2205345'...but the issue still not resolved

[former_member183326]

can you show me the corresponding errors in the indexserver trace file at the time of the failure?

[former_member182967]

Hi Vijay,

Please also try with the workaround mentioned in note  2205345 - SAP HANA DB Client: "SQL code: -9300" occurred while accessing table <table_name>

Remarks:

• Workaround option 1: Disable the DEFERRED_LOB_WRITING feature via DBSL profile parameter described in SAP Note 2106186. (dbs/hdb/deferred_lob_writing = 0)
• Workaround option 2: Increase the packet size so that all LOB requests can be sent via one packet. Set a much larger value (e.g. 5MB) to the profile parameter dbs/hdb/cmd_buffersize = <size in bytes> which is mentioned in SAP Note 2200357.  Since it is not always feasible to find the largest size for all LOBs being transferred, it is recommended to apply the 1st workaround option.

As well, please consider to update DBSL mentioned in note  2272590 - SAP HANA does not return the correct SQL error code for readFDA

Regards,

Ning