Archivo:
etl_20260715_143501.log
Modificado:
15/07/2026 14:35:04
Tamaño:
26.0 KB
Líneas:
337 líneas
2026-07-15 14:35:01,863 [INFO] Iniciando proceso ETL...
2026-07-15 14:35:01,863 [INFO] === INICIO ETL ===
2026-07-15 14:35:01,863 [INFO] Paso 0: Sincronización de IDs
2026-07-15 14:35:01,863 [INFO] Sincronizando tabla pedidos_id_mapping...
2026-07-15 14:35:01,864 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 14:35:01,873 [INFO] Conexión PostgreSQL exitosa
2026-07-15 14:35:01,906 [INFO] Sincronización completada: 0 nuevos IDs asignados
2026-07-15 14:35:01,906 [INFO] Paso 1: Extracción de datos
2026-07-15 14:35:01,906 [INFO] Iniciando extracción de cabeceras
2026-07-15 14:35:01,906 [INFO] Extrayendo órdenes desde linux_ordenes...
2026-07-15 14:35:01,906 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 14:35:01,915 [INFO] Conexión PostgreSQL exitosa
2026-07-15 14:35:01,915 [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 14:35:01,938 [INFO] Extraídas 624 órdenes
2026-07-15 14:35:01,939 [INFO] [DEBUG] Columnas ordenes: ['numero', 'cliente', 'vendedor', 'fecha_entrega', 'dias_restantes', 'estatus']
2026-07-15 14:35:01,939 [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 14:35:01,947 [INFO] [DEBUG] Nulos en fecha_entrega (ordenes) tras limpiar: 0
2026-07-15 14:35:01,948 [INFO] Iniciando extracción de líneas
2026-07-15 14:35:01,948 [INFO] Extrayendo pedidos desde linux_pedidos...
2026-07-15 14:35:01,948 [INFO] Conectando a PostgreSQL via psycopg...
2026-07-15 14:35:01,957 [INFO] Conexión PostgreSQL exitosa
2026-07-15 14:35:01,957 [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 14:35:02,424 [INFO] Extraídos 1564 pedidos
2026-07-15 14:35:02,424 [INFO] [DEBUG] Columnas pedidos: ['id', 'orden_id', 'clave', 'producto', 'unidad', 'cantidad', 'surtido', 'liq', 'saldo', 'fecha_entrega', 'remision']
2026-07-15 14:35:02,425 [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 14:35:02,435 [WARNING] Encontradas 2 fechas inválidas en fecha_entrega
2026-07-15 14:35:02,436 [INFO] [DEBUG] Nulos en fecha_entrega (pedidos) tras limpiar: 2
2026-07-15 14:35:02,436 [INFO] Extraídas 1564 líneas
2026-07-15 14:35:02,436 [INFO] Extracción completada en 0.53s
2026-07-15 14:35:02,436 [INFO] Paso 2: Transformación de datos
2026-07-15 14:35:02,436 [INFO] Transformando datos de cabeceras
2026-07-15 14:35:02,437 [INFO] [DEBUG] Nulos por columna (cabeceras): {'numero': 0, 'cliente': 0, 'vendedor': 0, 'fecha_entrega': 0, 'dias_restantes': 0, 'estatus': 0}
2026-07-15 14:35:02,472 [INFO] Transformadas 624 cabeceras
2026-07-15 14:35:02,473 [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 14:35:02,473 [INFO] Transformando datos de líneas
2026-07-15 14:35:02,474 [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 14:35:02,563 [INFO] Transformadas 1564 líneas
2026-07-15 14:35:02,564 [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 14:35:02,564 [INFO] Transformación completada en 0.13s
2026-07-15 14:35:02,564 [INFO] Paso 3: Carga de datos
2026-07-15 14:35:02,689 [INFO] Skipped manually modified orden: 7704
2026-07-15 14:35:02,697 [INFO] Skipped manually modified orden: 7718
2026-07-15 14:35:02,697 [INFO] Skipped manually modified orden: 7719
2026-07-15 14:35:02,698 [INFO] Skipped manually modified orden: 7720
2026-07-15 14:35:02,702 [INFO] Skipped manually modified orden: 7729
2026-07-15 14:35:02,703 [INFO] Skipped manually modified orden: 7731
2026-07-15 14:35:02,709 [INFO] Skipped manually modified orden: 7745
2026-07-15 14:35:02,711 [INFO] Skipped manually modified orden: 7748
2026-07-15 14:35:02,712 [INFO] Skipped manually modified orden: 7751
2026-07-15 14:35:02,729 [INFO] Skipped manually modified orden: 7792
2026-07-15 14:35:02,732 [INFO] Skipped manually modified orden: 7799
2026-07-15 14:35:02,733 [INFO] Skipped manually modified orden: 7801
2026-07-15 14:35:02,742 [INFO] Skipped manually modified orden: 7823
2026-07-15 14:35:02,745 [INFO] Skipped manually modified orden: 7833
2026-07-15 14:35:02,746 [INFO] Skipped manually modified orden: 7834
2026-07-15 14:35:02,746 [INFO] Skipped manually modified orden: 7835
2026-07-15 14:35:02,765 [INFO] Skipped manually modified orden: 7881
2026-07-15 14:35:02,773 [INFO] Skipped manually modified orden: 7898
2026-07-15 14:35:02,773 [INFO] Skipped manually modified orden: 7899
2026-07-15 14:35:02,808 [INFO] Skipped manually modified orden: 7980
2026-07-15 14:35:02,811 [INFO] Skipped manually modified orden: 7985
2026-07-15 14:35:02,822 [INFO] Skipped manually modified orden: 8014
2026-07-15 14:35:02,827 [INFO] Skipped manually modified orden: 8026
2026-07-15 14:35:02,829 [INFO] Skipped manually modified orden: 8030
2026-07-15 14:35:02,831 [INFO] Skipped manually modified orden: 8036
2026-07-15 14:35:02,832 [INFO] Skipped manually modified orden: 8037
2026-07-15 14:35:02,832 [INFO] Skipped manually modified orden: 8039
2026-07-15 14:35:02,836 [INFO] Skipped manually modified orden: 8050
2026-07-15 14:35:02,837 [INFO] Skipped manually modified orden: 8051
2026-07-15 14:35:02,839 [INFO] Skipped manually modified orden: 8056
2026-07-15 14:35:02,840 [INFO] Skipped manually modified orden: 8057
2026-07-15 14:35:02,840 [INFO] Skipped manually modified orden: 8058
2026-07-15 14:35:02,844 [INFO] Skipped manually modified orden: 8066
2026-07-15 14:35:02,844 [INFO] Skipped manually modified orden: 8067
2026-07-15 14:35:02,846 [INFO] Skipped manually modified orden: 8071
2026-07-15 14:35:02,846 [INFO] Skipped manually modified orden: 8072
2026-07-15 14:35:02,849 [INFO] Skipped manually modified orden: 8076
2026-07-15 14:35:02,849 [INFO] Skipped manually modified orden: 8077
2026-07-15 14:35:02,849 [INFO] Skipped manually modified orden: 8078
2026-07-15 14:35:02,850 [INFO] Skipped manually modified orden: 8079
2026-07-15 14:35:02,850 [INFO] Skipped manually modified orden: 8080
2026-07-15 14:35:02,851 [INFO] Skipped manually modified orden: 8081
2026-07-15 14:35:02,851 [INFO] Skipped manually modified orden: 8082
2026-07-15 14:35:02,851 [INFO] Skipped manually modified orden: 8083
2026-07-15 14:35:02,852 [INFO] Skipped manually modified orden: 8084
2026-07-15 14:35:02,852 [INFO] Skipped manually modified orden: 8085
2026-07-15 14:35:02,853 [INFO] Skipped manually modified orden: 8086
2026-07-15 14:35:02,853 [INFO] Skipped manually modified orden: 8087
2026-07-15 14:35:02,853 [INFO] Skipped manually modified orden: 8088
2026-07-15 14:35:02,854 [INFO] Skipped manually modified orden: 8089
2026-07-15 14:35:02,854 [INFO] Skipped manually modified orden: 8090
2026-07-15 14:35:02,854 [INFO] Skipped manually modified orden: 8091
2026-07-15 14:35:02,855 [INFO] Skipped manually modified orden: 8092
2026-07-15 14:35:02,855 [INFO] Skipped manually modified orden: 8093
2026-07-15 14:35:02,856 [INFO] Skipped manually modified orden: 8094
2026-07-15 14:35:02,857 [INFO] Skipped manually modified orden: 8096
2026-07-15 14:35:02,857 [INFO] Skipped manually modified orden: 8097
2026-07-15 14:35:02,858 [INFO] Skipped manually modified orden: 8099
2026-07-15 14:35:02,859 [INFO] Skipped manually modified orden: 8100
2026-07-15 14:35:02,859 [INFO] Skipped manually modified orden: 8101
2026-07-15 14:35:02,859 [INFO] Skipped manually modified orden: 8102
2026-07-15 14:35:02,860 [INFO] Skipped manually modified orden: 8103
2026-07-15 14:35:02,860 [INFO] Skipped manually modified orden: 8104
2026-07-15 14:35:02,861 [INFO] Skipped manually modified orden: 8105
2026-07-15 14:35:02,861 [INFO] Skipped manually modified orden: 8106
2026-07-15 14:35:02,862 [INFO] Skipped manually modified orden: 8108
2026-07-15 14:35:02,862 [INFO] Skipped manually modified orden: 8109
2026-07-15 14:35:02,863 [INFO] Skipped manually modified orden: 8110
2026-07-15 14:35:02,863 [INFO] Skipped manually modified orden: 8111
2026-07-15 14:35:02,863 [INFO] Skipped manually modified orden: 8112
2026-07-15 14:35:02,863 [INFO] Skipped manually modified orden: 8113
2026-07-15 14:35:02,864 [INFO] Skipped manually modified orden: 8114
2026-07-15 14:35:02,864 [INFO] Skipped manually modified orden: 8115
2026-07-15 14:35:02,864 [INFO] Skipped manually modified orden: 8116
2026-07-15 14:35:02,865 [INFO] Skipped manually modified orden: 8118
2026-07-15 14:35:02,865 [INFO] Skipped manually modified orden: 8119
2026-07-15 14:35:02,866 [INFO] Skipped manually modified orden: 8120
2026-07-15 14:35:02,866 [INFO] Skipped manually modified orden: 8121
2026-07-15 14:35:02,866 [INFO] Skipped manually modified orden: 8122
2026-07-15 14:35:02,867 [INFO] Skipped manually modified orden: 8123
2026-07-15 14:35:02,867 [INFO] Skipped manually modified orden: 8124
2026-07-15 14:35:02,867 [INFO] Skipped manually modified orden: 8125
2026-07-15 14:35:02,868 [INFO] Skipped manually modified orden: 8126
2026-07-15 14:35:02,868 [INFO] Skipped manually modified orden: 8127
2026-07-15 14:35:02,869 [INFO] Skipped manually modified orden: 8128
2026-07-15 14:35:02,869 [INFO] Skipped manually modified orden: 8129
2026-07-15 14:35:02,869 [INFO] Skipped manually modified orden: 8130
2026-07-15 14:35:02,870 [INFO] Skipped manually modified orden: 8131
2026-07-15 14:35:02,870 [INFO] Skipped manually modified orden: 8132
2026-07-15 14:35:02,870 [INFO] Skipped manually modified orden: 8133
2026-07-15 14:35:02,871 [INFO] Skipped manually modified orden: 8134
2026-07-15 14:35:02,871 [INFO] Skipped manually modified orden: 8136
2026-07-15 14:35:02,873 [INFO] Skipped manually modified orden: 8139
2026-07-15 14:35:02,873 [INFO] Skipped manually modified orden: 8141
2026-07-15 14:35:02,873 [INFO] Skipped manually modified orden: 8142
2026-07-15 14:35:02,873 [INFO] Skipped manually modified orden: 8143
2026-07-15 14:35:02,874 [INFO] Skipped manually modified orden: 8144
2026-07-15 14:35:02,875 [INFO] Skipped manually modified orden: 8146
2026-07-15 14:35:02,875 [INFO] Skipped manually modified orden: 8147
2026-07-15 14:35:02,875 [INFO] Skipped manually modified orden: 8148
2026-07-15 14:35:02,876 [INFO] Skipped manually modified orden: 8150
2026-07-15 14:35:02,877 [INFO] Skipped manually modified orden: 8151
2026-07-15 14:35:02,878 [INFO] Skipped manually modified orden: 8154
2026-07-15 14:35:02,879 [INFO] Skipped manually modified orden: 8155
2026-07-15 14:35:02,879 [INFO] Skipped manually modified orden: 8156
2026-07-15 14:35:02,879 [INFO] Skipped manually modified orden: 8157
2026-07-15 14:35:02,880 [INFO] Skipped manually modified orden: 8158
2026-07-15 14:35:02,880 [INFO] Skipped manually modified orden: 8159
2026-07-15 14:35:02,880 [INFO] Skipped manually modified orden: 8160
2026-07-15 14:35:02,881 [INFO] Skipped manually modified orden: 8161
2026-07-15 14:35:02,881 [INFO] Skipped manually modified orden: 8162
2026-07-15 14:35:02,881 [INFO] Skipped manually modified orden: 8164
2026-07-15 14:35:02,882 [INFO] Skipped manually modified orden: 8165
2026-07-15 14:35:02,882 [INFO] Skipped manually modified orden: 8166
2026-07-15 14:35:02,882 [INFO] Skipped manually modified orden: 8167
2026-07-15 14:35:02,883 [INFO] Skipped manually modified orden: 8168
2026-07-15 14:35:02,883 [INFO] Skipped manually modified orden: 8169
2026-07-15 14:35:02,883 [INFO] Skipped manually modified orden: 8170
2026-07-15 14:35:02,883 [INFO] Skipped manually modified orden: 8172
2026-07-15 14:35:02,884 [INFO] Skipped manually modified orden: 8173
2026-07-15 14:35:02,884 [INFO] Skipped manually modified orden: 8174
2026-07-15 14:35:02,884 [INFO] Skipped manually modified orden: 8177
2026-07-15 14:35:02,884 [INFO] Skipped manually modified orden: 8178
2026-07-15 14:35:02,885 [INFO] Skipped manually modified orden: 8179
2026-07-15 14:35:02,885 [INFO] Skipped manually modified orden: 8181
2026-07-15 14:35:02,885 [INFO] Skipped manually modified orden: 8182
2026-07-15 14:35:02,886 [INFO] Skipped manually modified orden: 8183
2026-07-15 14:35:02,886 [INFO] Skipped manually modified orden: 8184
2026-07-15 14:35:02,886 [INFO] Skipped manually modified orden: 8185
2026-07-15 14:35:02,887 [INFO] Skipped manually modified orden: 8187
2026-07-15 14:35:02,888 [INFO] Skipped manually modified orden: 8191
2026-07-15 14:35:02,888 [INFO] Skipped manually modified orden: 8192
2026-07-15 14:35:02,888 [INFO] Skipped manually modified orden: 8193
2026-07-15 14:35:02,889 [INFO] Skipped manually modified orden: 8194
2026-07-15 14:35:02,889 [INFO] Skipped manually modified orden: 8196
2026-07-15 14:35:02,890 [INFO] Skipped manually modified orden: 8197
2026-07-15 14:35:02,890 [INFO] Skipped manually modified orden: 8198
2026-07-15 14:35:02,890 [INFO] Skipped manually modified orden: 8199
2026-07-15 14:35:02,890 [INFO] Skipped manually modified orden: 8201
2026-07-15 14:35:02,891 [INFO] Skipped manually modified orden: 8202
2026-07-15 14:35:02,892 [INFO] Skipped manually modified orden: 8205
2026-07-15 14:35:02,892 [INFO] Skipped manually modified orden: 8206
2026-07-15 14:35:02,893 [INFO] Skipped manually modified orden: 8208
2026-07-15 14:35:02,893 [INFO] Skipped manually modified orden: 8209
2026-07-15 14:35:02,893 [INFO] Skipped manually modified orden: 8210
2026-07-15 14:35:02,893 [INFO] Skipped manually modified orden: 8211
2026-07-15 14:35:02,894 [INFO] Skipped manually modified orden: 8212
2026-07-15 14:35:02,894 [INFO] Skipped manually modified orden: 8214
2026-07-15 14:35:02,894 [INFO] Skipped manually modified orden: 8215
2026-07-15 14:35:02,894 [INFO] Skipped manually modified orden: 8216
2026-07-15 14:35:02,895 [INFO] Skipped manually modified orden: 8217
2026-07-15 14:35:02,895 [INFO] Skipped manually modified orden: 8219
2026-07-15 14:35:02,896 [INFO] Skipped manually modified orden: 8220
2026-07-15 14:35:02,896 [INFO] Skipped manually modified orden: 8221
2026-07-15 14:35:02,896 [INFO] Skipped manually modified orden: 8222
2026-07-15 14:35:02,896 [INFO] Skipped manually modified orden: 8223
2026-07-15 14:35:02,897 [INFO] Skipped manually modified orden: 8225
2026-07-15 14:35:02,897 [INFO] Skipped manually modified orden: 8227
2026-07-15 14:35:02,898 [INFO] Skipped manually modified orden: 8228
2026-07-15 14:35:02,898 [INFO] Skipped manually modified orden: 8229
2026-07-15 14:35:02,898 [INFO] Skipped manually modified orden: 8231
2026-07-15 14:35:02,898 [INFO] Skipped manually modified orden: 8232
2026-07-15 14:35:02,899 [INFO] Skipped manually modified orden: 8233
2026-07-15 14:35:02,899 [INFO] Skipped manually modified orden: 8235
2026-07-15 14:35:02,900 [INFO] Skipped manually modified orden: 8236
2026-07-15 14:35:02,900 [INFO] Skipped manually modified orden: 8237
2026-07-15 14:35:02,901 [INFO] Skipped manually modified orden: 8240
2026-07-15 14:35:02,902 [INFO] Skipped manually modified orden: 8243
2026-07-15 14:35:02,902 [INFO] Skipped manually modified orden: 8244
2026-07-15 14:35:02,902 [INFO] Skipped manually modified orden: 8245
2026-07-15 14:35:02,902 [INFO] Skipped manually modified orden: 8246
2026-07-15 14:35:02,903 [INFO] Skipped manually modified orden: 8247
2026-07-15 14:35:02,903 [INFO] Skipped manually modified orden: 8248
2026-07-15 14:35:02,903 [INFO] Skipped manually modified orden: 8250
2026-07-15 14:35:02,904 [INFO] Skipped manually modified orden: 8251
2026-07-15 14:35:02,904 [INFO] Skipped manually modified orden: 8252
2026-07-15 14:35:02,904 [INFO] Skipped manually modified orden: 8253
2026-07-15 14:35:02,904 [INFO] Skipped manually modified orden: 8254
2026-07-15 14:35:02,905 [INFO] Skipped manually modified orden: 8255
2026-07-15 14:35:02,905 [INFO] Skipped manually modified orden: 8256
2026-07-15 14:35:02,905 [INFO] Skipped manually modified orden: 8257
2026-07-15 14:35:02,905 [INFO] Skipped manually modified orden: 8258
2026-07-15 14:35:02,906 [INFO] Skipped manually modified orden: 8259
2026-07-15 14:35:02,906 [INFO] Skipped manually modified orden: 8260
2026-07-15 14:35:02,906 [INFO] Skipped manually modified orden: 8263
2026-07-15 14:35:02,906 [INFO] Skipped manually modified orden: 8264
2026-07-15 14:35:02,907 [INFO] Skipped manually modified orden: 8265
2026-07-15 14:35:02,907 [INFO] Skipped manually modified orden: 8266
2026-07-15 14:35:02,907 [INFO] Skipped manually modified orden: 8267
2026-07-15 14:35:02,908 [INFO] Skipped manually modified orden: 8268
2026-07-15 14:35:02,908 [INFO] Skipped manually modified orden: 8270
2026-07-15 14:35:02,908 [INFO] Skipped manually modified orden: 8273
2026-07-15 14:35:02,908 [INFO] Skipped manually modified orden: 8274
2026-07-15 14:35:02,909 [INFO] Skipped manually modified orden: 8275
2026-07-15 14:35:02,909 [INFO] Skipped manually modified orden: 8276
2026-07-15 14:35:02,909 [INFO] Skipped manually modified orden: 8277
2026-07-15 14:35:02,909 [INFO] Skipped manually modified orden: 8278
2026-07-15 14:35:02,910 [INFO] Skipped manually modified orden: 8279
2026-07-15 14:35:02,910 [INFO] Skipped manually modified orden: 8280
2026-07-15 14:35:02,910 [INFO] Skipped manually modified orden: 8281
2026-07-15 14:35:02,911 [INFO] Skipped manually modified orden: 8282
2026-07-15 14:35:02,911 [INFO] Skipped manually modified orden: 8283
2026-07-15 14:35:02,912 [INFO] Skipped manually modified orden: 8285
2026-07-15 14:35:02,912 [INFO] Skipped manually modified orden: 8286
2026-07-15 14:35:02,913 [INFO] Skipped manually modified orden: 8288
2026-07-15 14:35:02,913 [INFO] Skipped manually modified orden: 8289
2026-07-15 14:35:02,913 [INFO] Skipped manually modified orden: 8290
2026-07-15 14:35:02,914 [INFO] Skipped manually modified orden: 8291
2026-07-15 14:35:02,916 [INFO] Skipped manually modified orden: 8296
2026-07-15 14:35:02,916 [INFO] Skipped manually modified orden: 8297
2026-07-15 14:35:02,916 [INFO] Skipped manually modified orden: 8299
2026-07-15 14:35:02,916 [INFO] Skipped manually modified orden: 8301
2026-07-15 14:35:02,917 [INFO] Skipped manually modified orden: 8302
2026-07-15 14:35:02,917 [INFO] Skipped manually modified orden: 8305
2026-07-15 14:35:02,918 [INFO] Skipped manually modified orden: 8306
2026-07-15 14:35:02,918 [INFO] Skipped manually modified orden: 8307
2026-07-15 14:35:02,918 [INFO] Skipped manually modified orden: 8308
2026-07-15 14:35:02,919 [INFO] Skipped manually modified orden: 8309
2026-07-15 14:35:02,919 [INFO] Skipped manually modified orden: 8312
2026-07-15 14:35:02,920 [INFO] Skipped manually modified orden: 8313
2026-07-15 14:35:02,920 [INFO] Skipped manually modified orden: 8314
2026-07-15 14:35:02,920 [INFO] Skipped manually modified orden: 8315
2026-07-15 14:35:02,921 [INFO] Skipped manually modified orden: 8316
2026-07-15 14:35:02,921 [INFO] Skipped manually modified orden: 8317
2026-07-15 14:35:02,921 [INFO] Skipped manually modified orden: 8318
2026-07-15 14:35:02,922 [INFO] Skipped manually modified orden: 8319
2026-07-15 14:35:02,922 [INFO] Skipped manually modified orden: 8321
2026-07-15 14:35:02,923 [INFO] Skipped manually modified orden: 8322
2026-07-15 14:35:02,923 [INFO] Skipped manually modified orden: 8323
2026-07-15 14:35:02,923 [INFO] Skipped manually modified orden: 8324
2026-07-15 14:35:02,923 [INFO] Skipped manually modified orden: 8325
2026-07-15 14:35:02,924 [INFO] Skipped manually modified orden: 8326
2026-07-15 14:35:02,924 [INFO] Skipped manually modified orden: 8327
2026-07-15 14:35:02,925 [INFO] Skipped manually modified orden: 8329
2026-07-15 14:35:02,925 [INFO] Skipped manually modified orden: 8330
2026-07-15 14:35:02,925 [INFO] Skipped manually modified orden: 8332
2026-07-15 14:35:02,926 [INFO] Skipped manually modified orden: 8333
2026-07-15 14:35:02,927 [INFO] Skipped manually modified orden: 8338
2026-07-15 14:35:02,927 [INFO] Skipped manually modified orden: 8339
2026-07-15 14:35:02,929 [INFO] Skipped manually modified orden: 8345
2026-07-15 14:35:02,929 [INFO] Skipped manually modified orden: 8346
2026-07-15 14:35:02,929 [INFO] Skipped manually modified orden: 8347
2026-07-15 14:35:02,930 [INFO] Skipped manually modified orden: 8348
2026-07-15 14:35:02,930 [INFO] Skipped manually modified orden: 8351
2026-07-15 14:35:02,931 [INFO] Skipped manually modified orden: 8353
2026-07-15 14:35:02,932 [INFO] Skipped manually modified orden: 8355
2026-07-15 14:35:02,933 [INFO] Skipped manually modified orden: 8357
2026-07-15 14:35:02,935 [INFO] Merge de órdenes completado: 0 insertadas, 377 actualizadas, 247 omitidas
2026-07-15 14:35:03,832 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 14:35:03,833 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 14:35:03,834 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 14:35:03,835 [INFO] Skipped manually modified pedido: 8033_330
2026-07-15 14:35:03,893 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,894 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,895 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,895 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,896 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,896 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,896 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,897 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,897 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,898 [INFO] Skipped manually modified pedido: 8036_591
2026-07-15 14:35:03,954 [INFO] Skipped manually modified pedido: 8051_220
2026-07-15 14:35:04,121 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-15 14:35:04,121 [WARNING] Skipping pedido 8135_501: orden 8135 no existe en la base de datos
2026-07-15 14:35:04,140 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 14:35:04,141 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 14:35:04,141 [INFO] Skipped manually modified pedido: 8138_658
2026-07-15 14:35:04,266 [INFO] Skipped manually modified pedido: 8216_662
2026-07-15 14:35:04,267 [INFO] Skipped manually modified pedido: 8216_662
2026-07-15 14:35:04,332 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 14:35:04,332 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 14:35:04,333 [INFO] Skipped manually modified pedido: 8249_355
2026-07-15 14:35:04,384 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 14:35:04,385 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 14:35:04,386 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 14:35:04,386 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 14:35:04,387 [INFO] Skipped manually modified pedido: 8292_484
2026-07-15 14:35:04,395 [INFO] Skipped manually modified pedido: 8301_675
2026-07-15 14:35:04,396 [INFO] Skipped manually modified pedido: 8304_376
2026-07-15 14:35:04,397 [INFO] Skipped manually modified pedido: 8304_376
2026-07-15 14:35:04,439 [INFO] Skipped manually modified pedido: 8339_738
2026-07-15 14:35:04,443 [INFO] Skipped manually modified pedido: 8345_36598
2026-07-15 14:35:04,443 [INFO] Skipped manually modified pedido: 8345_36623
2026-07-15 14:35:04,444 [INFO] Skipped manually modified pedido: 8346_37128
2026-07-15 14:35:04,444 [INFO] Skipped manually modified pedido: 8347_72313
2026-07-15 14:35:04,445 [INFO] Skipped manually modified pedido: 8348_73569
2026-07-15 14:35:04,446 [INFO] Skipped manually modified pedido: 8351_85175
2026-07-15 14:35:04,447 [INFO] Skipped manually modified pedido: 8353_85315
2026-07-15 14:35:04,448 [INFO] Skipped manually modified pedido: 8355_124643
2026-07-15 14:35:04,450 [INFO] Skipped manually modified pedido: 8357_124771
2026-07-15 14:35:04,454 [INFO] Merge de pedidos completado: 0 insertados, 1521 actualizados, 43 omitidos
2026-07-15 14:35:04,454 [INFO] Carga completada en 1.89s
2026-07-15 14:35:04,454 [INFO] [SUCCESS] ETL completado sin errores
2026-07-15 14:35:04,454 [INFO] === PROCESO ETL COMPLETADO EXITOSAMENTE ===
2026-07-15 14:35:04,454 [INFO] Resumen: órdenes 0, pedidos 0
Tip: Usa Ctrl+F para buscar texto específico en el log