Hi
I have a big problem -9205 AK Catalog information not found This message appear in database diagnosis files, and this error is present whith a particular sentence SELECT REFE.REFE_ID, REFE.REFE_CODIGO, REFE.REFE_DESCRIPCION, ( SELECT SUM(DARP.DAPE_CANTIDADREFERENCIA) FROM ARMAPEDIDO ARPE, DETALLEARMAPEDIDO DARP, REFERENCIAS REFEINT WHERE ARPE.CRTE_ID = 5284 AND ARPE.ARPE_ID = DARP.ARPE_ID AND DARP.REFE_ID = REFEINT.REFE_ID AND REFEINT.REFE_ID = REFE.REFE_ID GROUP BY REFEINT.REFE_ID, REFEINT.REFE_CODIGO, REFEINT.REFE_DESCRIPCION ) AS CANTIDAD_PROCESAR, ( SELECT COUNT(*) FROM SERIALPACKING SEPA, PRODUCTOSERIALIZADO PRSE WHERE SEPA.SEPA_SERIAL = PRSE.PRSE_ID AND SEPA.SEPA_CORTE = 5284 AND PRSE.REFE_ID = REFE.REFE_ID ) AS CANTIDAD_PROCESADA FROM ARMAPEDIDO ARPE, DETALLEARMAPEDIDO DARP, REFERENCIAS REFE WHERE ARPE.CRTE_ID = 5284 AND ARPE.ARPE_ID = DARP.ARPE_ID AND DARP.REFE_ID = REFE.REFE_ID GROUP BY REFE.REFE_ID, REFE.REFE_CODIGO, REFE.REFE_DESCRIPCION ORDER BY REFE.REFE_DESCRIPCION The sentence wait for ever and never end Anybody know what do ¿? thanks ALEXANDER GARCIA MARTINEZ Ingeniero Desarrollo - Bases de Datos Cellstar de Colombia Tel: 426 87 00 ext 231 Cel: 315 8529297 - 311 223 83 94
