Symptom
When a BW query is executed, a remote statement is running for a long time, reading from the NLS provider. Currently running remote statements can be retrieved using the following SQL statement:
SELECT * FROM M_REMOTE_STATEMENTS WHERE REMOTE_STATEMENT_STATUS = 'EXECUTING'
By observing the FETCHED_RECORD_COUNT, it can be verified that a large number of records is retrieved from the remote source.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP HANA, platform edition 2.0
- SAP Business Warehouse
- SAP BW/4HANA
Product
Keywords
KBA , HAN-DB-PERF , SAP HANA Database Performance , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.