2025-11-06 13:37:12,852 - INFO - 同步时间范围: 2025-11-05 08:30:00 到 2025-11-06 08:30:00
2025-11-06 13:37:12,956 - INFO - 开始同步表: OEE_AvaiableTime, 主键: OEE_AvaiableTimeId
2025-11-06 13:37:13,363 - DEBUG - 即将执行的SQL语句:
2025-11-06 13:37:13,364 - DEBUG - INSERT INTO OEE_AvaiableTime ("OEE_AVAIABLETIMEID", "STARTTIME", "ENDTIME", "DURATION", "TYPE", "OP", "PARTNO", "LOSSREASON", "COMMENT", "SHIFTWORKTIMEID", "CREATEAT", "UPDATEAT", "BYUSER") VALUES (:oee_avaiabletimeid, :starttime, :endtime, :duration, :_type_, :op, :partno, :lossreason, :_comment_, :shiftworktimeid, TO_DATE(:createat_date, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:updateat_date, 'YYYY-MM-DD HH24:MI:SS'), :byuser)
2025-11-06 13:37:13,364 - DEBUG - 绑定参数:
2025-11-06 13:37:13,364 - DEBUG - {'oee_avaiabletimeid': '7c602b6e-1b3e-406f-a55f-915fa14cf4a5', 'starttime': '133', 'endtime': '139', 'duration': 30, '_type_': '14', 'op': None, 'partno': None, 'lossreason': None, '_comment_': None, 'shiftworktimeid': 'f0fc7598-ed04-4116-a854-edc694e8c9b6', 'createat_date': '2025-11-05 08:20:53', 'updateat_date': '2025-11-05 13:32:29', 'byuser': 'AD'}
2025-11-06 13:37:13,364 - DEBUG - 格式化后的SQL:
2025-11-06 13:37:13,364 - DEBUG - INSERT INTO OEE_AvaiableTime ("OEE_AVAIABLETIMEID", "STARTTIME", "ENDTIME", "DURATION", "TYPE", "OP", "PARTNO", "LOSSREASON", "COMMENT", "SHIFTWORKTIMEID", "CREATEAT", "UPDATEAT", "BYUSER") VALUES (:oee_avaiabletimeid, :starttime, :endtime, :duration, :_type_, :op, :partno, :lossreason, :_comment_, :shiftworktimeid, TO_DATE(:createat_date, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:updateat_date, 'YYYY-MM-DD HH24:MI:SS'), :byuser)
2025-11-06 13:37:21,631 - ERROR - Oracle错误: DPY-4008: no bind placeholder named ":_type_" was found in the SQL text (代码: 0)
2025-11-06 13:37:21,631 - ERROR - 问题SQL: INSERT INTO OEE_AvaiableTime ("OEE_AVAIABLETIMEID", "STARTTIME", "ENDTIME", "DURATION", "TYPE", "OP", "PARTNO", "LOSSREASON", "COMMENT", "SHIFTWORKTIMEID", "CREATEAT", "UPDATEAT", "BYUSER") VALUES (:oee_avaiabletimeid, :starttime, :endtime, :duration, :_type_, :op, :partno, :lossreason, :_comment_, :shiftworktimeid, TO_DATE(:createat_date, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:updateat_date, 'YYYY-MM-DD HH24:MI:SS'), :byuser)
2025-11-06 13:37:21,631 - ERROR - 绑定参数: {'oee_avaiabletimeid': '7c602b6e-1b3e-406f-a55f-915fa14cf4a5', 'starttime': '133', 'endtime': '139', 'duration': 30, '_type_': '14', 'op': None, 'partno': None, 'lossreason': None, '_comment_': None, 'shiftworktimeid': 'f0fc7598-ed04-4116-a854-edc694e8c9b6', 'createat_date': '2025-11-05 08:20:53', 'updateat_date': '2025-11-05 13:32:29', 'byuser': 'AD'}
2025-11-06 13:37:25,734 - ERROR - 同步失败: DPY-4008: no bind placeholder named ":_type_" was found in the SQL text
Traceback (most recent call last):
File "C:\UserData\Python\SyncSqlitedb\sync_service.py", line 188, in sync_sqlite_to_oracle
oracle_cursor.execute(insert_sql, insert_params)
~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\guc3\AppData\Roaming\Python\Python313\site-packages\oracledb\cursor.py", line 708, in execute
impl.execute(self)
~~~~~~~~~~~~^^^^^^
File "src/oracledb/impl/thin/cursor.pyx", line 275, in oracledb.thin_impl.ThinCursorImpl.execute
File "src/oracledb/impl/thin/cursor.pyx", line 182, in oracledb.thin_impl.BaseThinCursorImpl._preprocess_execute
File "src/oracledb/impl/base/cursor.pyx", line 351, in oracledb.base_impl.BaseCursorImpl._perform_binds
File "src/oracledb/impl/thin/var.pyx", line 95, in oracledb.thin_impl.ThinVarImpl._bind
File "C:\Users\guc3\AppData\Roaming\Python\Python313\site-packages\oracledb\errors.py", line 199, in _raise_err
raise error.exc_type(error) from cause
oracledb.exceptions.DatabaseError: DPY-4008: no bind placeholder named ":_type_" was found in the SQL text
最新发布
本文介绍了解决Oracle数据库中ORA-00018错误的方法，该错误通常意味着超过最大会话数限制。文章提供了检查当前最大会话数设置的命令，并指导如何通过修改init.ora文件来增加最大会话数。
扫一扫
7052
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
