Archivo:
etl_20260714_193501.log
Modificado:
14/07/2026 19:35:04
Tamaño:
25.3 KB
Líneas:
327 líneas
2026-07-14 19:35:01,760 [INFO] Iniciando proceso ETL...
2026-07-14 19:35:01,760 [INFO] === INICIO ETL ===
2026-07-14 19:35:01,760 [INFO] Paso 0: Sincronización de IDs
2026-07-14 19:35:01,760 [INFO] Sincronizando tabla pedidos_id_mapping...
2026-07-14 19:35:01,761 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-14 19:35:01,773 [INFO] Conexión PostgreSQL exitosa
2026-07-14 19:35:01,810 [INFO] Sincronización completada: 0 nuevos IDs asignados
2026-07-14 19:35:01,810 [INFO] Paso 1: Extracción de datos
2026-07-14 19:35:01,810 [INFO] Iniciando extracción de cabeceras
2026-07-14 19:35:01,810 [INFO] Extrayendo órdenes desde linux_ordenes...
2026-07-14 19:35:01,811 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-14 19:35:01,818 [INFO] Conexión PostgreSQL exitosa
2026-07-14 19:35:01,818 [INFO] Ejecutando consulta órdenes (desde 2025-07-13 o abiertas=['pendiente', 'parcialmente_completado']): SELECT numero, cliente, vendedor, fecha_entrega, dias_restantes, estatus FROM otd.vw_linux_ordenes WHERE fecha_entrega >= %s OR estatus IN (%s,%s)
2026-07-14 19:35:01,841 [INFO] Extraídas 621 órdenes
2026-07-14 19:35:01,841 [INFO] [DEBUG] Columnas ordenes: ['numero', 'cliente', 'vendedor', 'fecha_entrega', 'dias_restantes', 'estatus']
2026-07-14 19:35:01,842 [INFO] [DEBUG] dtypes ordenes: {'numero': dtype('O'), 'cliente': dtype('O'), 'vendedor': dtype('O'), 'fecha_entrega': dtype('O'), 'dias_restantes': dtype('int64'), 'estatus': dtype('O')}
2026-07-14 19:35:01,849 [INFO] [DEBUG] Nulos en fecha_entrega (ordenes) tras limpiar: 0
2026-07-14 19:35:01,850 [INFO] Iniciando extracción de líneas
2026-07-14 19:35:01,850 [INFO] Extrayendo pedidos desde linux_pedidos...
2026-07-14 19:35:01,850 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-14 19:35:01,857 [INFO] Conexión PostgreSQL exitosa
2026-07-14 19:35:01,857 [INFO] Ejecutando consulta pedidos (desde 2025-07-13 o con saldo > 0): SELECT id, orden_id, clave, producto, unidad, cantidad, surtido, liq, saldo, fecha_entrega, remision FROM otd.vw_linux_pedidos WHERE fecha_entrega >= %s OR saldo > 0
2026-07-14 19:35:02,290 [INFO] Extraídos 1552 pedidos
2026-07-14 19:35:02,290 [INFO] [DEBUG] Columnas pedidos: ['id', 'orden_id', 'clave', 'producto', 'unidad', 'cantidad', 'surtido', 'liq', 'saldo', 'fecha_entrega', 'remision']
2026-07-14 19:35:02,290 [INFO] [DEBUG] dtypes pedidos: {'id': dtype('O'), 'orden_id': dtype('int64'), 'clave': dtype('O'), 'producto': dtype('O'), 'unidad': dtype('O'), 'cantidad': dtype('int64'), 'surtido': dtype('int64'), 'liq': dtype('int64'), 'saldo': dtype('int64'), 'fecha_entrega': dtype('O'), 'remision': dtype('float64')}
2026-07-14 19:35:02,299 [WARNING] Encontradas 2 fechas inválidas en fecha_entrega
2026-07-14 19:35:02,300 [INFO] [DEBUG] Nulos en fecha_entrega (pedidos) tras limpiar: 2
2026-07-14 19:35:02,300 [INFO] Extraídas 1552 líneas
2026-07-14 19:35:02,300 [INFO] Extracción completada en 0.49s
2026-07-14 19:35:02,300 [INFO] Paso 2: Transformación de datos
2026-07-14 19:35:02,301 [INFO] Transformando datos de cabeceras
2026-07-14 19:35:02,301 [INFO] [DEBUG] Nulos por columna (cabeceras): {'numero': 0, 'cliente': 0, 'vendedor': 0, 'fecha_entrega': 0, 'dias_restantes': 0, 'estatus': 0}
2026-07-14 19:35:02,324 [INFO] Transformadas 621 cabeceras
2026-07-14 19:35:02,325 [INFO] [DEBUG] Ejemplo cabeceras transformadas (3): [{'id': '7686', 'numero': '7686', 'cliente': 'DELTA T INGENIERIA Y PROYECTOS', 'vendedor': 'ERICKA IVONNE DELGADO HUERTA', 'fecha_entrega': '2026-01-16', 'estatus': 'completado', 'dias_restantes': -179, 'prioridad': 'URGENTE'}, {'id': '7688', 'numero': '7688', 'cliente': 'INGENIERIA TECNICA EN ADHESIVOS', 'vendedor': 'MARTIN TORRES', 'fecha_entrega': '2026-01-06', 'estatus': 'completado', 'dias_restantes': -189, 'prioridad': 'URGENTE'}, {'id': '7689', 'numero': '7689', 'cliente': 'TECNOLOGIA APLICACIONES ESTRUCTURALES', 'vendedor': 'ERICKA IVONNE DELGADO HUERTA', 'fecha_entrega': '2026-01-07', 'estatus': 'completado', 'dias_restantes': -188, 'prioridad': 'URGENTE'}]
2026-07-14 19:35:02,325 [INFO] Transformando datos de líneas
2026-07-14 19:35:02,326 [INFO] [DEBUG] Nulos por columna (lineas): {'id': 0, 'orden_id': 0, 'clave': 0, 'producto': 0, 'unidad': 0, 'cantidad': 0, 'surtido': 0, 'liq': 0, 'saldo': 0, 'fecha_entrega': 2, 'remision': 73}
2026-07-14 19:35:02,389 [INFO] Transformadas 1552 líneas
2026-07-14 19:35:02,390 [INFO] [DEBUG] Ejemplo líneas transformadas (3): [{'id': '7686_1010', 'ID_UNICO': '7686_1010', 'orden_id': '7686', 'clave': '3220160', 'producto': 'FT322 SELLADOR POLIURETANO BLANCO 600 ML', 'unidad': 'PIEZA', 'cantidad': 200, 'surtido': 200, 'liq': 200, 'saldo': 0, 'fecha_entrega': '2026-01-16', 'remision': '5384.0', 'dias_restantes': -179.0, 'entregado': 1, 'estatus': 'parcialmente_completado', 'fecha_completado': None, 'F_Alta': None, 'remision_producto': None}, {'id': '7688_688', 'ID_UNICO': '7688_688', 'orden_id': '7688', 'clave': 'BD55420-490', 'producto': 'BD55420 METACRILATO 10:1 JERINGA 500 ML', 'unidad': 'PIEZA', 'cantidad': 2, 'surtido': 2, 'liq': 2, 'saldo': 0, 'fecha_entrega': '2026-01-06', 'remision': '5344.0', 'dias_restantes': -189.0, 'entregado': 1, 'estatus': 'parcialmente_completado', 'fecha_completado': None, 'F_Alta': None, 'remision_producto': None}, {'id': '7689_242', 'ID_UNICO': '7689_242', 'orden_id': '7689', 'clave': '3220460', 'producto': 'FT322 SELLADOR POLIURETANO GRIS 600 ML', 'unidad': 'PIEZA', 'cantidad': 60, 'surtido': 60, 'liq': 60, 'saldo': 0, 'fecha_entrega': '2026-01-07', 'remision': '5352.0', 'dias_restantes': -188.0, 'entregado': 1, 'estatus': 'parcialmente_completado', 'fecha_completado': None, 'F_Alta': None, 'remision_producto': None}]
2026-07-14 19:35:02,390 [INFO] Transformación completada en 0.09s
2026-07-14 19:35:02,390 [INFO] Paso 3: Carga de datos
2026-07-14 19:35:02,504 [INFO] Skipped manually modified orden: 7704
2026-07-14 19:35:02,512 [INFO] Skipped manually modified orden: 7718
2026-07-14 19:35:02,512 [INFO] Skipped manually modified orden: 7719
2026-07-14 19:35:02,513 [INFO] Skipped manually modified orden: 7720
2026-07-14 19:35:02,517 [INFO] Skipped manually modified orden: 7729
2026-07-14 19:35:02,518 [INFO] Skipped manually modified orden: 7731
2026-07-14 19:35:02,525 [INFO] Skipped manually modified orden: 7745
2026-07-14 19:35:02,527 [INFO] Skipped manually modified orden: 7748
2026-07-14 19:35:02,529 [INFO] Skipped manually modified orden: 7751
2026-07-14 19:35:02,551 [INFO] Skipped manually modified orden: 7792
2026-07-14 19:35:02,555 [INFO] Skipped manually modified orden: 7799
2026-07-14 19:35:02,556 [INFO] Skipped manually modified orden: 7801
2026-07-14 19:35:02,568 [INFO] Skipped manually modified orden: 7823
2026-07-14 19:35:02,572 [INFO] Skipped manually modified orden: 7833
2026-07-14 19:35:02,573 [INFO] Skipped manually modified orden: 7834
2026-07-14 19:35:02,573 [INFO] Skipped manually modified orden: 7835
2026-07-14 19:35:02,599 [INFO] Skipped manually modified orden: 7881
2026-07-14 19:35:02,608 [INFO] Skipped manually modified orden: 7898
2026-07-14 19:35:02,609 [INFO] Skipped manually modified orden: 7899
2026-07-14 19:35:02,656 [INFO] Skipped manually modified orden: 7980
2026-07-14 19:35:02,659 [INFO] Skipped manually modified orden: 7985
2026-07-14 19:35:02,672 [INFO] Skipped manually modified orden: 8014
2026-07-14 19:35:02,677 [INFO] Skipped manually modified orden: 8026
2026-07-14 19:35:02,679 [INFO] Skipped manually modified orden: 8030
2026-07-14 19:35:02,681 [INFO] Skipped manually modified orden: 8036
2026-07-14 19:35:02,681 [INFO] Skipped manually modified orden: 8037
2026-07-14 19:35:02,682 [INFO] Skipped manually modified orden: 8039
2026-07-14 19:35:02,685 [INFO] Skipped manually modified orden: 8050
2026-07-14 19:35:02,685 [INFO] Skipped manually modified orden: 8051
2026-07-14 19:35:02,687 [INFO] Skipped manually modified orden: 8056
2026-07-14 19:35:02,688 [INFO] Skipped manually modified orden: 8057
2026-07-14 19:35:02,688 [INFO] Skipped manually modified orden: 8058
2026-07-14 19:35:02,691 [INFO] Skipped manually modified orden: 8066
2026-07-14 19:35:02,692 [INFO] Skipped manually modified orden: 8067
2026-07-14 19:35:02,693 [INFO] Skipped manually modified orden: 8071
2026-07-14 19:35:02,693 [INFO] Skipped manually modified orden: 8072
2026-07-14 19:35:02,695 [INFO] Skipped manually modified orden: 8076
2026-07-14 19:35:02,695 [INFO] Skipped manually modified orden: 8077
2026-07-14 19:35:02,696 [INFO] Skipped manually modified orden: 8078
2026-07-14 19:35:02,696 [INFO] Skipped manually modified orden: 8079
2026-07-14 19:35:02,696 [INFO] Skipped manually modified orden: 8080
2026-07-14 19:35:02,696 [INFO] Skipped manually modified orden: 8081
2026-07-14 19:35:02,697 [INFO] Skipped manually modified orden: 8082
2026-07-14 19:35:02,697 [INFO] Skipped manually modified orden: 8083
2026-07-14 19:35:02,697 [INFO] Skipped manually modified orden: 8084
2026-07-14 19:35:02,697 [INFO] Skipped manually modified orden: 8085
2026-07-14 19:35:02,698 [INFO] Skipped manually modified orden: 8086
2026-07-14 19:35:02,698 [INFO] Skipped manually modified orden: 8087
2026-07-14 19:35:02,698 [INFO] Skipped manually modified orden: 8088
2026-07-14 19:35:02,699 [INFO] Skipped manually modified orden: 8089
2026-07-14 19:35:02,699 [INFO] Skipped manually modified orden: 8090
2026-07-14 19:35:02,699 [INFO] Skipped manually modified orden: 8091
2026-07-14 19:35:02,700 [INFO] Skipped manually modified orden: 8092
2026-07-14 19:35:02,700 [INFO] Skipped manually modified orden: 8093
2026-07-14 19:35:02,700 [INFO] Skipped manually modified orden: 8094
2026-07-14 19:35:02,701 [INFO] Skipped manually modified orden: 8096
2026-07-14 19:35:02,701 [INFO] Skipped manually modified orden: 8097
2026-07-14 19:35:02,702 [INFO] Skipped manually modified orden: 8099
2026-07-14 19:35:02,702 [INFO] Skipped manually modified orden: 8100
2026-07-14 19:35:02,703 [INFO] Skipped manually modified orden: 8101
2026-07-14 19:35:02,703 [INFO] Skipped manually modified orden: 8102
2026-07-14 19:35:02,703 [INFO] Skipped manually modified orden: 8103
2026-07-14 19:35:02,704 [INFO] Skipped manually modified orden: 8104
2026-07-14 19:35:02,704 [INFO] Skipped manually modified orden: 8105
2026-07-14 19:35:02,704 [INFO] Skipped manually modified orden: 8106
2026-07-14 19:35:02,705 [INFO] Skipped manually modified orden: 8108
2026-07-14 19:35:02,705 [INFO] Skipped manually modified orden: 8109
2026-07-14 19:35:02,705 [INFO] Skipped manually modified orden: 8110
2026-07-14 19:35:02,706 [INFO] Skipped manually modified orden: 8111
2026-07-14 19:35:02,706 [INFO] Skipped manually modified orden: 8112
2026-07-14 19:35:02,706 [INFO] Skipped manually modified orden: 8113
2026-07-14 19:35:02,707 [INFO] Skipped manually modified orden: 8114
2026-07-14 19:35:02,707 [INFO] Skipped manually modified orden: 8115
2026-07-14 19:35:02,708 [INFO] Skipped manually modified orden: 8116
2026-07-14 19:35:02,709 [INFO] Skipped manually modified orden: 8118
2026-07-14 19:35:02,709 [INFO] Skipped manually modified orden: 8119
2026-07-14 19:35:02,710 [INFO] Skipped manually modified orden: 8120
2026-07-14 19:35:02,710 [INFO] Skipped manually modified orden: 8121
2026-07-14 19:35:02,710 [INFO] Skipped manually modified orden: 8122
2026-07-14 19:35:02,711 [INFO] Skipped manually modified orden: 8123
2026-07-14 19:35:02,711 [INFO] Skipped manually modified orden: 8124
2026-07-14 19:35:02,711 [INFO] Skipped manually modified orden: 8125
2026-07-14 19:35:02,712 [INFO] Skipped manually modified orden: 8126
2026-07-14 19:35:02,712 [INFO] Skipped manually modified orden: 8127
2026-07-14 19:35:02,712 [INFO] Skipped manually modified orden: 8128
2026-07-14 19:35:02,713 [INFO] Skipped manually modified orden: 8129
2026-07-14 19:35:02,713 [INFO] Skipped manually modified orden: 8130
2026-07-14 19:35:02,713 [INFO] Skipped manually modified orden: 8131
2026-07-14 19:35:02,714 [INFO] Skipped manually modified orden: 8132
2026-07-14 19:35:02,714 [INFO] Skipped manually modified orden: 8133
2026-07-14 19:35:02,714 [INFO] Skipped manually modified orden: 8134
2026-07-14 19:35:02,714 [INFO] Skipped manually modified orden: 8136
2026-07-14 19:35:02,716 [INFO] Skipped manually modified orden: 8139
2026-07-14 19:35:02,716 [INFO] Skipped manually modified orden: 8141
2026-07-14 19:35:02,716 [INFO] Skipped manually modified orden: 8142
2026-07-14 19:35:02,717 [INFO] Skipped manually modified orden: 8143
2026-07-14 19:35:02,717 [INFO] Skipped manually modified orden: 8144
2026-07-14 19:35:02,718 [INFO] Skipped manually modified orden: 8146
2026-07-14 19:35:02,718 [INFO] Skipped manually modified orden: 8147
2026-07-14 19:35:02,718 [INFO] Skipped manually modified orden: 8148
2026-07-14 19:35:02,719 [INFO] Skipped manually modified orden: 8150
2026-07-14 19:35:02,719 [INFO] Skipped manually modified orden: 8151
2026-07-14 19:35:02,720 [INFO] Skipped manually modified orden: 8154
2026-07-14 19:35:02,721 [INFO] Skipped manually modified orden: 8155
2026-07-14 19:35:02,721 [INFO] Skipped manually modified orden: 8156
2026-07-14 19:35:02,721 [INFO] Skipped manually modified orden: 8157
2026-07-14 19:35:02,722 [INFO] Skipped manually modified orden: 8158
2026-07-14 19:35:02,722 [INFO] Skipped manually modified orden: 8159
2026-07-14 19:35:02,722 [INFO] Skipped manually modified orden: 8160
2026-07-14 19:35:02,722 [INFO] Skipped manually modified orden: 8161
2026-07-14 19:35:02,723 [INFO] Skipped manually modified orden: 8162
2026-07-14 19:35:02,723 [INFO] Skipped manually modified orden: 8164
2026-07-14 19:35:02,724 [INFO] Skipped manually modified orden: 8165
2026-07-14 19:35:02,724 [INFO] Skipped manually modified orden: 8166
2026-07-14 19:35:02,724 [INFO] Skipped manually modified orden: 8167
2026-07-14 19:35:02,725 [INFO] Skipped manually modified orden: 8168
2026-07-14 19:35:02,725 [INFO] Skipped manually modified orden: 8169
2026-07-14 19:35:02,725 [INFO] Skipped manually modified orden: 8170
2026-07-14 19:35:02,725 [INFO] Skipped manually modified orden: 8172
2026-07-14 19:35:02,726 [INFO] Skipped manually modified orden: 8173
2026-07-14 19:35:02,726 [INFO] Skipped manually modified orden: 8174
2026-07-14 19:35:02,726 [INFO] Skipped manually modified orden: 8177
2026-07-14 19:35:02,726 [INFO] Skipped manually modified orden: 8178
2026-07-14 19:35:02,727 [INFO] Skipped manually modified orden: 8179
2026-07-14 19:35:02,727 [INFO] Skipped manually modified orden: 8181
2026-07-14 19:35:02,728 [INFO] Skipped manually modified orden: 8182
2026-07-14 19:35:02,728 [INFO] Skipped manually modified orden: 8183
2026-07-14 19:35:02,728 [INFO] Skipped manually modified orden: 8184
2026-07-14 19:35:02,728 [INFO] Skipped manually modified orden: 8185
2026-07-14 19:35:02,729 [INFO] Skipped manually modified orden: 8187
2026-07-14 19:35:02,730 [INFO] Skipped manually modified orden: 8191
2026-07-14 19:35:02,731 [INFO] Skipped manually modified orden: 8192
2026-07-14 19:35:02,731 [INFO] Skipped manually modified orden: 8193
2026-07-14 19:35:02,731 [INFO] Skipped manually modified orden: 8194
2026-07-14 19:35:02,732 [INFO] Skipped manually modified orden: 8196
2026-07-14 19:35:02,732 [INFO] Skipped manually modified orden: 8197
2026-07-14 19:35:02,733 [INFO] Skipped manually modified orden: 8198
2026-07-14 19:35:02,733 [INFO] Skipped manually modified orden: 8199
2026-07-14 19:35:02,733 [INFO] Skipped manually modified orden: 8201
2026-07-14 19:35:02,733 [INFO] Skipped manually modified orden: 8202
2026-07-14 19:35:02,734 [INFO] Skipped manually modified orden: 8205
2026-07-14 19:35:02,734 [INFO] Skipped manually modified orden: 8206
2026-07-14 19:35:02,735 [INFO] Skipped manually modified orden: 8208
2026-07-14 19:35:02,735 [INFO] Skipped manually modified orden: 8209
2026-07-14 19:35:02,735 [INFO] Skipped manually modified orden: 8210
2026-07-14 19:35:02,736 [INFO] Skipped manually modified orden: 8211
2026-07-14 19:35:02,736 [INFO] Skipped manually modified orden: 8212
2026-07-14 19:35:02,736 [INFO] Skipped manually modified orden: 8214
2026-07-14 19:35:02,736 [INFO] Skipped manually modified orden: 8215
2026-07-14 19:35:02,737 [INFO] Skipped manually modified orden: 8216
2026-07-14 19:35:02,737 [INFO] Skipped manually modified orden: 8217
2026-07-14 19:35:02,738 [INFO] Skipped manually modified orden: 8219
2026-07-14 19:35:02,738 [INFO] Skipped manually modified orden: 8220
2026-07-14 19:35:02,738 [INFO] Skipped manually modified orden: 8221
2026-07-14 19:35:02,739 [INFO] Skipped manually modified orden: 8222
2026-07-14 19:35:02,739 [INFO] Skipped manually modified orden: 8223
2026-07-14 19:35:02,740 [INFO] Skipped manually modified orden: 8225
2026-07-14 19:35:02,740 [INFO] Skipped manually modified orden: 8227
2026-07-14 19:35:02,740 [INFO] Skipped manually modified orden: 8228
2026-07-14 19:35:02,741 [INFO] Skipped manually modified orden: 8229
2026-07-14 19:35:02,741 [INFO] Skipped manually modified orden: 8231
2026-07-14 19:35:02,741 [INFO] Skipped manually modified orden: 8232
2026-07-14 19:35:02,741 [INFO] Skipped manually modified orden: 8233
2026-07-14 19:35:02,742 [INFO] Skipped manually modified orden: 8235
2026-07-14 19:35:02,742 [INFO] Skipped manually modified orden: 8236
2026-07-14 19:35:02,743 [INFO] Skipped manually modified orden: 8237
2026-07-14 19:35:02,744 [INFO] Skipped manually modified orden: 8240
2026-07-14 19:35:02,745 [INFO] Skipped manually modified orden: 8243
2026-07-14 19:35:02,745 [INFO] Skipped manually modified orden: 8244
2026-07-14 19:35:02,745 [INFO] Skipped manually modified orden: 8245
2026-07-14 19:35:02,746 [INFO] Skipped manually modified orden: 8246
2026-07-14 19:35:02,746 [INFO] Skipped manually modified orden: 8247
2026-07-14 19:35:02,746 [INFO] Skipped manually modified orden: 8248
2026-07-14 19:35:02,747 [INFO] Skipped manually modified orden: 8250
2026-07-14 19:35:02,747 [INFO] Skipped manually modified orden: 8251
2026-07-14 19:35:02,747 [INFO] Skipped manually modified orden: 8252
2026-07-14 19:35:02,748 [INFO] Skipped manually modified orden: 8253
2026-07-14 19:35:02,748 [INFO] Skipped manually modified orden: 8254
2026-07-14 19:35:02,748 [INFO] Skipped manually modified orden: 8255
2026-07-14 19:35:02,749 [INFO] Skipped manually modified orden: 8256
2026-07-14 19:35:02,749 [INFO] Skipped manually modified orden: 8257
2026-07-14 19:35:02,749 [INFO] Skipped manually modified orden: 8258
2026-07-14 19:35:02,749 [INFO] Skipped manually modified orden: 8259
2026-07-14 19:35:02,750 [INFO] Skipped manually modified orden: 8260
2026-07-14 19:35:02,750 [INFO] Skipped manually modified orden: 8263
2026-07-14 19:35:02,750 [INFO] Skipped manually modified orden: 8264
2026-07-14 19:35:02,751 [INFO] Skipped manually modified orden: 8265
2026-07-14 19:35:02,751 [INFO] Skipped manually modified orden: 8266
2026-07-14 19:35:02,751 [INFO] Skipped manually modified orden: 8267
2026-07-14 19:35:02,751 [INFO] Skipped manually modified orden: 8268
2026-07-14 19:35:02,752 [INFO] Skipped manually modified orden: 8270
2026-07-14 19:35:02,752 [INFO] Skipped manually modified orden: 8273
2026-07-14 19:35:02,752 [INFO] Skipped manually modified orden: 8274
2026-07-14 19:35:02,753 [INFO] Skipped manually modified orden: 8275
2026-07-14 19:35:02,753 [INFO] Skipped manually modified orden: 8276
2026-07-14 19:35:02,753 [INFO] Skipped manually modified orden: 8277
2026-07-14 19:35:02,753 [INFO] Skipped manually modified orden: 8278
2026-07-14 19:35:02,754 [INFO] Skipped manually modified orden: 8279
2026-07-14 19:35:02,754 [INFO] Skipped manually modified orden: 8280
2026-07-14 19:35:02,754 [INFO] Skipped manually modified orden: 8281
2026-07-14 19:35:02,755 [INFO] Skipped manually modified orden: 8282
2026-07-14 19:35:02,755 [INFO] Skipped manually modified orden: 8283
2026-07-14 19:35:02,756 [INFO] Skipped manually modified orden: 8285
2026-07-14 19:35:02,756 [INFO] Skipped manually modified orden: 8286
2026-07-14 19:35:02,757 [INFO] Skipped manually modified orden: 8288
2026-07-14 19:35:02,757 [INFO] Skipped manually modified orden: 8289
2026-07-14 19:35:02,758 [INFO] Skipped manually modified orden: 8290
2026-07-14 19:35:02,758 [INFO] Skipped manually modified orden: 8291
2026-07-14 19:35:02,760 [INFO] Skipped manually modified orden: 8296
2026-07-14 19:35:02,761 [INFO] Skipped manually modified orden: 8297
2026-07-14 19:35:02,761 [INFO] Skipped manually modified orden: 8299
2026-07-14 19:35:02,761 [INFO] Skipped manually modified orden: 8301
2026-07-14 19:35:02,762 [INFO] Skipped manually modified orden: 8302
2026-07-14 19:35:02,762 [INFO] Skipped manually modified orden: 8305
2026-07-14 19:35:02,763 [INFO] Skipped manually modified orden: 8306
2026-07-14 19:35:02,763 [INFO] Skipped manually modified orden: 8307
2026-07-14 19:35:02,763 [INFO] Skipped manually modified orden: 8308
2026-07-14 19:35:02,764 [INFO] Skipped manually modified orden: 8309
2026-07-14 19:35:02,765 [INFO] Skipped manually modified orden: 8312
2026-07-14 19:35:02,765 [INFO] Skipped manually modified orden: 8313
2026-07-14 19:35:02,765 [INFO] Skipped manually modified orden: 8314
2026-07-14 19:35:02,766 [INFO] Skipped manually modified orden: 8315
2026-07-14 19:35:02,766 [INFO] Skipped manually modified orden: 8316
2026-07-14 19:35:02,766 [INFO] Skipped manually modified orden: 8317
2026-07-14 19:35:02,767 [INFO] Skipped manually modified orden: 8318
2026-07-14 19:35:02,767 [INFO] Skipped manually modified orden: 8319
2026-07-14 19:35:02,768 [INFO] Skipped manually modified orden: 8321
2026-07-14 19:35:02,768 [INFO] Skipped manually modified orden: 8322
2026-07-14 19:35:02,769 [INFO] Skipped manually modified orden: 8323
2026-07-14 19:35:02,769 [INFO] Skipped manually modified orden: 8324
2026-07-14 19:35:02,769 [INFO] Skipped manually modified orden: 8325
2026-07-14 19:35:02,770 [INFO] Skipped manually modified orden: 8326
2026-07-14 19:35:02,770 [INFO] Skipped manually modified orden: 8327
2026-07-14 19:35:02,771 [INFO] Skipped manually modified orden: 8329
2026-07-14 19:35:02,771 [INFO] Skipped manually modified orden: 8330
2026-07-14 19:35:02,772 [INFO] Skipped manually modified orden: 8332
2026-07-14 19:35:02,773 [INFO] Skipped manually modified orden: 8333
2026-07-14 19:35:02,773 [INFO] Skipped manually modified orden: 8338
2026-07-14 19:35:02,774 [INFO] Skipped manually modified orden: 8339
2026-07-14 19:35:02,776 [INFO] Skipped manually modified orden: 8345
2026-07-14 19:35:02,776 [INFO] Skipped manually modified orden: 8346
2026-07-14 19:35:02,777 [INFO] Skipped manually modified orden: 8348
2026-07-14 19:35:02,778 [INFO] Skipped manually modified orden: 8351
2026-07-14 19:35:02,779 [INFO] Skipped manually modified orden: 8353
2026-07-14 19:35:02,781 [INFO] Merge de órdenes completado: 0 insertadas, 377 actualizadas, 244 omitidas
2026-07-14 19:35:03,731 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,732 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,732 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,733 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,733 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,734 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,734 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,735 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,735 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,736 [INFO] Skipped manually modified pedido: 8036_591
2026-07-14 19:35:03,796 [INFO] Skipped manually modified pedido: 8051_220
2026-07-14 19:35:03,970 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-14 19:35:03,971 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-14 19:35:03,990 [INFO] Skipped manually modified pedido: 8138_658
2026-07-14 19:35:03,991 [INFO] Skipped manually modified pedido: 8138_658
2026-07-14 19:35:03,991 [INFO] Skipped manually modified pedido: 8138_658
2026-07-14 19:35:04,126 [INFO] Skipped manually modified pedido: 8216_662
2026-07-14 19:35:04,126 [INFO] Skipped manually modified pedido: 8216_662
2026-07-14 19:35:04,177 [INFO] Skipped manually modified pedido: 8249_355
2026-07-14 19:35:04,177 [INFO] Skipped manually modified pedido: 8249_355
2026-07-14 19:35:04,178 [INFO] Skipped manually modified pedido: 8249_355
2026-07-14 19:35:04,227 [INFO] Skipped manually modified pedido: 8292_484
2026-07-14 19:35:04,228 [INFO] Skipped manually modified pedido: 8292_484
2026-07-14 19:35:04,228 [INFO] Skipped manually modified pedido: 8292_484
2026-07-14 19:35:04,229 [INFO] Skipped manually modified pedido: 8292_484
2026-07-14 19:35:04,229 [INFO] Skipped manually modified pedido: 8292_484
2026-07-14 19:35:04,236 [INFO] Skipped manually modified pedido: 8301_675
2026-07-14 19:35:04,237 [INFO] Skipped manually modified pedido: 8304_376
2026-07-14 19:35:04,238 [INFO] Skipped manually modified pedido: 8304_376
2026-07-14 19:35:04,286 [INFO] Skipped manually modified pedido: 8339_738
2026-07-14 19:35:04,291 [INFO] Skipped manually modified pedido: 8345_36598
2026-07-14 19:35:04,292 [INFO] Skipped manually modified pedido: 8345_36623
2026-07-14 19:35:04,293 [INFO] Skipped manually modified pedido: 8346_37128
2026-07-14 19:35:04,295 [INFO] Skipped manually modified pedido: 8348_73569
2026-07-14 19:35:04,297 [INFO] Skipped manually modified pedido: 8351_85175
2026-07-14 19:35:04,299 [INFO] Skipped manually modified pedido: 8353_85315
2026-07-14 19:35:04,307 [INFO] Merge de pedidos completado: 0 insertados, 1516 actualizados, 36 omitidos
2026-07-14 19:35:04,308 [INFO] Carga completada en 1.92s
2026-07-14 19:35:04,308 [INFO] [SUCCESS] ETL completado sin errores
2026-07-14 19:35:04,308 [INFO] === PROCESO ETL COMPLETADO EXITOSAMENTE ===
2026-07-14 19:35:04,308 [INFO] Resumen: órdenes 0, pedidos 0
Tip: Usa Ctrl+F para buscar texto específico en el log