体验中心，数据模型抽取失败

 

体验中心数据模型抽取失败

 

 

错误日志：

smartbix.SmartbiXException: SQL错误: insert into `smartbimpp`.`I8aaa81f9018720bd20bd143c0187271b83360fd3_temp` select `column1` as `column1`, `column2` as `column2`, toString(toYear( toDate(`T0`.`column2`) ))  || '-' || if(toMonth(toDate(`T0`.`column2`)) < 10, '0' || toString(toMonth(toDate(`T0`.`column2`))), toString(toMonth(toDate(`T0`.`column2`)))) || '-' || if(toDayOfMonth( toDate(`T0`.`column2`) ) < 10, '0' || toString(toDayOfMonth( toDate(`T0`.`column2`) )), toString(toDayOfMonth( toDate(`T0`.`column2`) ))) as `column2_Day`, toString(toYear( toDate(`T0`.`column2`) ))  || '-' || if(toMonth(toDate(`T0`.`column2`)) < 10, '0' || toString(toMonth(toDate(`T0`.`column2`))), toString(toMonth(toDate(`T0`.`column2`)))) as `column2_Month`, toString(toYear( toDate(`T0`.`column2`) ))  as `column2_Year`, `column3` as `column3`, `column4` as `column4`, `column5` as `column5`, `column6` as `column6`, `column7` as `column7`, `column8` as `column8`, `column9` as `column9`, `column10` as `column10`, `column11` as `column11`, `column12` as `column12`, `column13` as `column13`, `column14` as `column14`, `column15` as `column15`, `column16` as `column16`, `column17` as `column17`, `column18` as `column18`, `T0`.`viewId` as `viewId` from (select `sdpkgb20bb42b001872714f0a97ec0`.`column1` as `column1`, `sdpkgb20bb42b001872714f0a97ec0`.`column2` as `column2`, `sdpkgb20bb42b001872714f0a97ec0`.`column3` as `column3`, `sdpkgb20bb42b001872714f0a97ec0`.`column4` as `column4`, `sdpkgb20bb42b001872714f0a97ec0`.`column5` as `column5`, `sdpkgb20bb42b001872714f0a97ec0`.`column6` as `column6`, `sdpkgb20bb42b001872714f0a97ec0`.`column7` as `column7`, `sdpkgb20bb42b001872714f0a97ec0`.`column8` as `column8`, `sdpkgb20bb42b001872714f0a97ec0`.`column9` as `column9`, `sdpkgb20bb42b001872714f0a97ec0`.`column10` as `column10`, `sdpkgb20bb42b001872714f0a97ec0`.`column11` as `column11`, `sdpkgb20bb42b001872714f0a97ec0`.`column12` as `column12`, `sdpkgb20bb42b001872714f0a97ec0`.`column13` as `column13`, `sdpkgb20bb42b001872714f0a97ec0`.`column14` as `column14`, `sdpkgb20bb42b001872714f0a97ec0`.`column15` as `column15`, `sdpkgb20bb42b001872714f0a97ec0`.`column16` as `column16`, `sdpkgb20bb42b001872714f0a97ec0`.`column17` as `column17`, `sdpkgb20bb42b001872714f0a97ec0`.`column18` as `column18`, '订单' as `viewId` from `smartbimpp`.`sdpkgb20bb42b001872714f0a97ec0` `sdpkgb20bb42b001872714f0a97ec0`)`T0` -> ClickHouse exception, code: 60, host: 172.17.11.220, port: 31823; Code: 60, e.displayText() = DB::Exception: Table smartbimpp.sdpkgb20bb42b001872714f0a97ec0 doesn't exist (version 21.6.6.51 (official build))

    at smartbix.SmartbiXException.create(SmartbiXException.java:68)
    at smartbix.smartbi.service.GridDataServiceHandler.handle(GridDataServiceHandler.java:118)
    at sun.reflect.GeneratedMethodAccessor967.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at smartbixlibs.org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
    at smartbixlibs.org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
    at smartbixlibs.org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
    at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
    at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
    at smartbix.dataprocess.service.DatabaseResultService$$EnhancerBySpringCGLIB$$f9f58b4a.executeUpdateSql()
    at smartbix.augmenteddataset.repository.service.AugmentedDatabaseResultService.executeUpdateSql(AugmentedDatabaseResultService.java:137)
    at smartbix.augmenteddataset.extract.AugmentedMppLoadService.loadData(AugmentedMppLoadService.java:196)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor$1.call(SingleThreadedExtractor.java:308)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor$1.call(SingleThreadedExtractor.java:246)
    at smartbix.augmenteddataset.extract.ExtractTaskWrapper.call(ExtractTaskWrapper.java:40)
    at smartbix.util.ThreadUtil$SubmitRunnable.call(ThreadUtil.java:220)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    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: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 60, host: 172.17.11.220, port: 31823; Code: 60, e.displayText() = DB::Exception: Table smartbimpp.sdpkgb20bb42b001872714f0a97ec0 doesn't exist (version 21.6.6.51 (official build))

    at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:59)
    at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:29)
    at ru.yandex.clickhouse.ClickHouseStatementImpl.checkForErrorAndThrow(ClickHouseStatementImpl.java:1099)
    at ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:778)
    at ru.yandex.clickhouse.ClickHouseStatementImpl.getLastInputStream(ClickHouseStatementImpl.java:692)
    at ru.yandex.clickhouse.ClickHouseStatementImpl.executeUpdate(ClickHouseStatementImpl.java:434)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at smartbix.dataprocess.service.DatabaseResultService.executeUpdateSql(DatabaseResultService.java:545)
    at smartbix.dataprocess.service.DatabaseResultService$$FastClassBySpringCGLIB$$7e915f15.invoke()
    at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
    at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    at smartbixlibs.org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:102)
    at smartbix.smartbi.service.GridDataServiceHandler.handle(GridDataServiceHandler.java:93)
    ... 23 more
Caused by: java.lang.Throwable: Code: 60, e.displayText() = DB::Exception: Table smartbimpp.sdpkgb20bb42b001872714f0a97ec0 doesn't exist (version 21.6.6.51 (official build))

    at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:54)
    ... 39 more

右键编辑，重新上传一次Excel看看吧，可能是之前高速缓存库里的数据没了

亲爱的麦粉您好，如果问题得到解答的话可以采纳最佳回复闭环问题哦~，会有麦豆奖励的哟