Hello Team,
Have implemented Impala connectivity with Tableau and for some reason some
dashboards are failing with error as :
com.tableausoftware.nativeapi.exceptions.DataSourceException:
[Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala:
[08S01] : ImpalaThriftAPICallFailed
Dashboard is getting refreshed on Tableau Desktop but giving above error on
Tableau Server.
Impala version -ClouderaImpalaODBC 2.6.2.1002-1.x86_64
Tableau Server - 2018.3 and Centos OS
Impala Log and Tableau Log file as attached. Please let me know how can
this be resolved and fixed.
We can discuss over call as well if needed any inputs from my end
Thanks,
Mallika Singhi
9920028229
BI Team
{\rtf1\ansi\ansicpg1252\cocoartf1671\cocoasubrtf600
{\fonttbl\f0\fswiss\fcharset0 ArialMT;\f1\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;\red26\green26\blue26;\red255\green255\blue255;\red16\green60\blue192;
\red239\green239\blue239;}
{\*\expandedcolortbl;;\cssrgb\c13333\c13333\c13333;\cssrgb\c100000\c100000\c100000;\cssrgb\c6667\c33333\c80000;
\cssrgb\c94902\c94902\c94902;}
\paperw11900\paperh16840\margl1440\margr1440\vieww28600\viewh15600\viewkind0
\deftab720
\pard\pardeftab720\sl300\partightenfactor0
\f0\fs20 \cf2 \expnd0\expndtw0\kerning0
\outl0\strokewidth0 \strokec2 \
\pard\pardeftab720\sl300\partightenfactor0
\cf2 \cb3 I0108 16:10:28.779225 29174 thrift-util.cc:123] TAcceptQueueServer client died: SSL_write: Connection reset by peer\cb1 \
\cb3 I0108 16:10:28.779253 29174 impala-server.cc:2012] Connection from client\'a0{\field{\*\fldinst{HYPERLINK "http://10.51.3.182:39058/"}}{\fldrslt \cf4 \ul \ulc4 \strokec4 10.51.3.182:39058}}\'a0closed, closing 1 associated session(s)\cb1 \
\cb3 I0108 16:10:28.779261 29174 impala-server.cc:1260] Closing session: 864f45a63e88c92a:15312d5d59530da3\cb1 \
\cb3 I0108 16:10:28.779273 29174 impala-server.cc:1142] UnregisterQuery(): query_id=904c8ee6ee83bba7:3fc915c600000000\cb1 \
\cb3 I0108 16:10:28.779280 29174 impala-server.cc:1249] Cancel(): query_id=904c8ee6ee83bba7:3fc915c600000000\cb1 \
\cb3 I0108 16:10:28.779300 29174 coordinator.cc:488] ExecState: query id=904c8ee6ee83bba7:3fc915c600000000 execution cancelled\cb1 \
\cb3 I0108 16:10:28.779356 29174 coordinator-backend-state.cc:445] Sending CancelQueryFInstances rpc for query_id=904c8ee6ee83bba7:3fc915c600000000 backend=10.51.\cb1 \
\cb3 2.166:27000\cb1 \
\cb3 I0108 16:10:28.779458 24859 control-service.cc:169] CancelQueryFInstances(): query_id=904c8ee6ee83bba7:3fc915c600000000\cb1 \
\cb3 I0108 16:10:28.779467 24859 query-exec-mgr.cc:97] QueryState: query_id=904c8ee6ee83bba7:3fc915c600000000 refcnt=5\cb1 \
\cb3 I0108 16:10:28.779474 24859 query-state.cc:649] Cancel: query_id=904c8ee6ee83bba7:3fc915c600000000\cb1 \
\cb3 I0108 16:10:28.779482 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000016\cb1 \
\cb3 I0108 16:10:28.779491 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000019\cb1 \
\cb3 I0108 16:10:28.779505 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000000\cb1 \
\cb3 I0108 16:10:28.779515 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c60000000c\cb1 \
\cb3 I0108 16:10:28.779522 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c60000001e\cb1 \
\cb3 I0108 16:10:28.779529 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000021\cb1 \
\cb3 I0108 16:10:28.779527 29207 krpc-data-stream-mgr.cc:295] 904c8ee6ee83bba7:3fc915c600000000] DeregisterRecvr(): fragment_instance_id=904c8ee6ee83bba7:3fc915c600000000, node=31\cb1 \
\cb3 I0108 16:10:28.779547 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000010\cb1 \
\cb3 I0108 16:10:28.779562 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c60000000d\cb1 \
\cb3 I0108 16:10:28.779570 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000013\cb1 \
\cb3 I0108 16:10:28.779577 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000004\cb1 \
\cb3 I0108 16:10:28.779583 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000001\cb1 \
\cb3 I0108 16:10:28.779590 24859 krpc-data-stream-mgr.cc:326] cancelling all streams for fragment_instance_id=904c8ee6ee83bba7:3fc915c600000007\cb1 \
\cb3 I0108 16:10:28.779687 29174 coordinator-backend-state.cc:445] Sending CancelQueryFInstances rpc for query_id=904c8ee6ee83bba7:3fc915c600000000 backend={\field{\*\fldinst{HYPERLINK "http://10.51.2.95:27000/"}}{\fldrslt \cf4 \ul \ulc4 \strokec4 10.51.2.95:27000\
}}\pard\pardeftab720\sl300\partightenfactor0
\cf2 \cb1 \
\
\
\pard\pardeftab720\sl280\partightenfactor0
\f1\fs24 \cf2 \cb5 \
\pard\pardeftab720\sl280\partightenfactor0
\cf2 \cb1 \
\pard\pardeftab720\sl260\partightenfactor0
\fs21 \cf2 \
}{\rtf1\ansi\ansicpg1252\cocoartf1671\cocoasubrtf600
{\fonttbl\f0\fnil\fcharset0 Menlo-Regular;}
{\colortbl;\red255\green255\blue255;\red0\green0\blue0;}
{\*\expandedcolortbl;;\csgray\c0;}
\paperw11900\paperh16840\margl1440\margr1440\vieww10800\viewh8400\viewkind0
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural\partightenfactor0
\f0\fs22 \cf2 \CocoaLigature0 2020-01-08 16:41:35.232 +0530 (Default,,,,767324,:refresh_extracts,-) scheduled-background-job-runner-1 backgrounder: ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - Error executing ba\
ckground job: RefreshExtracts\
java.util.concurrent.ExecutionException: com.tableausoftware.nativeapi.exceptions.DataSourceException: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : ImpalaThriftAPICal\
lFailed\
\
at java.util.concurrent.FutureTask.report(FutureTask.java:122)\
at java.util.concurrent.FutureTask.get(FutureTask.java:206)\
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob_aroundBody2(BackgroundJobRunner.java:309)\
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$AjcClosure3.run(BackgroundJobRunner.java:1)\
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)\
at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:69)\
at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:58)\
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob(BackgroundJobRunner.java:250)\
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs_aroundBody0(BackgroundJobRunner.java:235)\
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$AjcClosure1.run(BackgroundJobRunner.java:1)\
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)\
at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:69)\
at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:58)\
at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs(BackgroundJobRunner.java:211)\
at com.tableausoftware.backgrounder.config.BackgroundJobRunnerSchedulingConfig.lambda$scheduleTask$0(BackgroundJobRunnerSchedulingConfig.java:42)\
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)\
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)\
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)\
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)\
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\
at java.lang.Thread.run(Thread.java:748)\
Caused by: com.tableausoftware.nativeapi.exceptions.DataSourceException: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : ImpalaThriftAPICallFailed\
\
\
\
}
