抽取数据失败

时间层次结构必须包含年层次，且时间大小的顺序是从上到下依次排列，以下层次结构不符合要求：日期_时间维度

日志为:

smartbix.SmartbiXException: SQL错误: insert into "smartbimppmd"."I402883920183a6d7a6d71c490183a6d71c490000_temp" select "column1" as "column1", null as "column1_Month", null as "column1_Year", "column2" as "column2", "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", "column19" as "column19", "column20" as "column20", "column21" as "column21", "column22" as "column22", "column23" as "column23", "column24" as "column24", "column25" as "column25", "column26" as "column26", "column27" as "column27", "column28" as "column28", "column29" as "column29", "column30" as "column30", "column31" as "column31", "column32" as "column32", "column33" as "column33", "column34" as "column34", "column35" as "column35", "column36" as "column36", "column37" as "column37", "column38" as "column38", "column39" as "column39", "column40" as "column40", "column41" as "column41", "column42" as "column42", "column43" as "column43", "column44" as "column44", "column45" as "column45", "column46" as "column46", "column47" as "column47", "column48" as "column48", "column49" as "column49", "column50" as "column50", "column51" as "column51", "column52" as "column52", "column53" as "column53", "column54" as "column54", "column55" as "column55", "column56" as "column56", "column57" as "column57", "column58" as "column58", "column59" as "column59", "column60" as "column60", "column61" as "column61", "column62" as "column62", "column63" as "column63", "column64" as "column64", "column65" as "column65", "column66" as "column66", "column67" as "column67", "column68" as "column68", "column69" as "column69", "T0"."viewId" as "viewId" from (select "sdpkg1a6d1ee100183a6d43a6d005e"."column1" as "column1", "sdpkg1a6d1ee100183a6d43a6d005e"."column2" as "column2", "sdpkg1a6d1ee100183a6d43a6d005e"."column3" as "column3", "sdpkg1a6d1ee100183a6d43a6d005e"."column4" as "column4", "sdpkg1a6d1ee100183a6d43a6d005e"."column5" as "column5", "sdpkg1a6d1ee100183a6d43a6d005e"."column6" as "column6", "sdpkg1a6d1ee100183a6d43a6d005e"."column7" as "column7", "sdpkg1a6d1ee100183a6d43a6d005e"."column8" as "column8", "sdpkg1a6d1ee100183a6d43a6d005e"."column9" as "column9", "sdpkg1a6d1ee100183a6d43a6d005e"."column10" as "column10", "sdpkg1a6d1ee100183a6d43a6d005e"."column11" as "column11", "sdpkg1a6d1ee100183a6d43a6d005e"."column12" as "column12", "sdpkg1a6d1ee100183a6d43a6d005e"."column13" as "column13", "sdpkg1a6d1ee100183a6d43a6d005e"."column14" as "column14", "sdpkg1a6d1ee100183a6d43a6d005e"."column15" as "column15", "sdpkg1a6d1ee100183a6d43a6d005e"."column16" as "column16", "sdpkg1a6d1ee100183a6d43a6d005e"."column17" as "column17", "sdpkg1a6d1ee100183a6d43a6d005e"."column18" as "column18", "sdpkg1a6d1ee100183a6d43a6d005e"."column19" as "column19", "sdpkg1a6d1ee100183a6d43a6d005e"."column20" as "column20", "sdpkg1a6d1ee100183a6d43a6d005e"."column21" as "column21", "sdpkg1a6d1ee100183a6d43a6d005e"."column22" as "column22", "sdpkg1a6d1ee100183a6d43a6d005e"."column23" as "column23", "sdpkg1a6d1ee100183a6d43a6d005e"."column24" as "column24", "sdpkg1a6d1ee100183a6d43a6d005e"."column25" as "column25", "sdpkg1a6d1ee100183a6d43a6d005e"."column26" as "column26", "sdpkg1a6d1ee100183a6d43a6d005e"."column27" as "column27", "sdpkg1a6d1ee100183a6d43a6d005e"."column28" as "column28", "sdpkg1a6d1ee100183a6d43a6d005e"."column29" as "column29", "sdpkg1a6d1ee100183a6d43a6d005e"."column30" as "column30", "sdpkg1a6d1ee100183a6d43a6d005e"."column31" as "column31", "sdpkg1a6d1ee100183a6d43a6d005e"."column32" as "column32", "sdpkg1a6d1ee100183a6d43a6d005e"."column33" as "column33", "sdpkg1a6d1ee100183a6d43a6d005e"."column34" as "column34", "sdpkg1a6d1ee100183a6d43a6d005e"."column35" as "column35", "sdpkg1a6d1ee100183a6d43a6d005e"."column36" as "column36", "sdpkg1a6d1ee100183a6d43a6d005e"."column37" as "column37", "sdpkg1a6d1ee100183a6d43a6d005e"."column38" as "column38", "sdpkg1a6d1ee100183a6d43a6d005e"."column39" as "column39", "sdpkg1a6d1ee100183a6d43a6d005e"."column40" as "column40", "sdpkg1a6d1ee100183a6d43a6d005e"."column41" as "column41", "sdpkg1a6d1ee100183a6d43a6d005e"."column42" as "column42", "sdpkg1a6d1ee100183a6d43a6d005e"."column43" as "column43", "sdpkg1a6d1ee100183a6d43a6d005e"."column44" as "column44", "sdpkg1a6d1ee100183a6d43a6d005e"."column45" as "column45", "sdpkg1a6d1ee100183a6d43a6d005e"."column46" as "column46", "sdpkg1a6d1ee100183a6d43a6d005e"."column47" as "column47", "sdpkg1a6d1ee100183a6d43a6d005e"."column48" as "column48", "sdpkg1a6d1ee100183a6d43a6d005e"."column49" as "column49", "sdpkg1a6d1ee100183a6d43a6d005e"."column50" as "column50", "sdpkg1a6d1ee100183a6d43a6d005e"."column51" as "column51", "sdpkg1a6d1ee100183a6d43a6d005e"."column52" as "column52", "sdpkg1a6d1ee100183a6d43a6d005e"."column53" as "column53", "sdpkg1a6d1ee100183a6d43a6d005e"."column54" as "column54", "sdpkg1a6d1ee100183a6d43a6d005e"."column55" as "column55", "sdpkg1a6d1ee100183a6d43a6d005e"."column56" as "column56", "sdpkg1a6d1ee100183a6d43a6d005e"."column57" as "column57", "sdpkg1a6d1ee100183a6d43a6d005e"."column58" as "column58", "sdpkg1a6d1ee100183a6d43a6d005e"."column59" as "column59", "sdpkg1a6d1ee100183a6d43a6d005e"."column60" as "column60", "sdpkg1a6d1ee100183a6d43a6d005e"."column61" as "column61", "sdpkg1a6d1ee100183a6d43a6d005e"."column62" as "column62", "sdpkg1a6d1ee100183a6d43a6d005e"."column63" as "column63", "sdpkg1a6d1ee100183a6d43a6d005e"."column64" as "column64", "sdpkg1a6d1ee100183a6d43a6d005e"."column65" as "column65", "sdpkg1a6d1ee100183a6d43a6d005e"."column66" as "column66", "sdpkg1a6d1ee100183a6d43a6d005e"."column67" as "column67", "sdpkg1a6d1ee100183a6d43a6d005e"."column68" as "column68", "sdpkg1a6d1ee100183a6d43a6d005e"."column69" as "column69", '考核明细报表1' as "viewId" from "smartbimppmd"."sdpkg1a6d1ee100183a6d43a6d005e" "sdpkg1a6d1ee100183a6d43a6d005e")"T0" -> Date '2021年1月1日' has incorrect format
    at smartbix.SmartbiXException.create(SmartbiXException.java:68)
    at smartbix.smartbi.service.GridDataServiceHandler.handle(GridDataServiceHandler.java:117)
    at sun.reflect.GeneratedMethodAccessor1101.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$$18b78262.executeUpdateSql()
    at smartbix.augmenteddataset.repository.service.AugmentedDatabaseResultService.executeUpdateSql(AugmentedDatabaseResultService.java:137)
    at smartbix.augmenteddataset.extract.AugmentedMppLoadService.loadData(AugmentedMppLoadService.java:185)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor$1.call(SingleThreadedExtractor.java:299)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor$1.call(SingleThreadedExtractor.java:238)
    at smartbix.util.ThreadUtil$SubmitRunnable.call(ThreadUtil.java:207)
    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: java.sql.SQLException: Date '2021年1月1日' has incorrect format
    at org.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:3190)
    at org.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:2978)
    at org.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:450)
    at org.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:284)
    at org.monetdb.jdbc.MonetStatement.executeUpdate(MonetStatement.java:488)
    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:92)
    ... 22 more

 

预览截图看一下时间维度数据？

生成的时间维度是需要有序的，如下图： 如果不是类似这是有序的，就会弹出 【时间层次结构必须包含年层次，且时间大小的顺序是从上到下依次排列，以下层次结构不符合要求：日期_时间维度 】的提示 需要将生成的时间维度调整成有序的日期维度。