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
