Archivo:
etl_20250829_070142.log
Modificado:
29/08/2025 07:01:50
Tamaño:
31.8 KB
Líneas:
364 líneas
2025-08-29 07:01:42,220 [INFO] Iniciando proceso ETL...
2025-08-29 07:01:42,221 [INFO] === INICIO ETL ===
2025-08-29 07:01:42,221 [INFO] Paso 1: Extracción de datos
2025-08-29 07:01:42,221 [INFO] Iniciando extracción de cabeceras
2025-08-29 07:01:42,221 [INFO] Extrayendo órdenes desde linux_ordenes...
2025-08-29 07:01:42,221 [INFO] Intentando conectar a SQL Server...
2025-08-29 07:01:43,279 [INFO] Conexión SQL Server exitosa
2025-08-29 07:01:43,279 [INFO] Ejecutando consulta (últimos 30 días desde 2025-07-30): SELECT numero, cliente, vendedor, fecha_entrega, dias_restantes, estatus FROM dbo.linux_ordenes WHERE fecha_entrega >= ?
2025-08-29 07:01:44,627 [INFO] Extraídas 157 órdenes
2025-08-29 07:01:44,627 [INFO] [DEBUG] Columnas ordenes: ['numero', 'cliente', 'vendedor', 'fecha_entrega', 'dias_restantes', 'estatus']
2025-08-29 07:01:44,627 [INFO] [DEBUG] dtypes ordenes: {'numero': dtype('O'), 'cliente': dtype('O'), 'vendedor': dtype('O'), 'fecha_entrega': dtype('O'), 'dias_restantes': dtype('int64'), 'estatus': dtype('O')}
2025-08-29 07:01:44,634 [INFO] [DEBUG] Nulos en fecha_entrega (ordenes) tras limpiar: 0
2025-08-29 07:01:44,730 [INFO] Iniciando extracción de líneas
2025-08-29 07:01:44,730 [INFO] Extrayendo pedidos desde linux_pedidos...
2025-08-29 07:01:44,730 [INFO] Intentando conectar a SQL Server...
2025-08-29 07:01:45,312 [INFO] Conexión SQL Server exitosa
2025-08-29 07:01:45,312 [INFO] Ejecutando consulta (últimos 30 días desde 2025-07-30): SELECT id, orden_id, clave, producto, unidad, cantidad, surtido, liq, saldo, fecha_entrega FROM dbo.linux_pedidos WHERE fecha_entrega >= ?
2025-08-29 07:01:49,773 [INFO] Extraídos 242 pedidos
2025-08-29 07:01:49,773 [INFO] [DEBUG] Columnas pedidos: ['id', 'orden_id', 'clave', 'producto', 'unidad', 'cantidad', 'surtido', 'liq', 'saldo', 'fecha_entrega']
2025-08-29 07:01:49,774 [INFO] [DEBUG] dtypes pedidos: {'id': dtype('O'), 'orden_id': dtype('float64'), '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')}
2025-08-29 07:01:49,780 [INFO] [DEBUG] Nulos en fecha_entrega (pedidos) tras limpiar: 0
2025-08-29 07:01:49,876 [INFO] Extraídas 242 líneas
2025-08-29 07:01:49,876 [INFO] Extracción completada en 7.66s
2025-08-29 07:01:49,876 [INFO] Paso 2: Transformación de datos
2025-08-29 07:01:49,876 [INFO] Transformando datos de cabeceras
2025-08-29 07:01:49,877 [INFO] [DEBUG] Nulos por columna (cabeceras): {'numero': 0, 'cliente': 0, 'vendedor': 0, 'fecha_entrega': 0, 'dias_restantes': 0, 'estatus': 0}
2025-08-29 07:01:49,884 [INFO] Transformadas 157 cabeceras
2025-08-29 07:01:49,885 [INFO] [DEBUG] Ejemplo cabeceras transformadas (3): [{'numero': '7252', 'cliente': 'FINE TEC MOLDES', 'vendedor': 'ERICKA IVONNE DELGADO HUERTA', 'fecha_entrega': '2025-08-27', 'estatus': 'completado', 'dias_restantes': -2}, {'numero': '7238', 'cliente': 'HUSSMANN CORPORATION', 'vendedor': 'LF', 'fecha_entrega': '2025-08-29', 'estatus': 'completado', 'dias_restantes': 0}, {'numero': '7150', 'cliente': 'SISTEMAS AUTOMOTRICES DE MEXICO', 'vendedor': 'ANTONIO GARZA', 'fecha_entrega': '2025-08-04', 'estatus': 'completado', 'dias_restantes': -25}]
2025-08-29 07:01:49,885 [INFO] Transformando datos de líneas
2025-08-29 07:01:49,885 [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': 0}
2025-08-29 07:01:49,896 [INFO] Transformadas 242 líneas
2025-08-29 07:01:49,896 [INFO] [DEBUG] Ejemplo líneas transformadas (3): [{'id': '6328_8936', 'ID_UNICO': '6328_8936', 'orden_id': '6328.0', 'clave': '3180360', 'producto': 'TH318 SELLADOR PARABRISAS NEGRO 600 ML', 'unidad': 'PIEZA', 'cantidad': 100, 'surtido': 100, 'liq': 100, 'saldo': 0, 'fecha_entrega': '2025-12-31', 'dias_restantes': 124, 'entregado': 1, 'estatus': 'completado', 'fecha_completado': None, 'F_Alta': None, 'remision_producto': None}, {'id': '6336_8944', 'ID_UNICO': '6336_8944', 'orden_id': '6336.0', 'clave': '1100019', 'producto': 'TAPE AVERY ADHESIVE TRANSFER 1 1/2', 'unidad': 'METRO', 'cantidad': 25, 'surtido': 0, 'liq': 25, 'saldo': 25, 'fecha_entrega': '2025-10-01', 'dias_restantes': 33, 'entregado': 0, 'estatus': 'pendiente', 'fecha_completado': None, 'F_Alta': None, 'remision_producto': None}, {'id': '6373_8992', 'ID_UNICO': '6373_8992', 'orden_id': '6373.0', 'clave': '361602', 'producto': 'SELF SEALER 616, WHITE 2 LT', 'unidad': 'LITRO', 'cantidad': 1762, 'surtido': 0, 'liq': 1762, 'saldo': 1762, 'fecha_entrega': '2025-12-31', 'dias_restantes': 124, 'entregado': 0, 'estatus': 'pendiente', 'fecha_completado': None, 'F_Alta': None, 'remision_producto': None}]
2025-08-29 07:01:49,896 [INFO] Transformación completada en 0.02s
2025-08-29 07:01:49,896 [INFO] Paso 3: Carga de datos
2025-08-29 07:01:49,897 [INFO] Conectando a PostgreSQL via psycopg...
2025-08-29 07:01:49,907 [INFO] Conexión PostgreSQL exitosa
2025-08-29 07:01:49,907 [INFO] [DEBUG] Total ordenes a upsert en PostgreSQL: 157
2025-08-29 07:01:49,907 [INFO] [DEBUG] Nulos 'numero': 0 | Nulos 'fecha_entrega': 0
2025-08-29 07:01:49,911 [ERROR] Error upsert orden 7252: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7252) already exists.
2025-08-29 07:01:49,912 [ERROR] Error upsert orden 7238: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7238) already exists.
2025-08-29 07:01:49,913 [ERROR] Error upsert orden 7150: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7150) already exists.
2025-08-29 07:01:49,913 [ERROR] Error upsert orden 7198: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7198) already exists.
2025-08-29 07:01:49,914 [ERROR] Error upsert orden 7124: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7124) already exists.
2025-08-29 07:01:49,915 [ERROR] Error upsert orden 7250: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7250) already exists.
2025-08-29 07:01:49,916 [ERROR] Error upsert orden 7259: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7259) already exists.
2025-08-29 07:01:49,917 [ERROR] Error upsert orden 7126: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7126) already exists.
2025-08-29 07:01:49,918 [ERROR] Error upsert orden 7147: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7147) already exists.
2025-08-29 07:01:49,918 [ERROR] Error upsert orden 7146: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7146) already exists.
2025-08-29 07:01:49,919 [ERROR] Error upsert orden 7125: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7125) already exists.
2025-08-29 07:01:49,920 [ERROR] Error upsert orden 7257: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7257) already exists.
2025-08-29 07:01:49,921 [ERROR] Error upsert orden 7248: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7248) already exists.
2025-08-29 07:01:49,922 [ERROR] Error upsert orden 7144: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7144) already exists.
2025-08-29 07:01:49,922 [ERROR] Error upsert orden 7246: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7246) already exists.
2025-08-29 07:01:49,923 [ERROR] Error upsert orden 7212: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7212) already exists.
2025-08-29 07:01:49,924 [ERROR] Error upsert orden 7251: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7251) already exists.
2025-08-29 07:01:49,926 [ERROR] Error upsert orden 7105: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7105) already exists.
2025-08-29 07:01:49,926 [ERROR] Error upsert orden 7169: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7169) already exists.
2025-08-29 07:01:49,927 [ERROR] Error upsert orden 7127: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7127) already exists.
2025-08-29 07:01:49,928 [ERROR] Error upsert orden 7258: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7258) already exists.
2025-08-29 07:01:49,929 [ERROR] Error upsert orden 7156: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7156) already exists.
2025-08-29 07:01:49,931 [ERROR] Error upsert orden 7189: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7189) already exists.
2025-08-29 07:01:49,933 [ERROR] Error upsert orden 7211: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7211) already exists.
2025-08-29 07:01:49,935 [ERROR] Error upsert orden 6855: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(6855) already exists.
2025-08-29 07:01:49,937 [ERROR] Error upsert orden 7138: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7138) already exists.
2025-08-29 07:01:49,939 [ERROR] Error upsert orden 7167: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7167) already exists.
2025-08-29 07:01:49,940 [ERROR] Error upsert orden 7184: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7184) already exists.
2025-08-29 07:01:49,941 [ERROR] Error upsert orden 7237: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7237) already exists.
2025-08-29 07:01:49,943 [ERROR] Error upsert orden 7129: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7129) already exists.
2025-08-29 07:01:49,944 [ERROR] Error upsert orden 7174: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7174) already exists.
2025-08-29 07:01:49,945 [ERROR] Error upsert orden 7221: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7221) already exists.
2025-08-29 07:01:49,947 [ERROR] Error upsert orden 7110: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7110) already exists.
2025-08-29 07:01:49,948 [ERROR] Error upsert orden 7171: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7171) already exists.
2025-08-29 07:01:49,949 [ERROR] Error upsert orden 7178: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7178) already exists.
2025-08-29 07:01:49,951 [ERROR] Error upsert orden 7200: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7200) already exists.
2025-08-29 07:01:49,952 [ERROR] Error upsert orden 7215: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7215) already exists.
2025-08-29 07:01:49,953 [ERROR] Error upsert orden 7240: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7240) already exists.
2025-08-29 07:01:49,954 [ERROR] Error upsert orden 7130: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7130) already exists.
2025-08-29 07:01:49,955 [ERROR] Error upsert orden 7149: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7149) already exists.
2025-08-29 07:01:49,956 [ERROR] Error upsert orden 7219: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7219) already exists.
2025-08-29 07:01:49,957 [ERROR] Error upsert orden 7153: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7153) already exists.
2025-08-29 07:01:49,958 [ERROR] Error upsert orden 7172: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7172) already exists.
2025-08-29 07:01:49,959 [ERROR] Error upsert orden 7208: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7208) already exists.
2025-08-29 07:01:49,960 [ERROR] Error upsert orden 7222: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7222) already exists.
2025-08-29 07:01:49,961 [ERROR] Error upsert orden 7161: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7161) already exists.
2025-08-29 07:01:49,962 [ERROR] Error upsert orden 7241: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7241) already exists.
2025-08-29 07:01:49,963 [ERROR] Error upsert orden 6336: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(6336) already exists.
2025-08-29 07:01:49,964 [ERROR] Error upsert orden 7044: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7044) already exists.
2025-08-29 07:01:49,964 [ERROR] Error upsert orden 7157: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7157) already exists.
2025-08-29 07:01:49,966 [ERROR] Error upsert orden 6843: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(6843) already exists.
2025-08-29 07:01:49,966 [ERROR] Error upsert orden 7228: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7228) already exists.
2025-08-29 07:01:49,967 [ERROR] Error upsert orden 7247: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7247) already exists.
2025-08-29 07:01:49,968 [ERROR] Error upsert orden 7108: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7108) already exists.
2025-08-29 07:01:49,969 [ERROR] Error upsert orden 7173: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7173) already exists.
2025-08-29 07:01:49,970 [ERROR] Error upsert orden 7207: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7207) already exists.
2025-08-29 07:01:49,971 [ERROR] Error upsert orden 7139: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7139) already exists.
2025-08-29 07:01:49,972 [ERROR] Error upsert orden 6931: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(6931) already exists.
2025-08-29 07:01:49,973 [ERROR] Error upsert orden 7158: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7158) already exists.
2025-08-29 07:01:49,975 [ERROR] Error upsert orden 7242: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7242) already exists.
2025-08-29 07:01:49,976 [ERROR] Error upsert orden 7199: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7199) already exists.
2025-08-29 07:01:49,977 [ERROR] Error upsert orden 7224: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7224) already exists.
2025-08-29 07:01:49,978 [ERROR] Error upsert orden 7170: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7170) already exists.
2025-08-29 07:01:49,979 [ERROR] Error upsert orden 7190: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7190) already exists.
2025-08-29 07:01:49,980 [ERROR] Error upsert orden 7239: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7239) already exists.
2025-08-29 07:01:49,981 [ERROR] Error upsert orden 7227: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7227) already exists.
2025-08-29 07:01:49,982 [ERROR] Error upsert orden 7229: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7229) already exists.
2025-08-29 07:01:49,983 [ERROR] Error upsert orden 7204: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7204) already exists.
2025-08-29 07:01:49,984 [ERROR] Error upsert orden 6373: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(6373) already exists.
2025-08-29 07:01:49,985 [ERROR] Error upsert orden 7203: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7203) already exists.
2025-08-29 07:01:49,986 [ERROR] Error upsert orden 7106: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7106) already exists.
2025-08-29 07:01:49,987 [ERROR] Error upsert orden 6973: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(6973) already exists.
2025-08-29 07:01:49,988 [ERROR] Error upsert orden 7201: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7201) already exists.
2025-08-29 07:01:49,989 [ERROR] Error upsert orden 7261: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7261) already exists.
2025-08-29 07:01:49,990 [ERROR] Error upsert orden 7159: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7159) already exists.
2025-08-29 07:01:49,992 [ERROR] Error upsert orden 7187: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7187) already exists.
2025-08-29 07:01:49,993 [ERROR] Error upsert orden 7220: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7220) already exists.
2025-08-29 07:01:49,994 [ERROR] Error upsert orden 7225: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7225) already exists.
2025-08-29 07:01:49,995 [ERROR] Error upsert orden 7255: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7255) already exists.
2025-08-29 07:01:49,996 [ERROR] Error upsert orden 7214: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7214) already exists.
2025-08-29 07:01:49,997 [ERROR] Error upsert orden 7151: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7151) already exists.
2025-08-29 07:01:49,998 [ERROR] Error upsert orden 7168: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7168) already exists.
2025-08-29 07:01:49,999 [ERROR] Error upsert orden 7093: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7093) already exists.
2025-08-29 07:01:50,001 [ERROR] Error upsert orden 7209: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7209) already exists.
2025-08-29 07:01:50,002 [ERROR] Error upsert orden 7142: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7142) already exists.
2025-08-29 07:01:50,003 [ERROR] Error upsert orden 7175: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7175) already exists.
2025-08-29 07:01:50,004 [ERROR] Error upsert orden 7194: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7194) already exists.
2025-08-29 07:01:50,005 [ERROR] Error upsert orden 7193: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7193) already exists.
2025-08-29 07:01:50,006 [ERROR] Error upsert orden 7131: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7131) already exists.
2025-08-29 07:01:50,007 [ERROR] Error upsert orden 7180: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7180) already exists.
2025-08-29 07:01:50,008 [ERROR] Error upsert orden 7133: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7133) already exists.
2025-08-29 07:01:50,010 [ERROR] Error upsert orden 7232: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7232) already exists.
2025-08-29 07:01:50,011 [ERROR] Error upsert orden 7135: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7135) already exists.
2025-08-29 07:01:50,012 [ERROR] Error upsert orden 7234: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7234) already exists.
2025-08-29 07:01:50,013 [ERROR] Error upsert orden 7231: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7231) already exists.
2025-08-29 07:01:50,014 [ERROR] Error upsert orden 7134: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7134) already exists.
2025-08-29 07:01:50,015 [ERROR] Error upsert orden 7120: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7120) already exists.
2025-08-29 07:01:50,016 [ERROR] Error upsert orden 7218: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7218) already exists.
2025-08-29 07:01:50,017 [ERROR] Error upsert orden 7141: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7141) already exists.
2025-08-29 07:01:50,018 [ERROR] Error upsert orden 7177: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7177) already exists.
2025-08-29 07:01:50,019 [ERROR] Error upsert orden 7160: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7160) already exists.
2025-08-29 07:01:50,019 [ERROR] Error upsert orden 7112: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7112) already exists.
2025-08-29 07:01:50,020 [ERROR] Error upsert orden 7152: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7152) already exists.
2025-08-29 07:01:50,021 [ERROR] Error upsert orden 7230: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7230) already exists.
2025-08-29 07:01:50,022 [ERROR] Error upsert orden 7086: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7086) already exists.
2025-08-29 07:01:50,022 [ERROR] Error upsert orden 7154: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7154) already exists.
2025-08-29 07:01:50,023 [ERROR] Error upsert orden 7188: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7188) already exists.
2025-08-29 07:01:50,024 [ERROR] Error upsert orden 7164: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7164) already exists.
2025-08-29 07:01:50,024 [ERROR] Error upsert orden 7233: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7233) already exists.
2025-08-29 07:01:50,025 [ERROR] Error upsert orden 7181: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7181) already exists.
2025-08-29 07:01:50,026 [ERROR] Error upsert orden 7123: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7123) already exists.
2025-08-29 07:01:50,027 [ERROR] Error upsert orden 7176: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7176) already exists.
2025-08-29 07:01:50,027 [ERROR] Error upsert orden 7243: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7243) already exists.
2025-08-29 07:01:50,028 [ERROR] Error upsert orden 7191: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7191) already exists.
2025-08-29 07:01:50,029 [ERROR] Error upsert orden 7245: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7245) already exists.
2025-08-29 07:01:50,031 [ERROR] Error upsert orden 7223: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7223) already exists.
2025-08-29 07:01:50,032 [ERROR] Error upsert orden 7107: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7107) already exists.
2025-08-29 07:01:50,033 [ERROR] Error upsert orden 7235: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7235) already exists.
2025-08-29 07:01:50,034 [ERROR] Error upsert orden 7081: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7081) already exists.
2025-08-29 07:01:50,035 [ERROR] Error upsert orden 7253: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7253) already exists.
2025-08-29 07:01:50,036 [ERROR] Error upsert orden 7162: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7162) already exists.
2025-08-29 07:01:50,037 [ERROR] Error upsert orden 7236: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7236) already exists.
2025-08-29 07:01:50,038 [ERROR] Error upsert orden 7256: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7256) already exists.
2025-08-29 07:01:50,039 [ERROR] Error upsert orden 7213: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7213) already exists.
2025-08-29 07:01:50,041 [ERROR] Error upsert orden 7210: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7210) already exists.
2025-08-29 07:01:50,043 [ERROR] Error upsert orden 7155: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7155) already exists.
2025-08-29 07:01:50,044 [ERROR] Error upsert orden 7183: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7183) already exists.
2025-08-29 07:01:50,045 [ERROR] Error upsert orden 7140: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7140) already exists.
2025-08-29 07:01:50,046 [ERROR] Error upsert orden 7186: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7186) already exists.
2025-08-29 07:01:50,047 [ERROR] Error upsert orden 7004: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7004) already exists.
2025-08-29 07:01:50,048 [ERROR] Error upsert orden 6328: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(6328) already exists.
2025-08-29 07:01:50,048 [ERROR] Error upsert orden 7137: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7137) already exists.
2025-08-29 07:01:50,049 [ERROR] Error upsert orden 7195: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7195) already exists.
2025-08-29 07:01:50,050 [ERROR] Error upsert orden 7179: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7179) already exists.
2025-08-29 07:01:50,051 [ERROR] Error upsert orden 7166: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7166) already exists.
2025-08-29 07:01:50,052 [ERROR] Error upsert orden 7185: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7185) already exists.
2025-08-29 07:01:50,053 [ERROR] Error upsert orden 7053: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7053) already exists.
2025-08-29 07:01:50,054 [ERROR] Error upsert orden 7249: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7249) already exists.
2025-08-29 07:01:50,055 [ERROR] Error upsert orden 7055: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7055) already exists.
2025-08-29 07:01:50,056 [ERROR] Error upsert orden 7182: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7182) already exists.
2025-08-29 07:01:50,057 [ERROR] Error upsert orden 7148: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7148) already exists.
2025-08-29 07:01:50,058 [ERROR] Error upsert orden 7205: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7205) already exists.
2025-08-29 07:01:50,058 [ERROR] Error upsert orden 7111: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7111) already exists.
2025-08-29 07:01:50,059 [ERROR] Error upsert orden 7206: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7206) already exists.
2025-08-29 07:01:50,060 [ERROR] Error upsert orden 7143: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7143) already exists.
2025-08-29 07:01:50,061 [ERROR] Error upsert orden 7067: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7067) already exists.
2025-08-29 07:01:50,062 [ERROR] Error upsert orden 7202: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7202) already exists.
2025-08-29 07:01:50,062 [ERROR] Error upsert orden 7244: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7244) already exists.
2025-08-29 07:01:50,063 [ERROR] Error upsert orden 7165: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7165) already exists.
2025-08-29 07:01:50,064 [ERROR] Error upsert orden 7128: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7128) already exists.
2025-08-29 07:01:50,065 [ERROR] Error upsert orden 7145: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7145) already exists.
2025-08-29 07:01:50,066 [ERROR] Error upsert orden 7192: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7192) already exists.
2025-08-29 07:01:50,067 [ERROR] Error upsert orden 7260: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7260) already exists.
2025-08-29 07:01:50,067 [ERROR] Error upsert orden 7196: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7196) already exists.
2025-08-29 07:01:50,068 [ERROR] Error upsert orden 7121: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7121) already exists.
2025-08-29 07:01:50,069 [ERROR] Error upsert orden 7132: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7132) already exists.
2025-08-29 07:01:50,070 [ERROR] Error upsert orden 7217: duplicate key value violates unique constraint "uq_ordenes_numero"
DETAIL: Key (numero)=(7217) already exists.
2025-08-29 07:01:50,070 [INFO] Upsert de 0 órdenes en PostgreSQL
2025-08-29 07:01:50,070 [INFO] Conectando a PostgreSQL via psycopg...
2025-08-29 07:01:50,078 [INFO] Conexión PostgreSQL exitosa
2025-08-29 07:01:50,078 [INFO] [DEBUG] Total pedidos a insertar: 242
2025-08-29 07:01:50,082 [WARNING] [DEBUG] Pedidos con orden_id inexistente: 242
2025-08-29 07:01:50,083 [INFO] [INFO] Filtrados 242 pedidos con orden_id inválido; continuando con 0 válidos
2025-08-29 07:01:50,084 [INFO] Upsert de 0 pedidos en PostgreSQL (batch)
2025-08-29 07:01:50,085 [INFO] Carga completada en 0.19s
2025-08-29 07:01:50,085 [INFO] [SUCCESS] ETL completado sin errores
2025-08-29 07:01:50,085 [INFO] === PROCESO ETL COMPLETADO EXITOSAMENTE ===
2025-08-29 07:01:50,085 [INFO] Resumen: órdenes 0, pedidos 0
Tip: Usa Ctrl+F para buscar texto específico en el log