ERROR with WHERE DATE Custom read failed

Anonymous — Mon, 26 Jan 2026 21:26:37 GMT

Dear Community,

i am running into a error when selecting an interval within a SAP BW Query.

Using the SAPConnector i use the following simple code to extract a time slice.

I suppose that it got something to do with the syntax i use in the date interval but this is the only way it is working.

Surprisingly the data seems to load correctly and stores the expected amount of data.

Any ideas? Which syntax are you using for Selecting TimeIntervals?

[/BIC/MTBWCORDNR]:
Load *;
SQL SELECT * FROM /BIC/MTBWCORDNR WHERE 
    DATETO = '99991231' AND
    /BIC/TBWCF2DI >= '20121001' AND /BIC/TBWCF2DI <= '20121031';
Store * from [/BIC/MTBWCORDNR] into MTBWCORDNR_20121031_20121031.QVD;
Drop table [/BIC/MTBWCORDNR];

I get the following error pop-up

Custom read failed
SQL SELECT * FROM /BIC/MTBWCORDNR WHERE 
            DATETO = '99991231' AND
            /BIC/TBWCF2DI >= '20110101' AND /BIC/TBWCF2DI <= '20110131'

The error message in the LOAD window echoes the following:

Error: QVX_UNEXPECTED_END_OF_DATA: Fetch aborted. Key = RFC_COMMUNICATION_FAILURE (

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR internal error

TIME Fri Nov 23 14:18:42 2012

RELEASE 720

COMPONENT NI (network interface)

VERSION 40

RC -1

MODULE nixxi.cpp

LINE 4885

DETAIL NiIRead: invalid data (0xa7b7fddd); probably RAW_IO

COUNTER 353

topic ERROR with WHERE DATE Custom read failed in QlikView

ERROR with WHERE DATE Custom read failed