0 Replies Latest reply: Nov 23, 2012 8:34 AM by Andreas Hornich RSS

    ERROR with WHERE DATE Custom read failed

    Andreas Hornich

      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