List:MaxDB« Previous MessageNext Message »
From:Alexander Garcia Martinez Date:October 2 2007 1:07pm
Subject:catalog error
View as plain text  
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

 


Thread
catalog errorAlexander Garcia Martinez2 Oct