topic Re: Table Extraction Issue in QlikView

Table Extraction Issue

asmitagg — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I m fetching records from SAP for one of the table, but after sometime the lines fetching stops but the Elapsed time still continues to run.

Due to this the application fails after waiting for 6 hours (which is the maximum limit).

I have also checked the Log file but cannot find any error.

Please suggest what might be the problem.

Thanks in advanced

Regards,

Asmita

Re: Table Extraction Issue

handry_orozco — Thu, 01 Feb 2018 16:42:14 GMT

Please give me the query that you are implementing to the database

thanks u

Re: Table Extraction Issue

buzzy996 — Thu, 01 Feb 2018 16:52:53 GMT

try with where clause to load top 100 1st time,top 1000 2nd time and see

when it's failing?

Re: Table Extraction Issue

asmitagg — Fri, 02 Feb 2018 14:45:09 GMT

SQL SELECT "columns /fields to extract 1...N" FROM TABLE;

Here I m not using Select * from table.

I have taken only those columns which are required .Its simple fulload of table.

Re: Table Extraction Issue

handry_orozco — Fri, 02 Feb 2018 17:17:27 GMT

yUou should try doing the extraction by year or month. Sometimes the available memory for the extraction collapses and causes error to occur

Re: Table Extraction Issue

Peter_Cammaert — Fri, 02 Feb 2018 17:35:29 GMT

Are you using the SAP Connector?

Re: Table Extraction Issue

handry_orozco — Fri, 02 Feb 2018 20:17:02 GMT

The result of the select from the main table is temporarily stored in the ABAP program in an internal table. There is a size limitation to internal tables, so try to avoid SELECT *. Only select the fields necessary.

SQL SUBSELECT syntax ‒ Qlik Connectors

Re: Table Extraction Issue

asmitagg — Sat, 03 Feb 2018 04:23:43 GMT

Yes

Re: Table Extraction Issue

asmitagg — Sat, 03 Feb 2018 04:29:15 GMT

Hi Handry,

I m selecting limited fields only which are required.

What I observed is when I try loading combination of these fields the are working fine ,but when I add ZFBDT which is Date filed the extraction stops.

Also tried to fetch data only with this single field it is not working.

is there any problem with this field?

Re: Table Extraction Issue

Peter_Cammaert — Mon, 05 Feb 2018 09:32:23 GMT

I ask this because a series of SAP Connector releases had problems extracting Date fields from specific tables. A customer of mine had exactly the same problem as you described when trying to extract data with date fields using SAP Connector 6.1.1.

In the last quarter of 2016, we were advised to upgrade to at least 6.3.1 or later to fix this issue. Which it did, thank god. I guess all SAP Connector releases between 6.1 and 6.3 are affected.

The current release is 6.6. Which one are you running?

Re: Table Extraction Issue

asmitagg — Fri, 23 Feb 2018 06:17:52 GMT

Hi Peter,

Currently I m using SAP Connector 6.1.1

How do I upgrade it to 6.3.1 or next version?

Does this affect on other application?

Re: Table Extraction Issue

Peter_Cammaert — Fri, 23 Feb 2018 09:12:47 GMT

Upgrade: download and run the installer. You may have to enter your licensing information again (something has changed in 6.2). The version jump from 6.1.1 to 6.6 will probably also require you to update the Transports in SAP. See further for a document that can supply information about these "issues".

Impact on other applications: yes it may impact your next data stage as the data output by the SAP connector may undergo format and type changes. The newer SAP Connectors (>=6.1 I think but better check this to be sure) now do a lot of value interpretation and formatting themselves. The main changes can be switched off by setting three to four parameters. Hakan Ronningberg keeps a nice overview of all SAP Connector modifications and new features for all releases since 5.6 in a PDF file that can be downloaded together with the installer. The current one is called "Qlik Connector for SAP Release Notes - Summary 5.6-6.6.pdf".

If you are able to perform tests (i.e. upgrade a DEV or QA SAP System first and check the output) please do so to make sure that your upgrade will be able to handle all implied changes.

Re: Table Extraction Issue

handry_orozco — Mon, 26 Feb 2018 14:26:28 GMT

Hi,

When you add the ZFBDT field you are probably returned more than one date of archiving for a record. You can try extracting the table containing the ZFBDT field separately and then doing the JOIN in qlik