topic Sap Connector Error in QlikView

topic Sap Connector Error in QlikView https://community.qlik.com/t5/QlikView/Sap-Connector-Error/m-p/618862#M228014 <HTML><HEAD></HEAD><BODY><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">HELLO COMMUNITY,<BR /></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><BR /></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">I use Qlik Vi<SPAN style="color: #000000;">ew Connector for SAP, but I´m having problems when trying import one specific table.</SPAN></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">SAP cancel my extraction and I receive a message like this:</SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> </H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3366ff; font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; font-weight: inherit;">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))</SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN lang="EN-US" style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #000000;"><BR /></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">I saw this error in <SPAN style="color: #3366ff;">SM37</SPAN> that has to do with the alias of a table /BIC/DZ_PUR_C01D.</SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">My SQL command is :</SPAN></H4><H4><SPAN style="color: #3366ff; font-size: 10pt; font-family: arial, helvetica, sans-serif;"> SQL </SPAN></H4><H4><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #3366ff;">Select * from /BIC/FZ_PUR_C01 as a1 join /BIC/DZ_PUR_C01D as b1 </SPAN></H4><H4><SPAN style="color: #3366ff; font-size: 10pt; font-family: arial, helvetica, sans-serif;"> on a1~KEY_Z_PUR_C01D = b1~DIMID;</SPAN></H4><H4></H4><H4></H4><H4><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">I've tried increasing the '<SPAN style="color: #3366ff;">xTimeOutFetch</SPAN>' attribute but still the error continues.</SPAN></H4><H4></H4><H4><SPAN style="color: #000000; font-size: 10pt; font-family: arial, helvetica, sans-serif;">What i did wrong? In other tables i do that "</SPAN><SPAN style="color: #000000; font-size: 10pt; line-height: 1.5em;">implicit" <SPAN style="color: #3366ff;">outer join</SPAN> without any problems</SPAN></H4></BODY></HTML> Tue, 25 Mar 2014 11:33:39 GMT diogopereira89 2014-03-25T11:33:39Z Sap Connector Error https://community.qlik.com/t5/QlikView/Sap-Connector-Error/m-p/618862#M228014 <HTML><HEAD></HEAD><BODY><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">HELLO COMMUNITY,<BR /></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><BR /></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">I use Qlik Vi<SPAN style="color: #000000;">ew Connector for SAP, but I´m having problems when trying import one specific table.</SPAN></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">SAP cancel my extraction and I receive a message like this:</SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> </H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3366ff; font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; font-weight: inherit;">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))</SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN lang="EN-US" style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #000000;"><BR /></SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">I saw this error in <SPAN style="color: #3366ff;">SM37</SPAN> that has to do with the alias of a table /BIC/DZ_PUR_C01D.</SPAN></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></H4><H4 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">My SQL command is :</SPAN></H4><H4><SPAN style="color: #3366ff; font-size: 10pt; font-family: arial, helvetica, sans-serif;"> SQL </SPAN></H4><H4><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #3366ff;">Select * from /BIC/FZ_PUR_C01 as a1 join /BIC/DZ_PUR_C01D as b1 </SPAN></H4><H4><SPAN style="color: #3366ff; font-size: 10pt; font-family: arial, helvetica, sans-serif;"> on a1~KEY_Z_PUR_C01D = b1~DIMID;</SPAN></H4><H4></H4><H4></H4><H4><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #000000;">I've tried increasing the '<SPAN style="color: #3366ff;">xTimeOutFetch</SPAN>' attribute but still the error continues.</SPAN></H4><H4></H4><H4><SPAN style="color: #000000; font-size: 10pt; font-family: arial, helvetica, sans-serif;">What i did wrong? In other tables i do that "</SPAN><SPAN style="color: #000000; font-size: 10pt; line-height: 1.5em;">implicit" <SPAN style="color: #3366ff;">outer join</SPAN> without any problems</SPAN></H4></BODY></HTML> Tue, 25 Mar 2014 11:33:39 GMT https://community.qlik.com/t5/QlikView/Sap-Connector-Error/m-p/618862#M228014 diogopereira89 2014-03-25T11:33:39Z