Table Extraction Issue

[asmitagg]

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

[handry_orozco]

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

thanks u

[buzzy996]

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

when it's failing?

[asmitagg]

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.

[handry_orozco]

Hi

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

[Peter_Cammaert]

Are you using the SAP Connector?

[handry_orozco]

Hi

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

[asmitagg]

Yes

[asmitagg]

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?

[Peter_Cammaert]

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?