Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You should enable the sap connector log and look at that when a process fails.
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)
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.
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
If this is something that just started happening out of the blue you should also try restarting the server.
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
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
how we can do that