Archivo:
etl_20260715_223501.log
Modificado:
15/07/2026 22:35:04
Tamaño:
26.3 KB
Líneas:
342 líneas
2026-07-15 22:35:01,875 [INFO] Iniciando proceso ETL...
2026-07-15 22:35:01,876 [INFO] === INICIO ETL ===
2026-07-15 22:35:01,876 [INFO] Paso 0: Sincronización de IDs
2026-07-15 22:35:01,876 [INFO] Sincronizando tabla pedidos_id_mapping...
2026-07-15 22:35:01,876 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 22:35:01,886 [INFO] Conexión PostgreSQL exitosa
2026-07-15 22:35:01,921 [INFO] Sincronización completada: 0 nuevos IDs asignados
2026-07-15 22:35:01,922 [INFO] Paso 1: Extracción de datos
2026-07-15 22:35:01,922 [INFO] Iniciando extracción de cabeceras
2026-07-15 22:35:01,922 [INFO] Extrayendo órdenes desde linux_ordenes...
2026-07-15 22:35:01,922 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 22:35:01,929 [INFO] Conexión PostgreSQL exitosa
2026-07-15 22:35:01,930 [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 22:35:01,952 [INFO] Extraídas 624 órdenes
2026-07-15 22:35:01,952 [INFO] [DEBUG] Columnas ordenes: ['numero', 'cliente', 'vendedor', 'fecha_entrega', 'dias_restantes', 'estatus']
2026-07-15 22:35:01,953 [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 22:35:01,963 [INFO] [DEBUG] Nulos en fecha_entrega (ordenes) tras limpiar: 0
2026-07-15 22:35:01,964 [INFO] Iniciando extracción de líneas
2026-07-15 22:35:01,964 [INFO] Extrayendo pedidos desde linux_pedidos...
2026-07-15 22:35:01,964 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 22:35:01,974 [INFO] Conexión PostgreSQL exitosa
2026-07-15 22:35:01,974 [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 22:35:02,407 [INFO] Extraídos 1568 pedidos
2026-07-15 22:35:02,407 [INFO] [DEBUG] Columnas pedidos: ['id', 'orden_id', 'clave', 'producto', 'unidad', 'cantidad', 'surtido', 'liq', 'saldo', 'fecha_entrega', 'remision']
2026-07-15 22:35:02,407 [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 22:35:02,415 [WARNING] Encontradas 2 fechas inválidas en fecha_entrega
2026-07-15 22:35:02,416 [INFO] [DEBUG] Nulos en fecha_entrega (pedidos) tras limpiar: 2
2026-07-15 22:35:02,416 [INFO] Extraídas 1568 líneas
2026-07-15 22:35:02,416 [INFO] Extracción completada en 0.49s
2026-07-15 22:35:02,416 [INFO] Paso 2: Transformación de datos
2026-07-15 22:35:02,416 [INFO] Transformando datos de cabeceras
2026-07-15 22:35:02,417 [INFO] [DEBUG] Nulos por columna (cabeceras): {'numero': 0, 'cliente': 0, 'vendedor': 0, 'fecha_entrega': 0, 'dias_restantes': 0, 'estatus': 0}
2026-07-15 22:35:02,450 [INFO] Transformadas 624 cabeceras
2026-07-15 22:35:02,452 [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 22:35:02,452 [INFO] Transformando datos de líneas
2026-07-15 22:35:02,453 [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 22:35:02,517 [INFO] Transformadas 1568 líneas
2026-07-15 22:35:02,518 [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 22:35:02,518 [INFO] Transformación completada en 0.10s
2026-07-15 22:35:02,518 [INFO] Paso 3: Carga de datos
2026-07-15 22:35:02,613 [INFO] Skipped manually modified orden: 7704
2026-07-15 22:35:02,619 [INFO] Skipped manually modified orden: 7718
2026-07-15 22:35:02,619 [INFO] Skipped manually modified orden: 7719
2026-07-15 22:35:02,620 [INFO] Skipped manually modified orden: 7720
2026-07-15 22:35:02,624 [INFO] Skipped manually modified orden: 7729
2026-07-15 22:35:02,625 [INFO] Skipped manually modified orden: 7731
2026-07-15 22:35:02,631 [INFO] Skipped manually modified orden: 7745
2026-07-15 22:35:02,632 [INFO] Skipped manually modified orden: 7748
2026-07-15 22:35:02,633 [INFO] Skipped manually modified orden: 7751
2026-07-15 22:35:02,650 [INFO] Skipped manually modified orden: 7792
2026-07-15 22:35:02,653 [INFO] Skipped manually modified orden: 7799
2026-07-15 22:35:02,654 [INFO] Skipped manually modified orden: 7801
2026-07-15 22:35:02,664 [INFO] Skipped manually modified orden: 7823
2026-07-15 22:35:02,668 [INFO] Skipped manually modified orden: 7833
2026-07-15 22:35:02,668 [INFO] Skipped manually modified orden: 7834
2026-07-15 22:35:02,669 [INFO] Skipped manually modified orden: 7835
2026-07-15 22:35:02,689 [INFO] Skipped manually modified orden: 7881
2026-07-15 22:35:02,696 [INFO] Skipped manually modified orden: 7898
2026-07-15 22:35:02,696 [INFO] Skipped manually modified orden: 7899
2026-07-15 22:35:02,731 [INFO] Skipped manually modified orden: 7980
2026-07-15 22:35:02,733 [INFO] Skipped manually modified orden: 7985
2026-07-15 22:35:02,748 [INFO] Skipped manually modified orden: 8014
2026-07-15 22:35:02,753 [INFO] Skipped manually modified orden: 8026
2026-07-15 22:35:02,755 [INFO] Skipped manually modified orden: 8030
2026-07-15 22:35:02,757 [INFO] Skipped manually modified orden: 8036
2026-07-15 22:35:02,758 [INFO] Skipped manually modified orden: 8037
2026-07-15 22:35:02,758 [INFO] Skipped manually modified orden: 8039
2026-07-15 22:35:02,762 [INFO] Skipped manually modified orden: 8050
2026-07-15 22:35:02,762 [INFO] Skipped manually modified orden: 8051
2026-07-15 22:35:02,764 [INFO] Skipped manually modified orden: 8056
2026-07-15 22:35:02,764 [INFO] Skipped manually modified orden: 8057
2026-07-15 22:35:02,765 [INFO] Skipped manually modified orden: 8058
2026-07-15 22:35:02,768 [INFO] Skipped manually modified orden: 8066
2026-07-15 22:35:02,768 [INFO] Skipped manually modified orden: 8067
2026-07-15 22:35:02,770 [INFO] Skipped manually modified orden: 8071
2026-07-15 22:35:02,770 [INFO] Skipped manually modified orden: 8072
2026-07-15 22:35:02,772 [INFO] Skipped manually modified orden: 8076
2026-07-15 22:35:02,772 [INFO] Skipped manually modified orden: 8077
2026-07-15 22:35:02,773 [INFO] Skipped manually modified orden: 8078
2026-07-15 22:35:02,773 [INFO] Skipped manually modified orden: 8079
2026-07-15 22:35:02,773 [INFO] Skipped manually modified orden: 8080
2026-07-15 22:35:02,773 [INFO] Skipped manually modified orden: 8081
2026-07-15 22:35:02,774 [INFO] Skipped manually modified orden: 8082
2026-07-15 22:35:02,774 [INFO] Skipped manually modified orden: 8083
2026-07-15 22:35:02,774 [INFO] Skipped manually modified orden: 8084
2026-07-15 22:35:02,775 [INFO] Skipped manually modified orden: 8085
2026-07-15 22:35:02,775 [INFO] Skipped manually modified orden: 8086
2026-07-15 22:35:02,775 [INFO] Skipped manually modified orden: 8087
2026-07-15 22:35:02,776 [INFO] Skipped manually modified orden: 8088
2026-07-15 22:35:02,776 [INFO] Skipped manually modified orden: 8089
2026-07-15 22:35:02,776 [INFO] Skipped manually modified orden: 8090
2026-07-15 22:35:02,777 [INFO] Skipped manually modified orden: 8091
2026-07-15 22:35:02,777 [INFO] Skipped manually modified orden: 8092
2026-07-15 22:35:02,777 [INFO] Skipped manually modified orden: 8093
2026-07-15 22:35:02,777 [INFO] Skipped manually modified orden: 8094
2026-07-15 22:35:02,778 [INFO] Skipped manually modified orden: 8096
2026-07-15 22:35:02,779 [INFO] Skipped manually modified orden: 8097
2026-07-15 22:35:02,779 [INFO] Skipped manually modified orden: 8099
2026-07-15 22:35:02,780 [INFO] Skipped manually modified orden: 8100
2026-07-15 22:35:02,780 [INFO] Skipped manually modified orden: 8101
2026-07-15 22:35:02,780 [INFO] Skipped manually modified orden: 8102
2026-07-15 22:35:02,780 [INFO] Skipped manually modified orden: 8103
2026-07-15 22:35:02,781 [INFO] Skipped manually modified orden: 8104
2026-07-15 22:35:02,781 [INFO] Skipped manually modified orden: 8105
2026-07-15 22:35:02,781 [INFO] Skipped manually modified orden: 8106
2026-07-15 22:35:02,782 [INFO] Skipped manually modified orden: 8108
2026-07-15 22:35:02,782 [INFO] Skipped manually modified orden: 8109
2026-07-15 22:35:02,783 [INFO] Skipped manually modified orden: 8110
2026-07-15 22:35:02,783 [INFO] Skipped manually modified orden: 8111
2026-07-15 22:35:02,783 [INFO] Skipped manually modified orden: 8112
2026-07-15 22:35:02,783 [INFO] Skipped manually modified orden: 8113
2026-07-15 22:35:02,783 [INFO] Skipped manually modified orden: 8114
2026-07-15 22:35:02,784 [INFO] Skipped manually modified orden: 8115
2026-07-15 22:35:02,784 [INFO] Skipped manually modified orden: 8116
2026-07-15 22:35:02,784 [INFO] Skipped manually modified orden: 8118
2026-07-15 22:35:02,784 [INFO] Skipped manually modified orden: 8119
2026-07-15 22:35:02,785 [INFO] Skipped manually modified orden: 8120
2026-07-15 22:35:02,785 [INFO] Skipped manually modified orden: 8121
2026-07-15 22:35:02,785 [INFO] Skipped manually modified orden: 8122
2026-07-15 22:35:02,786 [INFO] Skipped manually modified orden: 8123
2026-07-15 22:35:02,786 [INFO] Skipped manually modified orden: 8124
2026-07-15 22:35:02,786 [INFO] Skipped manually modified orden: 8125
2026-07-15 22:35:02,786 [INFO] Skipped manually modified orden: 8126
2026-07-15 22:35:02,787 [INFO] Skipped manually modified orden: 8127
2026-07-15 22:35:02,787 [INFO] Skipped manually modified orden: 8128
2026-07-15 22:35:02,787 [INFO] Skipped manually modified orden: 8129
2026-07-15 22:35:02,787 [INFO] Skipped manually modified orden: 8130
2026-07-15 22:35:02,788 [INFO] Skipped manually modified orden: 8131
2026-07-15 22:35:02,788 [INFO] Skipped manually modified orden: 8132
2026-07-15 22:35:02,788 [INFO] Skipped manually modified orden: 8133
2026-07-15 22:35:02,788 [INFO] Skipped manually modified orden: 8134
2026-07-15 22:35:02,788 [INFO] Skipped manually modified orden: 8136
2026-07-15 22:35:02,790 [INFO] Skipped manually modified orden: 8139
2026-07-15 22:35:02,790 [INFO] Skipped manually modified orden: 8141
2026-07-15 22:35:02,790 [INFO] Skipped manually modified orden: 8142
2026-07-15 22:35:02,791 [INFO] Skipped manually modified orden: 8143
2026-07-15 22:35:02,791 [INFO] Skipped manually modified orden: 8144
2026-07-15 22:35:02,791 [INFO] Skipped manually modified orden: 8146
2026-07-15 22:35:02,792 [INFO] Skipped manually modified orden: 8147
2026-07-15 22:35:02,792 [INFO] Skipped manually modified orden: 8148
2026-07-15 22:35:02,793 [INFO] Skipped manually modified orden: 8150
2026-07-15 22:35:02,793 [INFO] Skipped manually modified orden: 8151
2026-07-15 22:35:02,794 [INFO] Skipped manually modified orden: 8154
2026-07-15 22:35:02,795 [INFO] Skipped manually modified orden: 8155
2026-07-15 22:35:02,795 [INFO] Skipped manually modified orden: 8156
2026-07-15 22:35:02,795 [INFO] Skipped manually modified orden: 8157
2026-07-15 22:35:02,795 [INFO] Skipped manually modified orden: 8158
2026-07-15 22:35:02,796 [INFO] Skipped manually modified orden: 8159
2026-07-15 22:35:02,796 [INFO] Skipped manually modified orden: 8160
2026-07-15 22:35:02,796 [INFO] Skipped manually modified orden: 8161
2026-07-15 22:35:02,796 [INFO] Skipped manually modified orden: 8162
2026-07-15 22:35:02,797 [INFO] Skipped manually modified orden: 8164
2026-07-15 22:35:02,797 [INFO] Skipped manually modified orden: 8165
2026-07-15 22:35:02,797 [INFO] Skipped manually modified orden: 8166
2026-07-15 22:35:02,797 [INFO] Skipped manually modified orden: 8167
2026-07-15 22:35:02,798 [INFO] Skipped manually modified orden: 8168
2026-07-15 22:35:02,798 [INFO] Skipped manually modified orden: 8169
2026-07-15 22:35:02,798 [INFO] Skipped manually modified orden: 8170
2026-07-15 22:35:02,798 [INFO] Skipped manually modified orden: 8172
2026-07-15 22:35:02,799 [INFO] Skipped manually modified orden: 8173
2026-07-15 22:35:02,799 [INFO] Skipped manually modified orden: 8174
2026-07-15 22:35:02,799 [INFO] Skipped manually modified orden: 8177
2026-07-15 22:35:02,799 [INFO] Skipped manually modified orden: 8178
2026-07-15 22:35:02,800 [INFO] Skipped manually modified orden: 8179
2026-07-15 22:35:02,800 [INFO] Skipped manually modified orden: 8181
2026-07-15 22:35:02,800 [INFO] Skipped manually modified orden: 8182
2026-07-15 22:35:02,800 [INFO] Skipped manually modified orden: 8183
2026-07-15 22:35:02,800 [INFO] Skipped manually modified orden: 8184
2026-07-15 22:35:02,801 [INFO] Skipped manually modified orden: 8185
2026-07-15 22:35:02,801 [INFO] Skipped manually modified orden: 8187
2026-07-15 22:35:02,802 [INFO] Skipped manually modified orden: 8191
2026-07-15 22:35:02,803 [INFO] Skipped manually modified orden: 8192
2026-07-15 22:35:02,803 [INFO] Skipped manually modified orden: 8193
2026-07-15 22:35:02,803 [INFO] Skipped manually modified orden: 8194
2026-07-15 22:35:02,804 [INFO] Skipped manually modified orden: 8196
2026-07-15 22:35:02,804 [INFO] Skipped manually modified orden: 8197
2026-07-15 22:35:02,804 [INFO] Skipped manually modified orden: 8198
2026-07-15 22:35:02,804 [INFO] Skipped manually modified orden: 8199
2026-07-15 22:35:02,805 [INFO] Skipped manually modified orden: 8201
2026-07-15 22:35:02,805 [INFO] Skipped manually modified orden: 8202
2026-07-15 22:35:02,805 [INFO] Skipped manually modified orden: 8205
2026-07-15 22:35:02,806 [INFO] Skipped manually modified orden: 8206
2026-07-15 22:35:02,806 [INFO] Skipped manually modified orden: 8208
2026-07-15 22:35:02,806 [INFO] Skipped manually modified orden: 8209
2026-07-15 22:35:02,806 [INFO] Skipped manually modified orden: 8210
2026-07-15 22:35:02,807 [INFO] Skipped manually modified orden: 8211
2026-07-15 22:35:02,807 [INFO] Skipped manually modified orden: 8212
2026-07-15 22:35:02,807 [INFO] Skipped manually modified orden: 8214
2026-07-15 22:35:02,807 [INFO] Skipped manually modified orden: 8215
2026-07-15 22:35:02,808 [INFO] Skipped manually modified orden: 8216
2026-07-15 22:35:02,808 [INFO] Skipped manually modified orden: 8217
2026-07-15 22:35:02,808 [INFO] Skipped manually modified orden: 8219
2026-07-15 22:35:02,809 [INFO] Skipped manually modified orden: 8220
2026-07-15 22:35:02,809 [INFO] Skipped manually modified orden: 8221
2026-07-15 22:35:02,809 [INFO] Skipped manually modified orden: 8222
2026-07-15 22:35:02,809 [INFO] Skipped manually modified orden: 8223
2026-07-15 22:35:02,810 [INFO] Skipped manually modified orden: 8225
2026-07-15 22:35:02,810 [INFO] Skipped manually modified orden: 8227
2026-07-15 22:35:02,811 [INFO] Skipped manually modified orden: 8228
2026-07-15 22:35:02,811 [INFO] Skipped manually modified orden: 8229
2026-07-15 22:35:02,811 [INFO] Skipped manually modified orden: 8231
2026-07-15 22:35:02,811 [INFO] Skipped manually modified orden: 8232
2026-07-15 22:35:02,812 [INFO] Skipped manually modified orden: 8233
2026-07-15 22:35:02,812 [INFO] Skipped manually modified orden: 8235
2026-07-15 22:35:02,813 [INFO] Skipped manually modified orden: 8236
2026-07-15 22:35:02,813 [INFO] Skipped manually modified orden: 8237
2026-07-15 22:35:02,814 [INFO] Skipped manually modified orden: 8240
2026-07-15 22:35:02,815 [INFO] Skipped manually modified orden: 8243
2026-07-15 22:35:02,815 [INFO] Skipped manually modified orden: 8244
2026-07-15 22:35:02,815 [INFO] Skipped manually modified orden: 8245
2026-07-15 22:35:02,815 [INFO] Skipped manually modified orden: 8246
2026-07-15 22:35:02,816 [INFO] Skipped manually modified orden: 8247
2026-07-15 22:35:02,816 [INFO] Skipped manually modified orden: 8248
2026-07-15 22:35:02,816 [INFO] Skipped manually modified orden: 8250
2026-07-15 22:35:02,817 [INFO] Skipped manually modified orden: 8251
2026-07-15 22:35:02,817 [INFO] Skipped manually modified orden: 8252
2026-07-15 22:35:02,817 [INFO] Skipped manually modified orden: 8253
2026-07-15 22:35:02,818 [INFO] Skipped manually modified orden: 8254
2026-07-15 22:35:02,818 [INFO] Skipped manually modified orden: 8255
2026-07-15 22:35:02,818 [INFO] Skipped manually modified orden: 8256
2026-07-15 22:35:02,818 [INFO] Skipped manually modified orden: 8257
2026-07-15 22:35:02,819 [INFO] Skipped manually modified orden: 8258
2026-07-15 22:35:02,819 [INFO] Skipped manually modified orden: 8259
2026-07-15 22:35:02,819 [INFO] Skipped manually modified orden: 8260
2026-07-15 22:35:02,819 [INFO] Skipped manually modified orden: 8263
2026-07-15 22:35:02,820 [INFO] Skipped manually modified orden: 8264
2026-07-15 22:35:02,820 [INFO] Skipped manually modified orden: 8265
2026-07-15 22:35:02,820 [INFO] Skipped manually modified orden: 8266
2026-07-15 22:35:02,820 [INFO] Skipped manually modified orden: 8267
2026-07-15 22:35:02,820 [INFO] Skipped manually modified orden: 8268
2026-07-15 22:35:02,821 [INFO] Skipped manually modified orden: 8270
2026-07-15 22:35:02,821 [INFO] Skipped manually modified orden: 8273
2026-07-15 22:35:02,821 [INFO] Skipped manually modified orden: 8274
2026-07-15 22:35:02,821 [INFO] Skipped manually modified orden: 8275
2026-07-15 22:35:02,822 [INFO] Skipped manually modified orden: 8276
2026-07-15 22:35:02,822 [INFO] Skipped manually modified orden: 8277
2026-07-15 22:35:02,822 [INFO] Skipped manually modified orden: 8278
2026-07-15 22:35:02,822 [INFO] Skipped manually modified orden: 8279
2026-07-15 22:35:02,822 [INFO] Skipped manually modified orden: 8280
2026-07-15 22:35:02,823 [INFO] Skipped manually modified orden: 8281
2026-07-15 22:35:02,823 [INFO] Skipped manually modified orden: 8282
2026-07-15 22:35:02,823 [INFO] Skipped manually modified orden: 8283
2026-07-15 22:35:02,824 [INFO] Skipped manually modified orden: 8285
2026-07-15 22:35:02,824 [INFO] Skipped manually modified orden: 8286
2026-07-15 22:35:02,825 [INFO] Skipped manually modified orden: 8288
2026-07-15 22:35:02,825 [INFO] Skipped manually modified orden: 8289
2026-07-15 22:35:02,825 [INFO] Skipped manually modified orden: 8290
2026-07-15 22:35:02,826 [INFO] Skipped manually modified orden: 8291
2026-07-15 22:35:02,828 [INFO] Skipped manually modified orden: 8296
2026-07-15 22:35:02,828 [INFO] Skipped manually modified orden: 8297
2026-07-15 22:35:02,828 [INFO] Skipped manually modified orden: 8299
2026-07-15 22:35:02,828 [INFO] Skipped manually modified orden: 8301
2026-07-15 22:35:02,828 [INFO] Skipped manually modified orden: 8302
2026-07-15 22:35:02,829 [INFO] Skipped manually modified orden: 8305
2026-07-15 22:35:02,830 [INFO] Skipped manually modified orden: 8306
2026-07-15 22:35:02,830 [INFO] Skipped manually modified orden: 8307
2026-07-15 22:35:02,830 [INFO] Skipped manually modified orden: 8308
2026-07-15 22:35:02,830 [INFO] Skipped manually modified orden: 8309
2026-07-15 22:35:02,831 [INFO] Skipped manually modified orden: 8312
2026-07-15 22:35:02,831 [INFO] Skipped manually modified orden: 8313
2026-07-15 22:35:02,832 [INFO] Skipped manually modified orden: 8314
2026-07-15 22:35:02,832 [INFO] Skipped manually modified orden: 8315
2026-07-15 22:35:02,832 [INFO] Skipped manually modified orden: 8316
2026-07-15 22:35:02,832 [INFO] Skipped manually modified orden: 8317
2026-07-15 22:35:02,833 [INFO] Skipped manually modified orden: 8318
2026-07-15 22:35:02,833 [INFO] Skipped manually modified orden: 8319
2026-07-15 22:35:02,834 [INFO] Skipped manually modified orden: 8321
2026-07-15 22:35:02,834 [INFO] Skipped manually modified orden: 8322
2026-07-15 22:35:02,834 [INFO] Skipped manually modified orden: 8323
2026-07-15 22:35:02,835 [INFO] Skipped manually modified orden: 8324
2026-07-15 22:35:02,835 [INFO] Skipped manually modified orden: 8325
2026-07-15 22:35:02,835 [INFO] Skipped manually modified orden: 8326
2026-07-15 22:35:02,835 [INFO] Skipped manually modified orden: 8327
2026-07-15 22:35:02,836 [INFO] Skipped manually modified orden: 8329
2026-07-15 22:35:02,836 [INFO] Skipped manually modified orden: 8330
2026-07-15 22:35:02,837 [INFO] Skipped manually modified orden: 8332
2026-07-15 22:35:02,837 [INFO] Skipped manually modified orden: 8333
2026-07-15 22:35:02,838 [INFO] Skipped manually modified orden: 8338
2026-07-15 22:35:02,838 [INFO] Skipped manually modified orden: 8339
2026-07-15 22:35:02,840 [INFO] Skipped manually modified orden: 8345
2026-07-15 22:35:02,840 [INFO] Skipped manually modified orden: 8346
2026-07-15 22:35:02,840 [INFO] Skipped manually modified orden: 8347
2026-07-15 22:35:02,841 [INFO] Skipped manually modified orden: 8348
2026-07-15 22:35:02,841 [INFO] Skipped manually modified orden: 8351
2026-07-15 22:35:02,842 [INFO] Skipped manually modified orden: 8353
2026-07-15 22:35:02,843 [INFO] Skipped manually modified orden: 8355
2026-07-15 22:35:02,843 [INFO] Skipped manually modified orden: 8357
2026-07-15 22:35:02,845 [INFO] Merge de órdenes completado: 0 insertadas, 377 actualizadas, 247 omitidas
2026-07-15 22:35:03,838 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 22:35:03,839 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 22:35:03,839 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 22:35:03,840 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 22:35:03,895 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,895 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,896 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,897 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,897 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,898 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,898 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,899 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,901 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,901 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 22:35:03,967 [INFO] Skipped manually modified pedido: 8051_220
2026-07-15 22:35:04,121 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-15 22:35:04,121 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-15 22:35:04,136 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 22:35:04,136 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 22:35:04,137 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 22:35:04,137 [INFO] Skipped manually modified pedido: 8138_654
2026-07-15 22:35:04,138 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 22:35:04,139 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 22:35:04,139 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 22:35:04,140 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 22:35:04,252 [INFO] Skipped manually modified pedido: 8216_662
2026-07-15 22:35:04,253 [INFO] Skipped manually modified pedido: 8216_662
2026-07-15 22:35:04,319 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 22:35:04,319 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 22:35:04,320 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 22:35:04,368 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 22:35:04,369 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 22:35:04,370 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 22:35:04,370 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 22:35:04,371 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 22:35:04,377 [INFO] Skipped manually modified pedido: 8301_675
2026-07-15 22:35:04,379 [INFO] Skipped manually modified pedido: 8304_376
2026-07-15 22:35:04,380 [INFO] Skipped manually modified pedido: 8304_376
2026-07-15 22:35:04,418 [INFO] Skipped manually modified pedido: 8339_738
2026-07-15 22:35:04,422 [INFO] Skipped manually modified pedido: 8345_36598
2026-07-15 22:35:04,422 [INFO] Skipped manually modified pedido: 8345_36623
2026-07-15 22:35:04,423 [INFO] Skipped manually modified pedido: 8346_37128
2026-07-15 22:35:04,423 [INFO] Skipped manually modified pedido: 8347_72313
2026-07-15 22:35:04,424 [INFO] Skipped manually modified pedido: 8348_73569
2026-07-15 22:35:04,425 [INFO] Skipped manually modified pedido: 8351_85175
2026-07-15 22:35:04,426 [INFO] Skipped manually modified pedido: 8353_85315
2026-07-15 22:35:04,428 [INFO] Skipped manually modified pedido: 8355_124643
2026-07-15 22:35:04,429 [INFO] Skipped manually modified pedido: 8357_124771
2026-07-15 22:35:04,430 [INFO] Merge de pedidos completado: 0 insertados, 1520 actualizados, 48 omitidos
2026-07-15 22:35:04,430 [INFO] Carga completada en 1.91s
2026-07-15 22:35:04,430 [INFO] [SUCCESS] ETL completado sin errores
2026-07-15 22:35:04,430 [INFO] === PROCESO ETL COMPLETADO EXITOSAMENTE ===
2026-07-15 22:35:04,430 [INFO] Resumen: órdenes 0, pedidos 0
Tip: Usa Ctrl+F para buscar texto específico en el log