Hello Everyone!
We are facing issues while loading data from SAP BW using QvSAPEXTRConnector.The log file is as follows:
2018-01-10 03:07:30 Connector: C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll Ver: 5.90 IR, Build: 00114
2018-01-10 03:07:30 Using Server Host: xyz.za.bc.def.net , Port: 8680
2018-01-10 03:07:30 Host address using getaddrinfo.
2018-01-10 03:07:31 Connected to SAP (ASHOST): abc.za.bc.def.net
2018-01-10 03:07:31 Making new SAP Request
2018-01-10 03:07:31 EXTRACTOR = 8ZUK_ICMA3
2018-01-10 03:07:31 TFRMETHOD = T
2018-01-10 03:07:31 UPDMODE = F
2018-01-10 03:07:31 EXTRLANGUAGE = E
2018-01-10 03:07:31 LOGSYS = QTQVCEXTR1
2018-01-10 03:07:31 EXTRACTOR 8ZUK_ICMA3#TFRMETHOD T#UPDMODE F#EXTRLANGUAGE E#LOGSYS QTQVCEXTR1#WHERE#CALMONTH I BT 201712 201801#SALESORG I EQ J30#
2018-01-10 03:07:31 TimeoutSAP :14400
2018-01-10 03:07:31 TimeoutInit :900
2018-01-10 03:07:31 TimeoutActivity :7200
2018-01-10 03:07:31 TimeoutData :3600
2018-01-10 03:07:31 Received Meta Data, No of Fields: 96
2018-01-10 03:07:32 Information from server: INFOMSG : Started job: REQU_QTQVCEXTR1_20180110030732
2018-01-10 03:14:53 Received: /BIC/QA8ZUK_ICMA3001, Rows: 426, Total Rows: 426
2018-01-10 03:15:16 Information from server: INFOMSG : Job reported complete, but packets are still missing. Amount left: 1
2018-01-10 03:15:47 Information from server: INFOMSG : Job reported complete, but packets are still missing. Amount left: 1
2018-01-10 03:16:18 Information from server: INFOMSG : Job reported complete, but packets are still missing. Amount left: 1
And then the last line will keep repeating.
One more thing to add, we have cluster of two servers.
We have added xyz.za.bc.def.net in the connection string, as we can see in the log above,
whereas the second server is xyz1.za.bc.def.net
Our QvNetworkServer service is running properly on both servers.
We have also noticed that after stopping the tasks from either QMC (present on xyz.za.bc.def.net) or while running them locally, the corresponding RFC connection user sessions in SAP BW (SM04) are not getting deleted automatically.
Could someone please help in resolving this issue?
Let me know if any additional information is required.
Thanks and Best Regards,
Shabaz
Resolved by updating servers and connectors.
Resolved by updating servers and connectors.