Ver Log ETL

2025-09-14 22:00:08,536 [INFO] Iniciando proceso ETL... 2025-09-14 22:00:08,537 [INFO] === INICIO EXTRACCIÓN PEDIDOS PENDIENTES === 2025-09-14 22:00:08,537 [INFO] === EXTRACCIÓN DE PEDIDOS PENDIENTES === 2025-09-14 22:00:08,537 [INFO] Intentando conectar a SQL Server... 2025-09-14 22:00:10,093 [INFO] Conexión SQL Server exitosa 2025-09-14 22:00:10,094 [INFO] Ejecutando consulta de pedidos pendientes... 2025-09-14 22:00:12,890 [INFO] Extraídos 243 pedidos pendientes 2025-09-14 22:00:12,893 [INFO] Intentando conectar a SQL Server... 2025-09-14 22:00:13,510 [INFO] Conexión SQL Server exitosa 2025-09-14 22:00:13,510 [INFO] Extrayendo 102 órdenes relacionadas... 2025-09-14 22:00:14,587 [INFO] Preparadas 0 órdenes 2025-09-14 22:00:14,587 [INFO] Transformando pedidos pendientes... 2025-09-14 22:00:14,597 [INFO] Transformados 243 pedidos 2025-09-14 22:00:14,598 [INFO] Conectando a PostgreSQL via psycopg... 2025-09-14 22:00:14,608 [INFO] Conexión PostgreSQL exitosa 2025-09-14 22:00:14,608 [INFO] Cargando 243 pedidos pendientes 2025-09-14 22:00:14,617 [ERROR] Error cargando pedidos: insert or update on table "pedidos" violates foreign key constraint "fk_pedidos_orden" DETAIL: Key (orden_id)=(6300) is not present in table "ordenes". 2025-09-14 22:00:14,617 [ERROR] === ERROR EN EXTRACCIÓN PEDIDOS PENDIENTES ===