Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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