Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have some strange issues with the SAP connector 5.6 SR2 (QV 10 SR4 x64)
The query
select * from mara
returns
Error: QVX_UNEXPECTED_END_OF_DATA: Fetch aborted, due to an unexpected exception. Key = EOF (ID:00 Type:E Number:001 Reading job has reached End Of File)
All data are nevertheless retrieved.
Log:
2012-05-23 12:05:49 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPConnector.dll 5.6, 10755 SR2
2012-05-23 12:05:49 Progress TimeoutIDoc set to: 7200 seconds
2012-05-23 12:05:49 Progress TimeoutSap set to: 14400 seconds
2012-05-23 12:05:49 Progress TimeoutInit set to: 900 seconds
2012-05-23 12:05:49 Progress TimeoutActivity set to: 3600 seconds
2012-05-23 12:05:50 Progress Connected
2012-05-23 12:05:50 Progress Creation of function /QTQVC/OPEN_STREAM returned after 00:00:00
2012-05-23 12:05:50 Progress Creation of function /QTQVC/FETCH_STREAM returned after 00:00:00
2012-05-23 12:05:50 Progress OpenStream called with SQL = "select * from mara", PACKETSIZE = 20000, TRACE = "0", TIMEOUT_BATCH = "600", CHECK_SEPARATOR = "0", CONVROUTINE = "0"
2012-05-23 12:05:50 Progress OpenStream invoked. Jobnumber is 20120523120550
2012-05-23 12:05:50 Progress Jobnumber is 20120523120550
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:50 Progress Reply from FetchStream received
2012-05-23 12:05:50 Progress 1 ms delay
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:50 Progress Reply from FetchStream received
2012-05-23 12:05:50 Progress 2 ms delay
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:50 Progress Reply from FetchStream received
2012-05-23 12:05:50 Progress 4 ms delay
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:50 Progress Reply from FetchStream received
2012-05-23 12:05:50 Progress 8 ms delay
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:50 Progress Reply from FetchStream received
2012-05-23 12:05:50 Progress 16 ms delay
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:50 Progress Reply from FetchStream received
2012-05-23 12:05:50 Progress 32 ms delay
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:50 Progress Reply from FetchStream received
2012-05-23 12:05:50 Progress 64 ms delay
2012-05-23 12:05:50 Progress Calling FetchStream
2012-05-23 12:05:53 Progress Reply from FetchStream received
2012-05-23 12:05:53 Error RFC_INVALID_PARAMETER
2012-05-23 12:05:53 Progress Successful fetch of 1304 rows
2012-05-23 12:05:53 Progress Calling FetchStream
2012-05-23 12:05:54 Progress Reply from FetchStream received
2012-05-23 12:05:54 Error RFC_INVALID_PARAMETER
2012-05-23 12:05:54 Progress Successful fetch of 1304 rows
2012-05-23 12:05:55 Progress Calling FetchStream
2012-05-23 12:05:55 Progress Reply from FetchStream received
2012-05-23 12:05:55 Error RFC_INVALID_PARAMETER
2012-05-23 12:05:55 Progress Successful fetch of 334 rows
2012-05-23 12:05:55 Progress Calling FetchStream
2012-05-23 12:05:55 Progress Reply from FetchStream received
2012-05-23 12:05:55 Error Fetch aborted, due to an unexpected exception. Key = EOF (ID:00 Type:E Number:001 Reading job has reached End Of File)
2012-05-23 12:05:55 Progress Disconnected
Regards,
David
Please check authorization provided in SAP becasue as per your log connection established successfully.
I had the same error.
After reinstalling the transports to the SAP System (check all options: Import again, Overwrite objects in unconfirmed repairs, Overwrite originals), the error vanished.
It maybe that after an upgrade, not all objects are overwritten.
As I mentioned earlier , It is able to eastablish connection with SAP Environment but after that your Open stream , Fetch stream method of RFC is not functioning.
please check SAP R/3 log generated for Qlikview.
let me know if you are still not able to solve it.