Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
asmitagg
Partner - Contributor III
Partner - Contributor III

Table Extraction Issue

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

12 Replies
asmitagg
Partner - Contributor III
Partner - Contributor III
Author

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?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

handry_orozco
Partner - Contributor III
Partner - Contributor III

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