Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
We're using the QlikView SAP Extractor connector to load SAP hierarchies to QlikView. For each of the following data sources we have a specific QvD-GeneratorFile to load the data to QlikView:
0ACCOUNT_0109_HIER, 0COORDER_0103_HIER, 0COSTCENTER_0101_HIER, 0COSTELMNT_0102_HIER, 0PROFIT_CTR_0106_HIER
Last weekend we did a SAP Upgrade to:
SAP Basis NW 7.40, SP 5
SAP ECC 6.0, EhP 7, SP3
Unfortunately since then the QlikView Publisher process chain to load the above hierarchies doesn't succeed any more (Err Timeout while waiting for SAP data => see attached LOG-File). According to the log files in QlikView and SAP the IDoc files are correctly provided by SAP, but the QlikView Extractor Connector doesn't collect the requested data and therefore runs in a timeout after 7200s. This results in a failed task in the QMC, the according jobstatus in the SAP table /QTQVC/STATUS remains S (started) and all following QlikView Extractor tasks will fail.
As the load process succeeds from time to time when exectued manually the scirpt should not be the problem.
We already had a similar problem before when loading the hierarchy structure E1RSHIV:
SQL EXTRACTOR $(vTABLE)
UPDMODE H // Hierarchy extractor
TFRMETHOD I // Idoc transfer method
HIERARCHY $(vHIER_NAME)
HIERLANGUAGE English
HIERTABLE E1RSHIV
LOGSYS QTQVCEXTR1
// E1RSHND - Data transfer Idoc: Hierarchy nodes
// E1RSHIV - Data transfer Idoc: Hierarchy intervals
// E1RSHFT - Data transfer Idoc: Name of node that cannot be posted to
In this case whenever an hiearchy doesn't contains any intervals but just direct assigned nodes, no data will be selected by the above request. Unfortunately QlikView doesn't seem to notice this and will wait till timeout is reached. This particular problem was already reported quite a while ago to Qlik Support but isn't still confirmed or solved. But as built a workaround with an if clause to check whether an interval exists, this sholudn't be the problem this time.
Any help would be greatly appreciated.
Thanks
Thomas
Bug was corrected with QlikView SAP Connector 5.8 SR4
Extract from Release notes:
When using the IDOC method for the connector (extracting hierarchies) there was a timing issue between SAP and QV SAP Network server. SAP was sending data packets before the job was properly registered. This resulted in lost packages and the reload failed. This is now corrected.
Hi! Any news on the matter? I happen to have the same problem, the same extractor was working every day and suddenly yesterday did this strange log:
Reloading..........
(2014-08-03 23:13:27) Information: Slow down logging. Log every <300> seconds.
(2014-08-04 00:03:27) Information: Reloading..........
(2014-08-04 00:08:27) Information: Slow down logging. Log every <600> seconds.
(2014-08-04 00:08:27) Information: Reloading
(2014-08-04 00:10:13) Information: The Source Document reload complete.
(2014-08-04 00:10:13) Information: Memory Allocation Delta for this file=5.11 Mb. Available Physical Memory Before Reload=9318.91 Mb. Available Physical Memory After Reload=9176.71 Mb. Total Physical Memory=9176.71 Mb.
(2014-08-04 00:10:14) Error: The Source Document was NOT reloaded successfully.
(2014-08-04 00:10:14) Information: Closing the document.
(2014-08-04 00:10:14) Information: Closed the QlikView Engine successfully. ProcessID=4412
(2014-08-04 00:10:15) Error: The task "Extract/ExtractRTP.qvw" failed.
Thanks!
HJU
Even after updating to the last SAP Connector release 5.8 SR3 Build 8 we still have problems to load hierarchies with the SAP Connector. Currently it's not a timeout problem anymore but a general script error.
Recommendation of Qlik Support was to change to tRFC Load, but as this can't be changed on SAP side so far there is no improvement. Currently the problem is at Qlik R&D.
Please make sure to open a support case with Qlik, so they become aware that there is a problem regarding the use of the SAP Connector.
Do you have BW in your landscape?
If yes, you can try to extract the hierarchies from BW
Bug was corrected with QlikView SAP Connector 5.8 SR4
Extract from Release notes:
When using the IDOC method for the connector (extracting hierarchies) there was a timing issue between SAP and QV SAP Network server. SAP was sending data packets before the job was properly registered. This resulted in lost packages and the reload failed. This is now corrected.