八月上旬更新速递丨 实战赋能、技术深耕与AI探索

数据浪潮奔涌,八月更新携实战培训、集成攻略与AI新知强势来袭!助您攻克难题,解锁高阶技能!

重点推荐案例库重磅上线!

 汽车制造两大数字化方案领衔登场,实战培训+集成攻略+AI新知火力全开,助您破局数据难题!


一、任务持续上线

【AI每日一学知识问答】什么是业务数据化,什么又是数据业务化?检验一下你对“业务数据化”与“数据业务化”这对数字化转型双引擎的理解吧


二、demo动态更新

DEMO动态】体验中心行业案例&移动端上新!速来!》→全新的行业案例DEMO和全新移动端DEMO上线,带您领略不一样的数据体验!


三、实战技巧分享


四、开发技能突破


AI每日一学


、小麦训练营

小麦训练营(深圳站):实战演练企业级数据仓库赋能一场专为企业级数据仓库实战赋能的盛宴

麦粉社区
>
帖子详情

数据抽取失败

数据准备 发表于 2022-11-14 16:32
发表于 2022-11-14 16:32:15

excel文件更新后抽取失败,数据连接查看到数据已经更新,但是数据准备一直抽取失败,附日志。


 


extract param:{"paramValues":{"$$extractInfo$$":{"value":{"extractType":"FULL","incrementalType":null,"incrementalRows":null,"incrementalRowIndexs":null,"fieldIdMapping":null,"formatMapping":null,"clearBeforeExtract":true,"extractCurrentDay":false,"reExtractInterval":0,"reExtractTimeUnit":null,"dbType":null,"srcCsvPaths":null,"lastExtractType":"FULL","lastIncrementalType":null,"lastIncrementalRows":[],"lastSelectAllSql":"select \"ÈÕÆÚ\",\"WW\",\"ÇøÓò\",\"Õ¾±ð\",\"ÖÆ³ÌÔðÈÎÈË\",\"DR_NO__PE_\",\"ÊÇ·ñÒѾ­Ìîд_²úÏßÒì³£´¦Àí¼Ç¼±í\",\"É豸»ų́ºÅ\",\"Ó°Ïì_LOT_\",\"OCAPʼþ_MFG_\",\"OCAP_ÒªÇó_MFG_\",\"Ó°ÏìÊýÁ¿\",\"REJECTÊýÁ¿\",\"ÔðÈβ¿ÃÅ\",\"REWORK\" from \"UBLIC\".\"OCAP_DETAILS\"","failModel":"CONTINUE","rejectMaxRecord":2147483647,"rejectRecordFile":"","rejectReasonFile":"","realExtractType":"FULL","logSelectAllSql":"select \"ÈÕÆÚ\",\"WW\",\"ÇøÓò\",\"Õ¾±ð\",\"ÖÆ³ÌÔðÈÎÈË\",\"DR_NO__PE_\",\"ÊÇ·ñÒѾ­Ìîд_²úÏßÒì³£´¦Àí¼Ç¼±í\",\"É豸»ų́ºÅ\",\"Ó°Ïì_LOT_\",\"OCAPʼþ_MFG_\",\"OCAP_ÒªÇó_MFG_\",\"Ó°ÏìÊýÁ¿\",\"REJECTÊýÁ¿\",\"ÔðÈβ¿ÃÅ\",\"REWORK\" from \"UBLIC\".\"OCAP_DETAILS\"","lastExtractState":true,"keepRejectRecord":true,"keepRejectReason":true},"displayValue":null}},"offset":0,"limit":9223372036854775807,"sample":false,"userName":null,"extract":true,"cacheIdentity":"null09223372036854775807false"}/nsmartbix.augmenteddataset.extract.SmartbiXException: ³éȡδÍê³É»ò³éȡʧ°Ü: Error exporting CSV file from database
smartbix.augmenteddataset.extract.SmartbiXException: ¸ñʽת»»Òì³£: REJECTÊýÁ¿/REJECTÊýÁ¿ --> STRING to INTEGER value: NA
    at smartbix.augmenteddataset.extract.SmartbiXException.create(SmartbiXException.java:64)
    at smartbix.augmenteddataset.convert.AbstractCellDataConvertor.convertNumber(AbstractCellDataConvertor.java:436)
    at smartbix.augmenteddataset.convert.AbstractCellDataConvertor.convert(AbstractCellDataConvertor.java:252)
    at smartbix.augmenteddataset.convert.AbstractCellDataConvertor.convert(AbstractCellDataConvertor.java:224)
    at smartbix.augmenteddataset.convert.AbstractCellDataConvertor.convert(AbstractCellDataConvertor.java:119)
    at smartbix.augmenteddataset.convert.AbstractCellDataConvertor.convert(AbstractCellDataConvertor.java:158)
    at smartbix.augmenteddataset.olap.impl.OlapQueryCellDataConvertor.convert(OlapQueryCellDataConvertor.java:165)
    at smartbix.augmenteddataset.olap.impl.OlapQueryCellDataConvertor.convertField(OlapQueryCellDataConvertor.java:108)
    at smartbix.augmenteddataset.olap.impl.OlapQueryCellDataConvertor.convert(OlapQueryCellDataConvertor.java:90)
    at smartbix.augmenteddataset.convert.ConvertorDecorator.next(ConvertorDecorator.java:56)
    at smartbix.augmenteddataset.extract.save2csv.GridData2CSVUtil.export(GridData2CSVUtil.java:220)
    at smartbix.augmenteddataset.extract.save2csv.SmartbiCacheExtractor.exportToCsv(SmartbiCacheExtractor.java:2013)
    at smartbix.augmenteddataset.extract.save2csv.SmartbiCacheExtractor$ExportThread.run(SmartbiCacheExtractor.java:2089)
    at smartbix.util.ThreadUtil$SubmitRunnable.call(ThreadUtil.java:205)
    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.lang.NumberFormatException
    at java.math.BigDecimal.(BigDecimal.java:494)
    at java.math.BigDecimal.(BigDecimal.java:383)
    at java.math.BigDecimal.(BigDecimal.java:806)
    at smartbix.augmenteddataset.convert.AbstractCellDataConvertor.convertNumber(AbstractCellDataConvertor.java:434)
    ... 16 more


    at smartbix.augmenteddataset.extract.SmartbiXException.create(SmartbiXException.java:24)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor.extractextractInternal(SingleThreadedExtractor.java:468)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor.access$1400(SingleThreadedExtractor.java:92)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor$2.call(SingleThreadedExtractor.java:374)
    at smartbix.augmenteddataset.extract.SingleThreadedExtractor$2.call(SingleThreadedExtractor.java:356)
    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)

发表于 2022-11-14 16:36:03
excel更新的是表数据还是表结构呢?重新设置抽取条件再抽取也不可以吗

回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

7回帖数 0关注人数 1320浏览人数
最后回复于:2022-11-14 16:36
快速回复 返回顶部 返回列表