Skip to Content
0

how better insert data via DI API?

Mar 14, 2017 at 05:59 AM

30

avatar image
Former Member

“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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers