Astro-WISE DB-View Web Service

Home Contact Help user awanonymous project MICADO@E-ELT Tables Preferences

DBview-Error

An exception occured: ORA-02395: exceeded call limit on IO usage

With query:

WITH Q_2_1 AS (
 SELECT object_id AS "astrom.object_id",CRVAL2 AS "astrom.CRVAL2",CRVAL1 AS "astrom.CRVAL1" FROM AWOPER."REDUCEDSCIENCEFRAME$ASTROM" 
),Q_2_2 AS (
 SELECT "object_id" AS "chip.object_id","name" AS "chip.name" FROM AWOPER."Chip+" 
),Q_2_3 AS (
 SELECT "object_id" AS "filter.object_id","name" AS "filter.name" FROM AWOPER."Filter+" 
),Q_2_4 AS (
 SELECT "object_id" AS "instrument.object_id","name" AS "instrument.name" FROM AWOPER."Instrument+" 
),Q_1_1 AS (
 SELECT Q."object_id",'quality view' AS "quality view",Q."+PRIVILEGES",Q."+PROJECT" AS "project_id",'re-process' AS "re-process",Q_2_1."astrom.CRVAL1",Q_2_1."astrom.CRVAL2",Q_2_4."instrument.name",Q_2_2."chip.name",Q_2_3."filter.name",Q."AIRMEND",Q."AIRMSTRT",Q."creation_date",Q."DATE#",Q."DATE_OBS",Q."EXPTIME",Q."filename",Q."is_valid",Q."NAXIS1",Q."NAXIS2",Q."OBJECT#",Q."psf_radius",Q."quality_flags",Q."scale_factor",Q."OBJECT_ID$" FROM AWOPER."ReducedScienceFrame+" Q
 JOIN Q_2_4 ON Q."instrument@" = Q_2_4."instrument.object_id"
 JOIN Q_2_3 ON Q."filter@" = Q_2_3."filter.object_id"
LEFT JOIN Q_2_2 ON Q."chip@" = Q_2_2."chip.object_id"
LEFT JOIN Q_2_1 ON "object_id" = Q_2_1."astrom.object_id" WHERE Q."AIRMEND" = :1 AND Q."is_valid" > :4 AND Q_2_3."filter.name" = :2 AND Q_2_4."instrument.name" = :3
ORDER BY Q."DATE_OBS" DESC)
SELECT ROWNUM, Q_1_1.* FROM Q_1_1
WHERE ROWNUM <= 500

empowered by