Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,511 questions
How to load BSEG table FROM SAP ECC/HANA to Azure through ADF using the SAP connector?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 71%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vinayak Mathur
6
Reputation points
Hi,
I am trying to load data of BSEG from SAP ECC to Azure. Since BSEG is a huge table, I am not able to do a full load of the historical data.
I've tried partition options over Calendar Date, increasing parallelism but nothing seems to be working.
SAP Server has a memory of 10GB from which I am trying to load BSEG.
Any Suggestions/ Help would be appreciated.
Thanks
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2022-03-02T00:12:45.667+00:00 Hello @Vinayak Mathur ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is to copy the BSEG table to Azure , please do let us know if its not accurate.
Let me start with , I am not SAP literate and neither I have an environment to test the ask here . i was reading and I did found this link https://stackoverflow.com/questions/71209436/delta-load-on-bseg-table-into-azure-using-sap-table-conenctor and I am sure if you got a chance to read this before .
You did mentioned "nothing seems to be working" , can you please lets us know what is that you are experiencing any error , any config issues etc .Please do let me if you have any queries.
Thanks
Himanshu -
Vinayak Mathur 6 Reputation points
2022-03-02T20:29:10.99+00:00 Hi @HimanshuSinha-msft ,
When I am trying to load data from BSEG table into Azure Synapse, I get an error saying
Operation on target Copy_z0z failed: ‘Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to invoke function /SAPDS/RFC_READ_TABLE2 with error: SAP.Middleware.Connector.RfcAbapRuntimeException, message: No more memory available to add rows to an internal table., stacktrack: at SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg() at SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count) at SAP.Middleware.Connector.RfcConnection.ReadRfcIDBegin(Int32& length) at SAP.Middleware.Connector.RfcConnection.ReadUpTo(RFCGET readState, RfcFunction function, RFCID toRid) at SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function) at SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream) Boolean initStatefulSession, Boolean checkForErrors) at Microsoft.Practices.TransientFaultHandling.RetryPolicy.,Source=Microsoft.DataTransfer.Runtime.SapRfcHelper,”Type=SAP.Middleware.Connector.RfcAbapRuntimeException,Message=No more memory available to add rows to an internal table.,Source=sapnco,
I know this is because the data I am trying to load is too large, I have tried to go for the smallest chunk and yet I am facing this issue.
We cannot increase the memory on SAP Server, I need help with some approaches on the Azure end.So far I have used partition option in Azure
Increasing/Reducing Parallelism
I need some other approach or way to get this data.Thanks!
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 69%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Basith, Mohamed 0 Reputation points2024-01-08T11:34:58.32+00:00 Hi Vinayak.,
Any updated solution for the above issue?
Sign in to comment
Sign in to answer