Qliksense Timeout issue while loading MSEG

[swapna_shree]

Hi All,

Greetings of the day,

I have been facing problem in loading MSEG Table . Previously I was getting  was Timeout error. 

After I increased the Timeout , now it is getting connected but no data is getting fetched from SAP MSEG .

Can anyone suggest the ways to optimise the extractor and load the MSEG Data . 

Regards,

swapna

[Hakan_Ronningberg]

Hi,

Are you using the Qlik SAP connector?

Avoid a statement like SELECT * FROM MSEG.

Instead select only the fields you need like:

SELECT MBLNR MJAHR ZEILE BWART MATNR WERKS
FROM MSEG

Or use a condition where the key fields are included like:

SELECT * FROM MSEG
WHERE MJAHR = 2021

Regards,
Håkan

[swapna_shree]

Hi I am using Qlik SAP Connector.

Load
MBLNR, // as [Number of Material Document],
MJAHR, // as [Material Document Year],
ZEILE, // as [Item in Material Document],
BWART AS BWART, // as [Movement Type (Inventory Management)],
MATNR as MATNR, // as [Material Number],
WERKS AS WERKS, // as Plant,
LGORT AS LGORT, // as [Storage Location],
INSMK, // as [Stock Type],
SHKZG, // as [Debit/Credit Indicator],
WAERS, // as [Currency Key],
DMBTR AS DMBTR, // as [Amount in Local Currency],
BWTAR, // as [Valuation Type],
MENGE AS MENGE, // as Quantity,
MEINS, // as [Base Unit of Measure],
ERFMG, // as [Quantity in Unit of Entry],
EBELN, // as [Purchase Order Number],
KOSTL ,
EBELP, // as [Item Number of Purchasing Document],
date(BUDAT_MKPF,'DD-MM-YYYY') AS BUDAT_MKPF, //as [Posting Date in the Document],
Date(CPUDT_MKPF,'DD-MM-YYYY') AS CPUDT_MKPF, // as [Day On Which Accounting Document Was Entered],
CPUTM_MKPF ;

SELECT
MBLNR, // as [Number of Material Document],
MJAHR, // as [Material Document Year],
ZEILE, // as [Item in Material Document],
BWART, // as [Movement Type (Inventory Management)],
MATNR, // as [Material Number],
WERKS, // as Plant,
LGORT, // as [Storage Location],
INSMK, // as [Stock Type],
SHKZG, // as [Debit/Credit Indicator],
WAERS, // as [Currency Key],
DMBTR, // as [Amount in Local Currency],
BWTAR, // as [Valuation Type],
MENGE, // as Quantity,
MEINS, // as [Base Unit of Measure],
ERFMG, // as [Quantity in Unit of Entry],
EBELN, // as [Purchase Order Number],
KOSTL,
EBELP, // as [Item Number of Purchasing Document],
BUDAT_MKPF, //as [Posting Date in the Document],
CPUDT_MKPF, // as [Day On Which Accounting Document Was Entered],
CPUTM_MKPF // as [Time of Entry]
FROM MSEG
where CPUDT_MKPF> '20220815';// '$(vDate)';

for yesterdays data but i am not getting any record from sap 

can anyone suggest what is the timeout batch and timeout fetch value to be ??

I have increased but no response.

Regards,

Swapna

[Hakan_Ronningberg]

You can read about the timeouts here under 'Connection string properties':

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Clients...

If it does not work, there are log files here, where you can find the reason:
C:\ProgramData\QlikTech\Custom Data\xxx\Log (for QlikView) or C:\ProgramData\Qlik\Custom Data\xxx\Log (for Qlik Sense).
You may have to look in more than one log for the same job.

You can also check the job log in SAP in transaction SM37 for job /QTQVC/READ_DATA.

Regards,
Håkan