csv列中的字符串存在逗号，obloader导入报错Cause: The number of columns parsed does not match the number of columns in the table

淇铭 · 2025 年6 月 16 日 17:21

csv文件的字符集是gbk的么？还是？csv是否用过其他的工具打开过我们用的就是你这个版本还有最新的版本都测试了没有问题

jieguo · 2025 年6 月 16 日 17:25

您在linux直接vi拷贝进去就行啊，就一行，没那么复杂。
[root@ob csv2]# file test.csv
test.csv: UTF-8 Unicode text

淇铭 · 2025 年6 月 16 日 17:53

内部复现不出来这个问题看着字符集也没有问题你在多提供一些数据我们在试一下

jieguo · 2025 年6 月 17 日 08:44

jieguo:

如此明确了，怎么可能？您用的ob版本一样吗？

[root@ob logs]# ll
total 32
-rw-r--r--. 1 root root 1478 Jun 16 16:55 ob-loader-dumper.bad
-rw-r--r--. 1 root root  484 Jun 16 16:55 ob-loader-dumper.error
-rw-r--r--. 1 root root 9955 Jun 16 16:55 ob-loader-dumper.info
-rw-r--r--. 1 root root  384 Jun 16 16:55 ob-loader-dumper.warn
-rw-r--r--. 1 root root 7258 Jun 16 16:55 sql-monitor.log
[root@ob logs]# rm -f *
[root@ob logs]# ll
total 0
[root@ob logs]# cd ..
[root@ob csv2]# 
[root@ob csv2]# 
[root@ob csv2]# cat test.csv
"ID","OPER_TYPE","A_NE_ID","A_NE_CODE","B_NE_ID","B_NE_CODE","STAFF_NO","OPER_TIME","HOSTNAME","IP_ADDRESS","REMARK","OLD_A_NE_ID","OLD_A_NE_CODE","OLD_B_NE_ID","OLD_B_NE_CODE","A_NE_TYPE","B_NE_TYPE","SUBSTATION_ID","OPER_SOURCE","ONU_ID","ONU_CODE","OLD_ONU_ID","OLD_ONU_CODE"
"5657011445",UPDATE,"2510094424",ODN23号2单元-H02-2J,"2510611070",OTB-23号2-1-2,SJMXL,2021-02-08 09:43:23.000,DESKTOP-KHHUV1M,"192.168.136.1","NEW IFREAL:0, OLD IFREAL:0","2613181707",ODN-小区1（115巷3号）-01,"2510611070",OTB-23号2-1-2,"2","3","42634735",8,

[root@ob csv2]# 
[root@ob csv2]# /root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.18 -P 2881 -u gistar -t lnzyob -p xxxx --csv -f /root/csv2/ --skip-header --table 'AN_LOGIC_CONN_LOG' --file-regular-expression "test.csv"
2025-06-16 16:56:31 [INFO] Parsed args:
[--csv] true
[--file-path] /root/csv2/
[--skip-header] true
[--host] 192.168.207.18
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--sys-user] root
[--table] [AN_LOGIC_CONN_LOG]
[--file-regular-expression] test.csv

2025-06-16 16:56:31 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-06-16 16:56:32 [INFO] Log files will be written to /root/csv2/logs
2025-06-16 16:56:32 [INFO] Trying to establish JDBC connection to `gistar@lnzyob`...
2025-06-16 16:56:32 [INFO] Server Mode: OBORACLE-4.2.5.3
2025-06-16 16:56:32 [INFO] Manifest has been saved to "/root/csv2/.MANIFEST.bin"
2025-06-16 16:56:32 [INFO] Querying table column metadata, this might take a while...
2025-06-16 16:56:32 [INFO] Listing all matched data files in dest path...
2025-06-16 16:56:32 [INFO] File: "/root/csv2/logs/ob-loader-dumper.info" is empty, ignore it
2025-06-16 16:56:32 [INFO] File: "/root/csv2/logs/ob-loader-dumper.warn" is empty, ignore it
2025-06-16 16:56:32 [INFO] File: "/root/csv2/logs/ob-loader-dumper.error" is empty, ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG_202506130930.csv.bak", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/logs/sql-monitor.log", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/.load.ckpt", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG.csv.bak", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG.202506130930.csv", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/.MANIFEST.bin", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/JYC.csv", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/AN_LOGIC_CONN_LOG.csv", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.info", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.warn", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.error", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/sql-monitor.log", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.bad", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/.load.ckpt", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/ABC.csv", ignore it
2025-06-16 16:56:32 [INFO] Cannot find a binding for "file:/root/csv2/test.csv.bak", ignore it
2025-06-16 16:56:32 [INFO] Binding table: "AN_LOGIC_CONN_LOG" to file: "file:/root/csv2/test.csv" finished
2025-06-16 16:56:32 [INFO] Find 1 data files in: "/root/csv2/" success. Elapsed: 23.37 ms
2025-06-16 16:56:32 [INFO] Splitting data files into 64 MB logical chunks...
2025-06-16 16:56:32 [INFO] Split 1 data files to 1 logical chunks success. Elapsed: 30.44 ms
2025-06-16 16:56:32 [INFO] Bootstrap with Max Heap: 3 GB, Safe Heap: 3.12 GB
2025-06-16 16:56:32 [INFO] Querying primary/unique constraints metadata for data replacing...
2025-06-16 16:56:32 [INFO] Query table entry for table: "AN_LOGIC_CONN_LOG" finished. Remain: 0
2025-06-16 16:56:32 [INFO] Query leader location of table: "AN_LOGIC_CONN_LOG" finished. Remain: 0
2025-06-16 16:56:32 [INFO] Waiting to calculate leader for 1 subfiles....
2025-06-16 16:56:32 [INFO] Waiting to refresh observer load status....
2025-06-16 16:56:32 [INFO] Create 1024 slots for ring buffer finished. [192.168.207.18:2881]
2025-06-16 16:56:33 [INFO] Start 32 database writer threads finished. [192.168.207.18:2881]
2025-06-16 16:56:33 [INFO] Start 32 record file reader threads success
2025-06-16 16:56:33 [INFO] File: "/root/csv2/test.csv" has been parsed finished
2025-06-16 16:56:33 [WARN] Failed to load 1 records from "/root/csv2/test.csv" into table "GISTAR"."AN_LOGIC_CONN_LOG". Check "ob-loader-dumper.bad" and "ob-loader-dumper.discard" for details
2025-06-16 16:56:34 [ERROR] Error: Failed to load 1 records from "/root/csv2/test.csv" into table "GISTAR"."AN_LOGIC_CONN_LOG". Check "ob-loader-dumper.bad" and "ob-loader-dumper.discard" for details
2025-06-16 16:56:34 [INFO] ----------   Finished Tasks: 1       Running Tasks: 0        Progress: 100.00%       ----------
2025-06-16 16:56:34 [INFO] 

All Load Tasks Finished: 



----------------------------------------------------------------------------------------------------------------------------
        No.#        |        Type        |             Name             |            Count             |       Status       
----------------------------------------------------------------------------------------------------------------------------
         1          |       TABLE        |      AN_LOGIC_CONN_LOG       |            1 -> 0            |      FAILURE       
----------------------------------------------------------------------------------------------------------------------------

Total Count: 0          End Time: 2025-06-16 16:56:34


2025-06-16 16:56:34 [INFO] Load record finished. Total Elapsed: 1.512 s
2025-06-16 16:56:34 [ERROR] System exit 1
[root@ob csv2]# 
[root@ob csv2]# cat ./logs/ob-loader-dumper.bad
INSERT INTO "AN_LOGIC_CONN_LOG" ("ID","OPER_TYPE","A_NE_ID","A_NE_CODE","B_NE_ID","B_NE_CODE","STAFF_NO","OPER_TIME","HOSTNAME","IP_ADDRESS","REMARK","OLD_A_NE_ID","OLD_A_NE_CODE","OLD_B_NE_ID","OLD_B_NE_CODE","A_NE_TYPE","B_NE_TYPE","SUBSTATION_ID","OPER_SOURCE","ONU_ID","ONU_CODE","OLD_ONU_ID","OLD_ONU_CODE")VALUES ('"5657011445"','UPDATE','"2510094424"','ODN23号2单元-H02-2J','"2510611070"','OTB-23号2-1-2','SJMXL','2021-02-08 09:43:23.000','DESKTOP-KHHUV1M','"192.168.136.1"','"NEW IFREAL:0','OLD IFREAL:0"','"2613181707"','ODN-小区1（115巷3号）-01','"2510611070"','OTB-23号2-1-2','"2"','"3"','"42634735"','8','');
Cause: The number of columns parsed does not match the number of columns in the table

[root@ob csv2]# 
[root@ob csv2]# 
再试试加参数的，都一样的错：
[root@ob csv2]# /root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.18 -P 2881 -u gistar -t lnzyob -p xxxx --csv -f /root/csv2/ --skip-header --table 'AN_LOGIC_CONN_LOG' --file-regular-expression "test.csv" --column-delimiter '"'
2025-06-16 17:00:46 [INFO] Parsed args:
[--csv] true
[--file-path] /root/csv2/
[--column-delimiter] "
[--skip-header] true
[--host] 192.168.207.18
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--sys-user] root
[--table] [AN_LOGIC_CONN_LOG]
[--file-regular-expression] test.csv

2025-06-16 17:00:46 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-06-16 17:00:47 [INFO] Log files will be written to /root/csv2/logs
2025-06-16 17:00:47 [INFO] Trying to establish JDBC connection to `gistar@lnzyob`...
2025-06-16 17:00:47 [INFO] Server Mode: OBORACLE-4.2.5.3
2025-06-16 17:00:47 [INFO] Manifest has been saved to "/root/csv2/.MANIFEST.bin"
2025-06-16 17:00:47 [INFO] Querying table column metadata, this might take a while...
2025-06-16 17:00:47 [INFO] Listing all matched data files in dest path...
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG_202506130930.csv.bak", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.info", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.warn", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.error", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/logs/sql-monitor.log", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.bad", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/.load.ckpt", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG.csv.bak", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG.202506130930.csv", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/.MANIFEST.bin", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/JYC.csv", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/AN_LOGIC_CONN_LOG.csv", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.info", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.warn", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.error", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/sql-monitor.log", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.bad", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/.load.ckpt", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/ABC.csv", ignore it
2025-06-16 17:00:47 [INFO] Cannot find a binding for "file:/root/csv2/test.csv.bak", ignore it
2025-06-16 17:00:47 [INFO] Binding table: "AN_LOGIC_CONN_LOG" to file: "file:/root/csv2/test.csv" finished
2025-06-16 17:00:47 [INFO] Find 1 data files in: "/root/csv2/" success. Elapsed: 21.98 ms
2025-06-16 17:00:47 [INFO] Splitting data files into 64 MB logical chunks...
2025-06-16 17:00:47 [INFO] Split 1 data files to 1 logical chunks success. Elapsed: 25.22 ms
2025-06-16 17:00:47 [INFO] Bootstrap with Max Heap: 3 GB, Safe Heap: 3.12 GB
2025-06-16 17:00:47 [INFO] Querying primary/unique constraints metadata for data replacing...
2025-06-16 17:00:47 [INFO] Query table entry for table: "AN_LOGIC_CONN_LOG" finished. Remain: 0
2025-06-16 17:00:47 [INFO] Query leader location of table: "AN_LOGIC_CONN_LOG" finished. Remain: 0
2025-06-16 17:00:47 [INFO] Waiting to calculate leader for 1 subfiles....
2025-06-16 17:00:48 [INFO] Waiting to refresh observer load status....
2025-06-16 17:00:48 [INFO] Create 1024 slots for ring buffer finished. [192.168.207.18:2881]
2025-06-16 17:00:48 [INFO] Start 32 database writer threads finished. [192.168.207.18:2881]
2025-06-16 17:00:48 [INFO] Start 32 record file reader threads success
2025-06-16 17:00:48 [INFO] File: "/root/csv2/test.csv" has been parsed finished
2025-06-16 17:00:48 [WARN] Failed to load 1 records from "/root/csv2/test.csv" into table "GISTAR"."AN_LOGIC_CONN_LOG". Check "ob-loader-dumper.bad" and "ob-loader-dumper.discard" for details
2025-06-16 17:00:49 [ERROR] Error: Failed to load 1 records from "/root/csv2/test.csv" into table "GISTAR"."AN_LOGIC_CONN_LOG". Check "ob-loader-dumper.bad" and "ob-loader-dumper.discard" for details
2025-06-16 17:00:49 [INFO] ----------   Finished Tasks: 1       Running Tasks: 0        Progress: 100.00%       ----------
2025-06-16 17:00:49 [INFO] 

All Load Tasks Finished: 



----------------------------------------------------------------------------------------------------------------------------
        No.#        |        Type        |             Name             |            Count             |       Status       
----------------------------------------------------------------------------------------------------------------------------
         1          |       TABLE        |      AN_LOGIC_CONN_LOG       |            1 -> 0            |      FAILURE       
----------------------------------------------------------------------------------------------------------------------------

Total Count: 0          End Time: 2025-06-16 17:00:49


2025-06-16 17:00:49 [INFO] Load record finished. Total Elapsed: 1.498 s
2025-06-16 17:00:49 [ERROR] System exit 1
[root@ob csv2]# 
[root@ob csv2]# 
[root@ob csv2]# /root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obloader -h 192.168.207.18 -P 2881 -u gistar -t lnzyob -p xxxx --csv -f /root/csv2/ --skip-header --table 'AN_LOGIC_CONN_LOG' --file-regular-expression "test.csv" --column-delimiter '"'  --column-separator ','
2025-06-16 17:01:20 [INFO] Parsed args:
[--csv] true
[--file-path] /root/csv2/
[--column-delimiter] "
[--skip-header] true
[--host] 192.168.207.18
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--sys-user] root
[--table] [AN_LOGIC_CONN_LOG]
[--file-regular-expression] test.csv

2025-06-16 17:01:20 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-06-16 17:01:21 [INFO] Log files will be written to /root/csv2/logs
2025-06-16 17:01:21 [INFO] Trying to establish JDBC connection to `gistar@lnzyob`...
2025-06-16 17:01:21 [INFO] Server Mode: OBORACLE-4.2.5.3
2025-06-16 17:01:21 [INFO] Manifest has been saved to "/root/csv2/.MANIFEST.bin"
2025-06-16 17:01:21 [INFO] Querying table column metadata, this might take a while...
2025-06-16 17:01:22 [INFO] Listing all matched data files in dest path...
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG_202506130930.csv.bak", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.info", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.warn", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.error", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/logs/sql-monitor.log", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/logs/ob-loader-dumper.bad", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/.load.ckpt", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG.csv.bak", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/AN_LOGIC_CONN_LOG.202506130930.csv", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/.MANIFEST.bin", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/JYC.csv", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/AN_LOGIC_CONN_LOG.csv", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.info", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.warn", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.error", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/sql-monitor.log", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/logs/ob-loader-dumper.bad", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/.load.ckpt", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/data/GISTAR/TABLE/ABC.csv", ignore it
2025-06-16 17:01:22 [INFO] Cannot find a binding for "file:/root/csv2/test.csv.bak", ignore it
2025-06-16 17:01:22 [INFO] Binding table: "AN_LOGIC_CONN_LOG" to file: "file:/root/csv2/test.csv" finished
2025-06-16 17:01:22 [INFO] Find 1 data files in: "/root/csv2/" success. Elapsed: 22.10 ms
2025-06-16 17:01:22 [INFO] Splitting data files into 64 MB logical chunks...
2025-06-16 17:01:22 [INFO] Split 1 data files to 1 logical chunks success. Elapsed: 25.01 ms
2025-06-16 17:01:22 [INFO] Bootstrap with Max Heap: 3 GB, Safe Heap: 3.12 GB
2025-06-16 17:01:22 [INFO] Querying primary/unique constraints metadata for data replacing...
2025-06-16 17:01:22 [INFO] Query table entry for table: "AN_LOGIC_CONN_LOG" finished. Remain: 0
2025-06-16 17:01:22 [INFO] Query leader location of table: "AN_LOGIC_CONN_LOG" finished. Remain: 0
2025-06-16 17:01:22 [INFO] Waiting to calculate leader for 1 subfiles....
2025-06-16 17:01:22 [INFO] Waiting to refresh observer load status....
2025-06-16 17:01:22 [INFO] Create 1024 slots for ring buffer finished. [192.168.207.18:2881]
2025-06-16 17:01:22 [INFO] Start 32 database writer threads finished. [192.168.207.18:2881]
2025-06-16 17:01:22 [INFO] Start 32 record file reader threads success
2025-06-16 17:01:22 [INFO] File: "/root/csv2/test.csv" has been parsed finished
2025-06-16 17:01:22 [WARN] Failed to load 1 records from "/root/csv2/test.csv" into table "GISTAR"."AN_LOGIC_CONN_LOG". Check "ob-loader-dumper.bad" and "ob-loader-dumper.discard" for details
2025-06-16 17:01:23 [ERROR] Error: Failed to load 1 records from "/root/csv2/test.csv" into table "GISTAR"."AN_LOGIC_CONN_LOG". Check "ob-loader-dumper.bad" and "ob-loader-dumper.discard" for details
2025-06-16 17:01:23 [INFO] ----------   Finished Tasks: 1       Running Tasks: 0        Progress: 100.00%       ----------
2025-06-16 17:01:23 [INFO] 

All Load Tasks Finished: 



----------------------------------------------------------------------------------------------------------------------------
        No.#        |        Type        |             Name             |            Count             |       Status       
----------------------------------------------------------------------------------------------------------------------------
         1          |       TABLE        |      AN_LOGIC_CONN_LOG       |            1 -> 0            |      FAILURE       
----------------------------------------------------------------------------------------------------------------------------

Total Count: 0          End Time: 2025-06-16 17:01:23


2025-06-16 17:01:23 [INFO] Load record finished. Total Elapsed: 1.488 s
2025-06-16 17:01:23 [ERROR] System exit 1
[root@ob csv2]#

我上面的是完整操作记录。能否把你的操作记录也发出来呢？

独善其身 · 2025 年6 月 17 日 09:23

半角全角问题吗

淇铭 · 2025 年6 月 17 日 09:33

上面的就有操作的步骤只是没有把版本号列出来和你的都是一样的如果可以你发个官方悬赏建群可以交流一下

jieguo · 2025 年6 月 17 日 10:00

哪里有？大川的csv文件内容都不同哦。完整记录请按我的步骤列出来才有说服力，没几步的问题。

jieguo · 2025 年6 月 17 日 10:09

没有这问题，就按我的操作记录走一遍嘛，完全可以重现啊，简单的问题怎么搞得这么复杂呢？

淇铭 · 2025 年6 月 17 日 10:16

数据不全你让我们怎么给你测哎跑了以后还少列又是一个不一样的问题不得字段值就是排除少列的问题能正常跑下去你提供一个完整的数据能跑下去的数据

jieguo · 2025 年6 月 17 日 10:28

最后面字段都是空的，用逗号啊，凑齐即可。

淇铭 · 2025 年6 月 17 日 10:30

你要么把原始的文件提供一份补齐字段值和放逗号有啥区别

jieguo · 2025 年6 月 17 日 10:32

逗号隔开就是一个空值字段

jieguo · 2025 年6 月 17 日 10:37

下面这个就是ue打开的原始的

"ID","OPER_TYPE","A_NE_ID","A_NE_CODE","B_NE_ID","B_NE_CODE","STAFF_NO","OPER_TIME","HOSTNAME","IP_ADDRESS","REMARK","OLD_A_NE_ID","OLD_A_NE_CODE","OLD_B_NE_ID","OLD_B_NE_CODE","A_NE_TYPE","B_NE_TYPE","SUBSTATION_ID","OPER_SOURCE","ONU_ID","ONU_CODE","OLD_ONU_ID","OLD_ONU_CODE"
"5657011445",UPDATE,"2510094424",ODN23号2单元-H02-2J,"2510611070",OTB-23号2-1-2,SJMXL,2021-02-08 09:43:23.000,DESKTOP-KHHUV1M,"192.168.136.1","NEW IFREAL:0, OLD IFREAL:0","2613181707",ODN-小区1（115巷3号）-01,"2510611070",OTB-23号2-1-2,"2","3","42634735",8,,,,
"5657011446",UPDATE,"2510094424",ODN23号2单元-H02-2J,"2510611073",OTB-23号2-1-3,SJMXL,2021-02-08 09:43:23.000,DESKTOP-KHHUV1M,"192.168.136.1","NEW IFREAL:0, OLD IFREAL:0","2613181707",ODN-小区1（115巷3号）-01,"2510611073",OTB-23号2-1-3,"2","3","42634735",8,,,,
"5657011447",UPDATE,"2510094424",ODN23号2单元-H02-2J,"2510611087",OTB-23号2-2-1,SJMXL,2021-02-08 09:43:23.000,DESKTOP-KHHUV1M,"192.168.136.1","NEW IFREAL:0, OLD IFREAL:0","2613181707",ODN-小区1（115巷3号）-01,"2510611087",OTB-23号2-2-1,"2","3","42634735",8,,,,
"5657011448",UPDATE,"2510094424",ODN23号2单元-H02-2J,"2510611092",OTB-23号2-2-2,SJMXL,2021-02-08 09:43:23.000,DESKTOP-KHHUV1M,"192.168.136.1","NEW IFREAL:0, OLD IFREAL:0","2613181707",ODN-小区1（115巷3号）-01,"2510611092",OTB-23号2-2-2,"2","3","42634735",8,,,,
"5657011449",UPDATE,"2510094424",ODN23号2单元-H02-2J,"2510611097",OTB-23号2-2-3,SJMXL,2021-02-08 09:43:23.000,DESKTOP-KHHUV1M,"192.168.136.1","NEW IFREAL:0, OLD IFREAL:0","2613181707",ODN-小区1（115巷3号）-01,"2510611097",OTB-23号2-2-3,"2","3","42634735",8,,,,