From: Date: October 2 2007 3:07pm Subject: catalog error List-Archive: http://lists.mysql.com/maxdb/28828 Message-Id: <000001c804f5$24c10fb0$a9002c0a@ccl01des20071> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C804CB.3BF12230" ------=_NextPart_000_0001_01C804CB.3BF12230 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=20 =20 I have a big problem =20 -9205 AK Catalog information not found =20 This message appear in database diagnosis files, and this error is = present whith a particular sentence=20 =20 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 =3D 5284 AND ARPE.ARPE_ID =3D DARP.ARPE_ID AND DARP.REFE_ID =3D REFEINT.REFE_ID AND REFEINT.REFE_ID =3D 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 =3D PRSE.PRSE_ID AND SEPA.SEPA_CORTE =3D 5284 AND PRSE.REFE_ID =3D REFE.REFE_ID ) AS CANTIDAD_PROCESADA FROM ARMAPEDIDO ARPE, DETALLEARMAPEDIDO DARP, REFERENCIAS REFE WHERE ARPE.CRTE_ID =3D 5284 AND ARPE.ARPE_ID =3D DARP.ARPE_ID AND DARP.REFE_ID =3D REFE.REFE_ID GROUP BY REFE.REFE_ID, REFE.REFE_CODIGO, REFE.REFE_DESCRIPCION ORDER BY REFE.REFE_DESCRIPCION =20 The sentence wait for ever and never end =20 Anybody know what do =BF? =20 thanks =20 ALEXANDER GARCIA MARTINEZ Ingeniero Desarrollo - Bases de Datos Cellstar de Colombia Tel: 426 87 00 ext 231 Cel: 315 8529297 - 311 223 83 94 =20 ------=_NextPart_000_0001_01C804CB.3BF12230--