From: Alexander Garcia Martinez (algarciacellstar.com.co)
Date: Tue Oct 02 2007 - 08:07:10 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]