topic Re: Qliksense Timeout issue while loading MSEG in Connectivity & Data Prep

Qliksense Timeout issue while loading MSEG

swapna_shree — Tue, 16 Aug 2022 11:28:25 GMT

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

Re: Qliksense Timeout issue while loading MSEG

Hakan_Ronningberg — Tue, 16 Aug 2022 12:01:01 GMT

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

Re: Qliksense Timeout issue while loading MSEG

swapna_shree — Tue, 16 Aug 2022 12:09:35 GMT

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

Re: Qliksense Timeout issue while loading MSEG

Hakan_Ronningberg — Tue, 16 Aug 2022 12:22:34 GMT

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/Using-SAP-SQL-connection.htm

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