topic Re: SAP Connector Problem? Custom read failed in QlikView

SAP Connector Problem? Custom read failed

Thu, 30 Jun 2011 18:32:35 GMT

30.06.2011 06:01:15: 0142 SQL Select OBJID SPRAS KTEXT from CRTX
30.06.2011 06:01:15: 0143 where SPRAS = 'D'
30.06.2011 06:01:15:           2 fields found: Object_Key, Object Description, Error: Custom read failed
30.06.2011 07:11:10:       General Script Error
30.06.2011 07:11:10:       Execution Failed
30.06.2011 07:11:10:      Execution finished.

HI Guys,

In Last days sometimes the jobs work and sometimes the Jobs dont run which are based on SAP.

The Logs show the above problem in the attached script. Nothing is changed in the script on the Qlikview Side. It works when I manually load only that table. Everything is same and I wonder why this Problem is arising. Can anyone explain?

Thanks

Sravan

SAP Connector Problem? Custom read failed

danielrozental — Thu, 30 Jun 2011 19:04:49 GMT

You should enable the sap connector log and look at that when a process fails.

SAP Connector Problem? Custom read failed

Thu, 30 Jun 2011 19:09:51 GMT

Hi Daniel,

Thanks for your answer.

This is in the SAP LOG. Can you please tell whats the problem might be?

2011-06-30 02:11:02    Progress    Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPConnector.DLL 5, 5, 8698 SR3
2011-06-30 02:11:02    Error    Fetch aborted 4194303 s after first try, since the batch process in SAP did not start Key = TIMEOUT_READ_DATA (ID:00 Type:E Number:001 Timeout - Reading job has not started)
2011-06-30 02:11:02    Error    /QTQVC/FETCH_STREAM failed after 00:00:00 Key = RFC_INVALID_HANDLE (An invalid handle was passed to the API call)
2011-06-30 02:11:02    Error    /QTQVC/FETCH_STREAM failed after 00:00:00 Key = RFC_INVALID_HANDLE (An invalid handle was passed to the API call)

SAP Connector Problem? Custom read failed

danielrozental — Thu, 30 Jun 2011 19:12:22 GMT

Sorry, I don't have a clue. Seems like it might be a SAP related problem, you might want to talk to support about it.

Re: SAP Connector Problem? Custom read failed

Thu, 30 Jun 2011 19:48:17 GMT

Hi Daniel,

I sent a email to support. I wonder what has happened on the SAP Side. Until yesterday everything was correct and today suddenly this problem. I did not change anything in Script or settings in Qlikview side..

May be someone can help me.

Thanks anyway

Regards

Sravan

Re: SAP Connector Problem? Custom read failed

danielrozental — Thu, 30 Jun 2011 19:52:19 GMT

If this is something that just started happening out of the blue you should also try restarting the server.

Re: SAP Connector Problem? Custom read failed

Fri, 01 Jul 2011 07:34:25 GMT

Hi Daniel,

Thanks I did it but could not Test because this happened only in the Night when the Jobs are planned.

011-06-30 02:11:02 Error Fetch aborted 4194303 s after first try, since the batch process in SAP did not start

I wonder what this Batch Process in SAP means?

Regards
Sravan

Re: SAP Connector Problem? Custom read failed

Mon, 04 Jul 2011 07:00:51 GMT

Hi,

For the People who may face this problem in future, increase the TimeOutFetch Parametre in Qlikview. Standard is 1200 Sec and I made it to 2000.

Thanks

Sravan

Re: SAP Connector Problem? Custom read failed

Wed, 01 Oct 2014 06:09:26 GMT

how we can do that