Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SAP Connector Problem? Custom read failed

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

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

8 Replies
danielrozental
Master II
Master II

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

Not applicable

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)

danielrozental
Master II
Master II

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.

Not applicable

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

danielrozental
Master II
Master II

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

Not applicable

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

Not applicable

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

View solution in original post

Not applicable

how we can do that