Archivo:
etl_20260715_203501.log
Modificado:
15/07/2026 20:35:03
Tamaño:
26.3 KB
Líneas:
342 líneas
2026-07-15 20:35:01,585 [INFO] Iniciando proceso ETL...
2026-07-15 20:35:01,585 [INFO] === INICIO ETL ===
2026-07-15 20:35:01,585 [INFO] Paso 0: Sincronización de IDs
2026-07-15 20:35:01,585 [INFO] Sincronizando tabla pedidos_id_mapping...
2026-07-15 20:35:01,585 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 20:35:01,594 [INFO] Conexión PostgreSQL exitosa
2026-07-15 20:35:01,625 [INFO] Sincronización completada: 0 nuevos IDs asignados
2026-07-15 20:35:01,625 [INFO] Paso 1: Extracción de datos
2026-07-15 20:35:01,625 [INFO] Iniciando extracción de cabeceras
2026-07-15 20:35:01,625 [INFO] Extrayendo órdenes desde linux_ordenes...
2026-07-15 20:35:01,625 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 20:35:01,634 [INFO] Conexión PostgreSQL exitosa
2026-07-15 20:35:01,634 [INFO] Ejecutando consulta órdenes (desde 2025-07-14 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-15 20:35:01,659 [INFO] Extraídas 624 órdenes
2026-07-15 20:35:01,660 [INFO] [DEBUG] Columnas ordenes: ['numero', 'cliente', 'vendedor', 'fecha_entrega', 'dias_restantes', 'estatus']
2026-07-15 20:35:01,660 [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-15 20:35:01,667 [INFO] [DEBUG] Nulos en fecha_entrega (ordenes) tras limpiar: 0
2026-07-15 20:35:01,667 [INFO] Iniciando extracción de líneas
2026-07-15 20:35:01,667 [INFO] Extrayendo pedidos desde linux_pedidos...
2026-07-15 20:35:01,667 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 20:35:01,675 [INFO] Conexión PostgreSQL exitosa
2026-07-15 20:35:01,676 [INFO] Ejecutando consulta pedidos (desde 2025-07-14 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-15 20:35:02,113 [INFO] Extraídos 1568 pedidos
2026-07-15 20:35:02,114 [INFO] [DEBUG] Columnas pedidos: ['id', 'orden_id', 'clave', 'producto', 'unidad', 'cantidad', 'surtido', 'liq', 'saldo', 'fecha_entrega', 'remision']
2026-07-15 20:35:02,114 [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-15 20:35:02,122 [WARNING] Encontradas 2 fechas inválidas en fecha_entrega
2026-07-15 20:35:02,123 [INFO] [DEBUG] Nulos en fecha_entrega (pedidos) tras limpiar: 2
2026-07-15 20:35:02,123 [INFO] Extraídas 1568 líneas
2026-07-15 20:35:02,123 [INFO] Extracción completada en 0.50s
2026-07-15 20:35:02,123 [INFO] Paso 2: Transformación de datos
2026-07-15 20:35:02,123 [INFO] Transformando datos de cabeceras
2026-07-15 20:35:02,124 [INFO] [DEBUG] Nulos por columna (cabeceras): {'numero': 0, 'cliente': 0, 'vendedor': 0, 'fecha_entrega': 0, 'dias_restantes': 0, 'estatus': 0}
2026-07-15 20:35:02,147 [INFO] Transformadas 624 cabeceras
2026-07-15 20:35:02,148 [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': -180, 'prioridad': 'URGENTE'}, {'id': '7688', 'numero': '7688', 'cliente': 'INGENIERIA TECNICA EN ADHESIVOS', 'vendedor': 'MARTIN TORRES', 'fecha_entrega': '2026-01-06', 'estatus': 'completado', 'dias_restantes': -190, 'prioridad': 'URGENTE'}, {'id': '7689', 'numero': '7689', 'cliente': 'TECNOLOGIA APLICACIONES ESTRUCTURALES', 'vendedor': 'ERICKA IVONNE DELGADO HUERTA', 'fecha_entrega': '2026-01-07', 'estatus': 'completado', 'dias_restantes': -189, 'prioridad': 'URGENTE'}]
2026-07-15 20:35:02,148 [INFO] Transformando datos de líneas
2026-07-15 20:35:02,149 [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-15 20:35:02,211 [INFO] Transformadas 1568 líneas
2026-07-15 20:35:02,212 [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': -180.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': -190.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': -189.0, 'entregado': 1, 'estatus': 'parcialmente_completado', 'fecha_completado': None, 'F_Alta': None, 'remision_producto': None}]
2026-07-15 20:35:02,213 [INFO] Transformación completada en 0.09s
2026-07-15 20:35:02,213 [INFO] Paso 3: Carga de datos
2026-07-15 20:35:02,312 [INFO] Skipped manually modified orden: 7704
2026-07-15 20:35:02,321 [INFO] Skipped manually modified orden: 7718
2026-07-15 20:35:02,321 [INFO] Skipped manually modified orden: 7719
2026-07-15 20:35:02,322 [INFO] Skipped manually modified orden: 7720
2026-07-15 20:35:02,327 [INFO] Skipped manually modified orden: 7729
2026-07-15 20:35:02,328 [INFO] Skipped manually modified orden: 7731
2026-07-15 20:35:02,334 [INFO] Skipped manually modified orden: 7745
2026-07-15 20:35:02,336 [INFO] Skipped manually modified orden: 7748
2026-07-15 20:35:02,337 [INFO] Skipped manually modified orden: 7751
2026-07-15 20:35:02,356 [INFO] Skipped manually modified orden: 7792
2026-07-15 20:35:02,359 [INFO] Skipped manually modified orden: 7799
2026-07-15 20:35:02,360 [INFO] Skipped manually modified orden: 7801
2026-07-15 20:35:02,369 [INFO] Skipped manually modified orden: 7823
2026-07-15 20:35:02,372 [INFO] Skipped manually modified orden: 7833
2026-07-15 20:35:02,373 [INFO] Skipped manually modified orden: 7834
2026-07-15 20:35:02,373 [INFO] Skipped manually modified orden: 7835
2026-07-15 20:35:02,392 [INFO] Skipped manually modified orden: 7881
2026-07-15 20:35:02,399 [INFO] Skipped manually modified orden: 7898
2026-07-15 20:35:02,399 [INFO] Skipped manually modified orden: 7899
2026-07-15 20:35:02,426 [INFO] Skipped manually modified orden: 7980
2026-07-15 20:35:02,428 [INFO] Skipped manually modified orden: 7985
2026-07-15 20:35:02,439 [INFO] Skipped manually modified orden: 8014
2026-07-15 20:35:02,443 [INFO] Skipped manually modified orden: 8026
2026-07-15 20:35:02,445 [INFO] Skipped manually modified orden: 8030
2026-07-15 20:35:02,447 [INFO] Skipped manually modified orden: 8036
2026-07-15 20:35:02,447 [INFO] Skipped manually modified orden: 8037
2026-07-15 20:35:02,447 [INFO] Skipped manually modified orden: 8039
2026-07-15 20:35:02,450 [INFO] Skipped manually modified orden: 8050
2026-07-15 20:35:02,451 [INFO] Skipped manually modified orden: 8051
2026-07-15 20:35:02,452 [INFO] Skipped manually modified orden: 8056
2026-07-15 20:35:02,453 [INFO] Skipped manually modified orden: 8057
2026-07-15 20:35:02,453 [INFO] Skipped manually modified orden: 8058
2026-07-15 20:35:02,455 [INFO] Skipped manually modified orden: 8066
2026-07-15 20:35:02,456 [INFO] Skipped manually modified orden: 8067
2026-07-15 20:35:02,457 [INFO] Skipped manually modified orden: 8071
2026-07-15 20:35:02,457 [INFO] Skipped manually modified orden: 8072
2026-07-15 20:35:02,459 [INFO] Skipped manually modified orden: 8076
2026-07-15 20:35:02,459 [INFO] Skipped manually modified orden: 8077
2026-07-15 20:35:02,459 [INFO] Skipped manually modified orden: 8078
2026-07-15 20:35:02,460 [INFO] Skipped manually modified orden: 8079
2026-07-15 20:35:02,460 [INFO] Skipped manually modified orden: 8080
2026-07-15 20:35:02,460 [INFO] Skipped manually modified orden: 8081
2026-07-15 20:35:02,460 [INFO] Skipped manually modified orden: 8082
2026-07-15 20:35:02,461 [INFO] Skipped manually modified orden: 8083
2026-07-15 20:35:02,461 [INFO] Skipped manually modified orden: 8084
2026-07-15 20:35:02,461 [INFO] Skipped manually modified orden: 8085
2026-07-15 20:35:02,461 [INFO] Skipped manually modified orden: 8086
2026-07-15 20:35:02,462 [INFO] Skipped manually modified orden: 8087
2026-07-15 20:35:02,462 [INFO] Skipped manually modified orden: 8088
2026-07-15 20:35:02,462 [INFO] Skipped manually modified orden: 8089
2026-07-15 20:35:02,462 [INFO] Skipped manually modified orden: 8090
2026-07-15 20:35:02,463 [INFO] Skipped manually modified orden: 8091
2026-07-15 20:35:02,463 [INFO] Skipped manually modified orden: 8092
2026-07-15 20:35:02,463 [INFO] Skipped manually modified orden: 8093
2026-07-15 20:35:02,463 [INFO] Skipped manually modified orden: 8094
2026-07-15 20:35:02,464 [INFO] Skipped manually modified orden: 8096
2026-07-15 20:35:02,464 [INFO] Skipped manually modified orden: 8097
2026-07-15 20:35:02,465 [INFO] Skipped manually modified orden: 8099
2026-07-15 20:35:02,465 [INFO] Skipped manually modified orden: 8100
2026-07-15 20:35:02,465 [INFO] Skipped manually modified orden: 8101
2026-07-15 20:35:02,466 [INFO] Skipped manually modified orden: 8102
2026-07-15 20:35:02,466 [INFO] Skipped manually modified orden: 8103
2026-07-15 20:35:02,466 [INFO] Skipped manually modified orden: 8104
2026-07-15 20:35:02,466 [INFO] Skipped manually modified orden: 8105
2026-07-15 20:35:02,467 [INFO] Skipped manually modified orden: 8106
2026-07-15 20:35:02,467 [INFO] Skipped manually modified orden: 8108
2026-07-15 20:35:02,468 [INFO] Skipped manually modified orden: 8109
2026-07-15 20:35:02,468 [INFO] Skipped manually modified orden: 8110
2026-07-15 20:35:02,468 [INFO] Skipped manually modified orden: 8111
2026-07-15 20:35:02,468 [INFO] Skipped manually modified orden: 8112
2026-07-15 20:35:02,469 [INFO] Skipped manually modified orden: 8113
2026-07-15 20:35:02,469 [INFO] Skipped manually modified orden: 8114
2026-07-15 20:35:02,469 [INFO] Skipped manually modified orden: 8115
2026-07-15 20:35:02,469 [INFO] Skipped manually modified orden: 8116
2026-07-15 20:35:02,470 [INFO] Skipped manually modified orden: 8118
2026-07-15 20:35:02,470 [INFO] Skipped manually modified orden: 8119
2026-07-15 20:35:02,470 [INFO] Skipped manually modified orden: 8120
2026-07-15 20:35:02,470 [INFO] Skipped manually modified orden: 8121
2026-07-15 20:35:02,471 [INFO] Skipped manually modified orden: 8122
2026-07-15 20:35:02,471 [INFO] Skipped manually modified orden: 8123
2026-07-15 20:35:02,471 [INFO] Skipped manually modified orden: 8124
2026-07-15 20:35:02,471 [INFO] Skipped manually modified orden: 8125
2026-07-15 20:35:02,472 [INFO] Skipped manually modified orden: 8126
2026-07-15 20:35:02,472 [INFO] Skipped manually modified orden: 8127
2026-07-15 20:35:02,472 [INFO] Skipped manually modified orden: 8128
2026-07-15 20:35:02,473 [INFO] Skipped manually modified orden: 8129
2026-07-15 20:35:02,473 [INFO] Skipped manually modified orden: 8130
2026-07-15 20:35:02,473 [INFO] Skipped manually modified orden: 8131
2026-07-15 20:35:02,473 [INFO] Skipped manually modified orden: 8132
2026-07-15 20:35:02,474 [INFO] Skipped manually modified orden: 8133
2026-07-15 20:35:02,474 [INFO] Skipped manually modified orden: 8134
2026-07-15 20:35:02,474 [INFO] Skipped manually modified orden: 8136
2026-07-15 20:35:02,475 [INFO] Skipped manually modified orden: 8139
2026-07-15 20:35:02,475 [INFO] Skipped manually modified orden: 8141
2026-07-15 20:35:02,476 [INFO] Skipped manually modified orden: 8142
2026-07-15 20:35:02,476 [INFO] Skipped manually modified orden: 8143
2026-07-15 20:35:02,476 [INFO] Skipped manually modified orden: 8144
2026-07-15 20:35:02,477 [INFO] Skipped manually modified orden: 8146
2026-07-15 20:35:02,477 [INFO] Skipped manually modified orden: 8147
2026-07-15 20:35:02,477 [INFO] Skipped manually modified orden: 8148
2026-07-15 20:35:02,478 [INFO] Skipped manually modified orden: 8150
2026-07-15 20:35:02,478 [INFO] Skipped manually modified orden: 8151
2026-07-15 20:35:02,479 [INFO] Skipped manually modified orden: 8154
2026-07-15 20:35:02,479 [INFO] Skipped manually modified orden: 8155
2026-07-15 20:35:02,479 [INFO] Skipped manually modified orden: 8156
2026-07-15 20:35:02,480 [INFO] Skipped manually modified orden: 8157
2026-07-15 20:35:02,480 [INFO] Skipped manually modified orden: 8158
2026-07-15 20:35:02,480 [INFO] Skipped manually modified orden: 8159
2026-07-15 20:35:02,480 [INFO] Skipped manually modified orden: 8160
2026-07-15 20:35:02,481 [INFO] Skipped manually modified orden: 8161
2026-07-15 20:35:02,481 [INFO] Skipped manually modified orden: 8162
2026-07-15 20:35:02,481 [INFO] Skipped manually modified orden: 8164
2026-07-15 20:35:02,482 [INFO] Skipped manually modified orden: 8165
2026-07-15 20:35:02,482 [INFO] Skipped manually modified orden: 8166
2026-07-15 20:35:02,482 [INFO] Skipped manually modified orden: 8167
2026-07-15 20:35:02,482 [INFO] Skipped manually modified orden: 8168
2026-07-15 20:35:02,483 [INFO] Skipped manually modified orden: 8169
2026-07-15 20:35:02,483 [INFO] Skipped manually modified orden: 8170
2026-07-15 20:35:02,483 [INFO] Skipped manually modified orden: 8172
2026-07-15 20:35:02,483 [INFO] Skipped manually modified orden: 8173
2026-07-15 20:35:02,484 [INFO] Skipped manually modified orden: 8174
2026-07-15 20:35:02,484 [INFO] Skipped manually modified orden: 8177
2026-07-15 20:35:02,484 [INFO] Skipped manually modified orden: 8178
2026-07-15 20:35:02,484 [INFO] Skipped manually modified orden: 8179
2026-07-15 20:35:02,484 [INFO] Skipped manually modified orden: 8181
2026-07-15 20:35:02,485 [INFO] Skipped manually modified orden: 8182
2026-07-15 20:35:02,485 [INFO] Skipped manually modified orden: 8183
2026-07-15 20:35:02,485 [INFO] Skipped manually modified orden: 8184
2026-07-15 20:35:02,486 [INFO] Skipped manually modified orden: 8185
2026-07-15 20:35:02,486 [INFO] Skipped manually modified orden: 8187
2026-07-15 20:35:02,487 [INFO] Skipped manually modified orden: 8191
2026-07-15 20:35:02,487 [INFO] Skipped manually modified orden: 8192
2026-07-15 20:35:02,487 [INFO] Skipped manually modified orden: 8193
2026-07-15 20:35:02,488 [INFO] Skipped manually modified orden: 8194
2026-07-15 20:35:02,488 [INFO] Skipped manually modified orden: 8196
2026-07-15 20:35:02,488 [INFO] Skipped manually modified orden: 8197
2026-07-15 20:35:02,489 [INFO] Skipped manually modified orden: 8198
2026-07-15 20:35:02,489 [INFO] Skipped manually modified orden: 8199
2026-07-15 20:35:02,489 [INFO] Skipped manually modified orden: 8201
2026-07-15 20:35:02,489 [INFO] Skipped manually modified orden: 8202
2026-07-15 20:35:02,490 [INFO] Skipped manually modified orden: 8205
2026-07-15 20:35:02,490 [INFO] Skipped manually modified orden: 8206
2026-07-15 20:35:02,490 [INFO] Skipped manually modified orden: 8208
2026-07-15 20:35:02,491 [INFO] Skipped manually modified orden: 8209
2026-07-15 20:35:02,491 [INFO] Skipped manually modified orden: 8210
2026-07-15 20:35:02,491 [INFO] Skipped manually modified orden: 8211
2026-07-15 20:35:02,491 [INFO] Skipped manually modified orden: 8212
2026-07-15 20:35:02,492 [INFO] Skipped manually modified orden: 8214
2026-07-15 20:35:02,492 [INFO] Skipped manually modified orden: 8215
2026-07-15 20:35:02,492 [INFO] Skipped manually modified orden: 8216
2026-07-15 20:35:02,492 [INFO] Skipped manually modified orden: 8217
2026-07-15 20:35:02,493 [INFO] Skipped manually modified orden: 8219
2026-07-15 20:35:02,493 [INFO] Skipped manually modified orden: 8220
2026-07-15 20:35:02,493 [INFO] Skipped manually modified orden: 8221
2026-07-15 20:35:02,493 [INFO] Skipped manually modified orden: 8222
2026-07-15 20:35:02,494 [INFO] Skipped manually modified orden: 8223
2026-07-15 20:35:02,494 [INFO] Skipped manually modified orden: 8225
2026-07-15 20:35:02,494 [INFO] Skipped manually modified orden: 8227
2026-07-15 20:35:02,495 [INFO] Skipped manually modified orden: 8228
2026-07-15 20:35:02,495 [INFO] Skipped manually modified orden: 8229
2026-07-15 20:35:02,495 [INFO] Skipped manually modified orden: 8231
2026-07-15 20:35:02,495 [INFO] Skipped manually modified orden: 8232
2026-07-15 20:35:02,496 [INFO] Skipped manually modified orden: 8233
2026-07-15 20:35:02,496 [INFO] Skipped manually modified orden: 8235
2026-07-15 20:35:02,496 [INFO] Skipped manually modified orden: 8236
2026-07-15 20:35:02,497 [INFO] Skipped manually modified orden: 8237
2026-07-15 20:35:02,497 [INFO] Skipped manually modified orden: 8240
2026-07-15 20:35:02,498 [INFO] Skipped manually modified orden: 8243
2026-07-15 20:35:02,498 [INFO] Skipped manually modified orden: 8244
2026-07-15 20:35:02,498 [INFO] Skipped manually modified orden: 8245
2026-07-15 20:35:02,499 [INFO] Skipped manually modified orden: 8246
2026-07-15 20:35:02,499 [INFO] Skipped manually modified orden: 8247
2026-07-15 20:35:02,499 [INFO] Skipped manually modified orden: 8248
2026-07-15 20:35:02,500 [INFO] Skipped manually modified orden: 8250
2026-07-15 20:35:02,500 [INFO] Skipped manually modified orden: 8251
2026-07-15 20:35:02,500 [INFO] Skipped manually modified orden: 8252
2026-07-15 20:35:02,500 [INFO] Skipped manually modified orden: 8253
2026-07-15 20:35:02,501 [INFO] Skipped manually modified orden: 8254
2026-07-15 20:35:02,501 [INFO] Skipped manually modified orden: 8255
2026-07-15 20:35:02,501 [INFO] Skipped manually modified orden: 8256
2026-07-15 20:35:02,501 [INFO] Skipped manually modified orden: 8257
2026-07-15 20:35:02,501 [INFO] Skipped manually modified orden: 8258
2026-07-15 20:35:02,502 [INFO] Skipped manually modified orden: 8259
2026-07-15 20:35:02,502 [INFO] Skipped manually modified orden: 8260
2026-07-15 20:35:02,502 [INFO] Skipped manually modified orden: 8263
2026-07-15 20:35:02,502 [INFO] Skipped manually modified orden: 8264
2026-07-15 20:35:02,502 [INFO] Skipped manually modified orden: 8265
2026-07-15 20:35:02,503 [INFO] Skipped manually modified orden: 8266
2026-07-15 20:35:02,503 [INFO] Skipped manually modified orden: 8267
2026-07-15 20:35:02,503 [INFO] Skipped manually modified orden: 8268
2026-07-15 20:35:02,503 [INFO] Skipped manually modified orden: 8270
2026-07-15 20:35:02,503 [INFO] Skipped manually modified orden: 8273
2026-07-15 20:35:02,504 [INFO] Skipped manually modified orden: 8274
2026-07-15 20:35:02,504 [INFO] Skipped manually modified orden: 8275
2026-07-15 20:35:02,504 [INFO] Skipped manually modified orden: 8276
2026-07-15 20:35:02,504 [INFO] Skipped manually modified orden: 8277
2026-07-15 20:35:02,505 [INFO] Skipped manually modified orden: 8278
2026-07-15 20:35:02,505 [INFO] Skipped manually modified orden: 8279
2026-07-15 20:35:02,505 [INFO] Skipped manually modified orden: 8280
2026-07-15 20:35:02,505 [INFO] Skipped manually modified orden: 8281
2026-07-15 20:35:02,505 [INFO] Skipped manually modified orden: 8282
2026-07-15 20:35:02,506 [INFO] Skipped manually modified orden: 8283
2026-07-15 20:35:02,506 [INFO] Skipped manually modified orden: 8285
2026-07-15 20:35:02,507 [INFO] Skipped manually modified orden: 8286
2026-07-15 20:35:02,507 [INFO] Skipped manually modified orden: 8288
2026-07-15 20:35:02,507 [INFO] Skipped manually modified orden: 8289
2026-07-15 20:35:02,508 [INFO] Skipped manually modified orden: 8290
2026-07-15 20:35:02,508 [INFO] Skipped manually modified orden: 8291
2026-07-15 20:35:02,510 [INFO] Skipped manually modified orden: 8296
2026-07-15 20:35:02,510 [INFO] Skipped manually modified orden: 8297
2026-07-15 20:35:02,510 [INFO] Skipped manually modified orden: 8299
2026-07-15 20:35:02,510 [INFO] Skipped manually modified orden: 8301
2026-07-15 20:35:02,511 [INFO] Skipped manually modified orden: 8302
2026-07-15 20:35:02,511 [INFO] Skipped manually modified orden: 8305
2026-07-15 20:35:02,511 [INFO] Skipped manually modified orden: 8306
2026-07-15 20:35:02,512 [INFO] Skipped manually modified orden: 8307
2026-07-15 20:35:02,512 [INFO] Skipped manually modified orden: 8308
2026-07-15 20:35:02,512 [INFO] Skipped manually modified orden: 8309
2026-07-15 20:35:02,513 [INFO] Skipped manually modified orden: 8312
2026-07-15 20:35:02,513 [INFO] Skipped manually modified orden: 8313
2026-07-15 20:35:02,513 [INFO] Skipped manually modified orden: 8314
2026-07-15 20:35:02,513 [INFO] Skipped manually modified orden: 8315
2026-07-15 20:35:02,514 [INFO] Skipped manually modified orden: 8316
2026-07-15 20:35:02,514 [INFO] Skipped manually modified orden: 8317
2026-07-15 20:35:02,514 [INFO] Skipped manually modified orden: 8318
2026-07-15 20:35:02,514 [INFO] Skipped manually modified orden: 8319
2026-07-15 20:35:02,515 [INFO] Skipped manually modified orden: 8321
2026-07-15 20:35:02,515 [INFO] Skipped manually modified orden: 8322
2026-07-15 20:35:02,515 [INFO] Skipped manually modified orden: 8323
2026-07-15 20:35:02,515 [INFO] Skipped manually modified orden: 8324
2026-07-15 20:35:02,516 [INFO] Skipped manually modified orden: 8325
2026-07-15 20:35:02,516 [INFO] Skipped manually modified orden: 8326
2026-07-15 20:35:02,516 [INFO] Skipped manually modified orden: 8327
2026-07-15 20:35:02,517 [INFO] Skipped manually modified orden: 8329
2026-07-15 20:35:02,517 [INFO] Skipped manually modified orden: 8330
2026-07-15 20:35:02,518 [INFO] Skipped manually modified orden: 8332
2026-07-15 20:35:02,518 [INFO] Skipped manually modified orden: 8333
2026-07-15 20:35:02,518 [INFO] Skipped manually modified orden: 8338
2026-07-15 20:35:02,519 [INFO] Skipped manually modified orden: 8339
2026-07-15 20:35:02,520 [INFO] Skipped manually modified orden: 8345
2026-07-15 20:35:02,520 [INFO] Skipped manually modified orden: 8346
2026-07-15 20:35:02,520 [INFO] Skipped manually modified orden: 8347
2026-07-15 20:35:02,521 [INFO] Skipped manually modified orden: 8348
2026-07-15 20:35:02,521 [INFO] Skipped manually modified orden: 8351
2026-07-15 20:35:02,522 [INFO] Skipped manually modified orden: 8353
2026-07-15 20:35:02,523 [INFO] Skipped manually modified orden: 8355
2026-07-15 20:35:02,523 [INFO] Skipped manually modified orden: 8357
2026-07-15 20:35:02,525 [INFO] Merge de órdenes completado: 0 insertadas, 377 actualizadas, 247 omitidas
2026-07-15 20:35:03,287 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 20:35:03,288 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 20:35:03,289 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 20:35:03,289 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 20:35:03,339 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,340 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,340 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,341 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,342 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,342 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,343 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,343 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,344 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,344 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 20:35:03,397 [INFO] Skipped manually modified pedido: 8051_220
2026-07-15 20:35:03,540 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-15 20:35:03,540 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-15 20:35:03,558 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 20:35:03,558 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 20:35:03,559 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 20:35:03,559 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 20:35:03,560 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 20:35:03,560 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 20:35:03,561 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 20:35:03,561 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 20:35:03,689 [INFO] Skipped manually modified pedido: 8216_662
2026-07-15 20:35:03,689 [INFO] Skipped manually modified pedido: 8216_662
2026-07-15 20:35:03,744 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 20:35:03,745 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 20:35:03,746 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 20:35:03,795 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 20:35:03,796 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 20:35:03,797 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 20:35:03,797 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 20:35:03,798 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 20:35:03,804 [INFO] Skipped manually modified pedido: 8301_675
2026-07-15 20:35:03,805 [INFO] Skipped manually modified pedido: 8304_376
2026-07-15 20:35:03,806 [INFO] Skipped manually modified pedido: 8304_376
2026-07-15 20:35:03,845 [INFO] Skipped manually modified pedido: 8339_738
2026-07-15 20:35:03,849 [INFO] Skipped manually modified pedido: 8345_36598
2026-07-15 20:35:03,850 [INFO] Skipped manually modified pedido: 8345_36623
2026-07-15 20:35:03,850 [INFO] Skipped manually modified pedido: 8346_37128
2026-07-15 20:35:03,851 [INFO] Skipped manually modified pedido: 8347_72313
2026-07-15 20:35:03,851 [INFO] Skipped manually modified pedido: 8348_73569
2026-07-15 20:35:03,852 [INFO] Skipped manually modified pedido: 8351_85175
2026-07-15 20:35:03,854 [INFO] Skipped manually modified pedido: 8353_85315
2026-07-15 20:35:03,855 [INFO] Skipped manually modified pedido: 8355_124643
2026-07-15 20:35:03,856 [INFO] Skipped manually modified pedido: 8357_124771
2026-07-15 20:35:03,861 [INFO] Merge de pedidos completado: 0 insertados, 1520 actualizados, 48 omitidos
2026-07-15 20:35:03,861 [INFO] Carga completada en 1.65s
2026-07-15 20:35:03,861 [INFO] [SUCCESS] ETL completado sin errores
2026-07-15 20:35:03,861 [INFO] === PROCESO ETL COMPLETADO EXITOSAMENTE ===
2026-07-15 20:35:03,862 [INFO] Resumen: órdenes 0, pedidos 0
Tip: Usa Ctrl+F para buscar texto específico en el log