本帖最后由 zuzu 于 2023-4-6 11:30 编辑
体验中心数据模型抽取失败
错误日志：
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 | 
