Skip to Content
avatar image
Former Member

how better insert data via DI API?

“We want to insert approximately 100000 records to hana db in for loop via DI API. But we encounter memory errors like following;

Additional information: 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;129 transaction rolled back by an internal error: AttributeEngine: not enough memory

The code we used is ;

publicstaticvoid runMultiSql(List<string> sqlQueryList )

{

try

{

SAPbobsCOM.Recordset oRecSetLines = (SAPbobsCOM.Recordset)Program.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);

for (int counter = 0; counter < sqlQueryList.Count; counter++ )

{

oRecSetLines.DoQuery(sqlQueryList[counter]);

}

}

catch (Exception exc)

{

SAPbouiCOM.Framework.Application.SBO_Application.MessageBox(exc.Message);

}

}

Is there any better way to do it? We have to insert too many records regularly.”

thanks from now

regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers