topic Why I cannot load some tables completely? in QlikView

Why I cannot load some tables completely?

rcandeo — Wed, 13 Apr 2011 21:43:32 GMT

I am using SAP Connector, and I have to put some filters in tables that have a lot of data or the load won't finish.

The problem is that some filters works for sometime and with no explanation they stop working and I have to get the filter off and load almost all the data.

An example is the table QMBEWH where I have to selecti using BWKEY field (my centers are PB01 too PB99)

I've had made this selection:

SQL Select MANDT MATNR BWTAR VPRSV PEINH BWKEY BKLAS LFGJA LBKUM SALK3 VERPR STPRS VKSAL SALKV LFMON from MBEWH WHERE BWKEY > 'PAAA' AND BWKEY < 'QAAA'

This selection didn't bring me anything, so I tried to load all the table like this:

SQL Select MANDT MATNR BWTAR VPRSV PEINH BWKEY BKLAS LFGJA LBKUM SALK3 VERPR STPRS VKSAL SALKV LFMON from MBEWH

In this selection, I had as a result no so much data, and I had no data with BWKEY = 'PB01'

And Then I made this selection:

SQL Select MANDT MATNR BWTAR VPRSV PEINH BWKEY BKLAS LFGJA LBKUM SALK3 VERPR STPRS VKSAL SALKV LFMON from MBEWH WHERE BWKEY = 'PB01'

And with this selection, I've got all the data from PB01 center.

Maybe I have to configure in Qlik View to get all data or have to make some configuration in SAP cause it seems that something is making a limitation in the extraction when there's much data.

Anyone has an idea what's happening here please?

Why I cannot load some tables completely?

Oleg_Troyansky — Wed, 13 Apr 2011 22:04:43 GMT

I might be wrong on this one, but I think SAP applies a limit of up to 1 million data elements for each query like this... For this reason, you need to slice your queries into smaller pieces. Again, I might be totally off, ask Rakesh or someone else who's specializing in SAP...

Why I cannot load some tables completely?

disqr_rm — Wed, 13 Apr 2011 23:32:01 GMT

Thank you Oleg.

What Oleg mentioned is true and applies to SAP BW OLAP connector. It seems you are using SQL Connector so, you should be fine.

In next steps, you may want to check ST22, SM21 and SM37 transaction to see if you find error logs, dumps or any job cancellations.

Also please post your SAP Basis version and transports you have imported in your system.

And if you can provide versions of SAP R/3, QV and SAP Connector, that would be helpful.

Rakesh

Why I cannot load some tables completely?

suniljain — Thu, 14 Apr 2011 11:59:45 GMT

Dear Robson,

pls change the default time out setting of SAP Coonector . it will resolve your problem.

sometimes what happen is QVC is unable to fetch data within default time out period.