We want to compare data in our BI system and OLTP. So we created a multiprovider containing a basic infoprovider and a virtual infoprovider. The virtual infoprovider is based on dtp.
Now we have a problem with queries running on the multiprovider. A TSV_TNEW_PAGE_ALLOC_FAILED shortdump occurs on the OLTP. After some SQL tracing i discovered that the selection criteria used in the query are discarded. As a result of that the extractor tries to read to complete sourcetable into memory. The same problem occurs when using listcube.
Same query directly on the virtual infoprovider however runs OK and uses the correct filter values in the SQL statement on OLTP.
Any ideas anyone ?