错误是
04-17 15:01:22 DEBUG createTableInternal(smartbi.datapackage.importer.InfobrightImporter:544) - create table `ww`(`第1列` varchar(255) binary null COMMENT '第1列', `第2列` varchar(255) binary null COMMENT '第2列', `第3列` varchar(255) binary null COMMENT '第3列', `黄色为超期1年以上` varchar(255) binary null COMMENT '黄色为超期1年以上', `第5列` varchar(255) binary null COMMENT '第5列', `第6列` varchar(255) binary null COMMENT '第6列', `刘自辉2023年2。28日应收款明细表` varchar(255) binary null COMMENT '刘自辉2023年2。28日应收款明细表', `第8列` varchar(255) binary null COMMENT '第8列', `第9列` varchar(255) binary null COMMENT '第9列', `第10列` varchar(255) binary null COMMENT '第10列', `第11列` varchar(255) binary null COMMENT '第11列', `第12列` varchar(255) binary null COMMENT '第12列', `第13列` varchar(255) binary null COMMENT '第13列', `第14列` varchar(255) binary null COMMENT '第14列', `第15列` varchar(255) binary null COMMENT '第15列', `第16列` varchar(255) binary null COMMENT '第16列', `第17列` varchar(255) binary null COMMENT '第17列', `第18列` varchar(255) binary null COMMENT '第18列', `第19列` varchar(255) binary null COMMENT '第19列', `第20列` varchar(255) binary null COMMENT '第20列', `第21列` varchar(255) binary null COMMENT '第21列', `第22列` varchar(255) binary null COMMENT '第22列', `第23列` varchar(255) binary null COMMENT '第23列', `第24列` varchar(255) binary null COMMENT '第24列', `第25列` varchar(255) binary null COMMENT '第25列', `第26列` varchar(255) binary null COMMENT '第26列', `第27列` varchar(255) binary null COMMENT '第27列', `第28列` varchar(255) binary null COMMENT '第28列', `第29列` varchar(255) binary null COMMENT '第29列', `第30列` varchar(255) binary null COMMENT '第30列', `第31列` varchar(255) binary null COMMENT '第31列', `第32列` varchar(255) binary null COMMENT '第32列', `第33列` varchar(255) binary null COMMENT '第33列', `第34列` varchar(255) binary null COMMENT '第34列', `第35列` varchar(255) binary null COMMENT '第35列', `第36列` varchar(255) binary null COMMENT '第36列', `第37列` varchar(255) binary null COMMENT '第37列', `第38列` varchar(255) binary null COMMENT '第38列', `第39列` varchar(255) binary null COMMENT '第39列', `第40列` varchar(255) binary null COMMENT '第40列', `第41列` varchar(255) binary null COMMENT '第41列', `第42列` varchar(255) binary null COMMENT '第42列', `第43列` varchar(255) binary null COMMENT '第43列', `第44列` varchar(255) binary null COMMENT '第44列', `第45列` varchar(255) binary null COMMENT '第45列', `第46列` varchar(255) binary null COMMENT '第46列') ENGINE=BRIGHTHOUSE DEFAULT CHARSET=gbk COLLATE=gbk_chinese_ci
04-17 15:01:23 DEBUG executeInsertData(smartbi.datapackage.importer.InfobrightImporter:903) - LOAD DATA LOCAL INFILE 'C:/Smartbi/Tomcat/bin/Tmp-smartbi/tmp-smartbi/importdata_3850346088223487936_tmp.csv' INTO TABLE `ww` CHARACTER SET 'UTF8' FIELDS ESCAPED BY '\\' TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
04-17 15:01:24 DEBUG dropTable(smartbi.datapackage.importer.InfobrightImporter:695) - drop table `ww`
04-17 15:01:24 ERROR insertMultiSheetData(smartbi.datapackage.service.DataPackageService:1006) - import error:
java.sql.SQLException: Wrong data or column definition. Row: 12, field: 12.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864)
at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:3836)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3068)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2338)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2725)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1536)
at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2585)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1464)
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 smartbi.log.PreparedStatementWarp.executeUpdate(PreparedStatementWarp.java:367)
at smartbi.datapackage.importer.BaseImporter.executeInsertData(BaseImporter.java:904)
at smartbi.datapackage.importer.BaseImporter.insertDataInternal(BaseImporter.java:873)
at smartbi.datapackage.importer.BaseImporter.insertData(BaseImporter.java:824)
at smartbi.datapackage.importer.BaseImporter.doImport(BaseImporter.java:182)
at smartbi.datapackage.service.DataPackageService.insertData(DataPackageService.java:1037)
at smartbi.datapackage.service.DataPackageService.insertMultiSheetData(DataPackageService.java:988)
at smartbi.datapackage.DataPackageServlet.processRequest(DataPackageServlet.java:235)
at smartbi.datapackage.DataPackageServlet.service(DataPackageServlet.java:110)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
at smartbi.extension.Extension.processMatchServlet(Extension.java:619)
at smartbi.extension.ExtensionFilter.processInternal(ExtensionFilter.java:247)
at smartbi.extension.ExtensionFilter.access$000(ExtensionFilter.java:47)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:184)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)
at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)
at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:205)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:82)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:129)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.framework.RedisSessionFilter.doFilter(Smartbi:137)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
|
