SAP Knowledge Base Article - Preview

3207257 - SQL code: 340: not all variables bound: unbound parameter : <cnt> of <total>, <cnt> out of <total_batch> batches

Symptom

Short dump DBSQL_SQL_ERROR with SQL error "SQL code: 340" occurred while accessing table "<table name>".

Look into the corresponding developer trace dev_w* you find the error is in context with FDA WRITE / FOR ALL ENTRIES operations.

C  *** ERROR =>   execute() of C_0157, #rec=0, rc=1, rcSQL=340
 [dbsdbsql.cpp 3510]
C  {root-id=0022486814EB1EDCB4B3F4A04D643458}_{conn-id=36323743373834303632374337383430}_26
C  *** ERROR => EXECUTE C_0157 on connection 0, rc=340
 [dbslsdb.cpp  8795]
C  SQLCODE    : 340
C  SQLERRTEXT : not all variables bound: unbound parameter : <cnt> of <total>, <cnt> out of <total_batch> batches
C  sc_p=000001CF38AEEAE8,no=157,idc_p=000001CF38B3C910,con=0,act=1,slen=256,smax=1024,#vars=2,stmt=000001CF38B71EA0,table=<table name>                       
C  stmtid = <0/ZNS00400                                /20981860/20220511132541>
C  SELECT /* FDA WRITE */ ....


Read more...

Keywords

FDA READ, fast data access, CX_SY_OPEN_SQL_DB, "SQL dbsl rc: 99" , SQLERRTEXT, not all variables bound: unbound parameter , KBA , HAN-DB , SAP HANA Database , 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.