Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diogopereira89
Contributor II
Contributor II

Sap Connector Error

HELLO COMMUNITY,


I use Qlik View Connector for SAP, but I´m having problems when trying import one specific table.

SAP cancel my extraction and I receive a message like this:

Error      Fetch aborted, dueto an unexpected exception. Key = JOB_CANCELLED (ID:00 Type:E Number:001 Jobaborted, check log for Job /QTQVC/READ_DATA in Job Overview (transaction SM37))


I saw this error in SM37 that has to do with the alias of a table /BIC/DZ_PUR_C01D.

My SQL command is :

SQL

Select * from /BIC/FZ_PUR_C01 as a1 join /BIC/DZ_PUR_C01D as b1

on a1~KEY_Z_PUR_C01D = b1~DIMID;

I've tried increasing the 'xTimeOutFetch' attribute but still the error continues.

What i did wrong? In other tables i do that "implicit" outer join without any problems

0 Replies