Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hornichandreas
New Contributor II

ERROR with WHERE DATE Custom read failed

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

Tags (3)
Community Browser