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