Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

dvasseur
Contributor II

Strange error message with SAP connector (5.6 SR2)

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

3 Replies
suniljain
Honored Contributor

Strange error message with SAP connector (5.6 SR2)

Please check authorization provided in SAP becasue as per your log connection established successfully.

Not applicable

Re: Strange error message with SAP connector (5.6 SR2)

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.

suniljain
Honored Contributor

Re: Strange error message with SAP connector (5.6 SR2)

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.

Community Browser