MM No data block

twanrks

New Member
Server NT . client Windows2000 -- Bussines Objects

The query generates the folowing statement :

SELECT
PUB.stat_cl."stat-year",
sum(PUB.stat_cl.qty),
sum(PUB.stat_cl.Fvkpr),
sum(PUB.stat_cl.Fikpr),
sum(PUB.stat_cl.discount),
sum((PUB.stat_cl.Fvkpr - PUB.stat_cl.discount) / (1 + PUB.stat_cl."tax-rate" / 100)),
sum((PUB.stat_cl.Fvkpr - PUB.stat_cl.discount) / (1 + PUB.stat_cl."tax-rate" / 100) - PUB.stat_cl.Fikpr),
PUB.stat_cl."type",
PUB.z_store.store,
PUB.cl_systeem.omschr,
PUB.cl_type.torisch,
PUB.cl_type.meervoudig,
PUB.z_store.rayon,
PUB.z_store.soort,
PUB.z_store.xl,
PUB.z_store.compatible,
PUB.dim_tijd_week.periode,
PUB.cl_type.omschr,
PUB.stat_cl."cl-gelcode",
PUB.cl_mat.basis,
PUB.stat_cl.Mat
FROM
PUB.stat_cl,
PUB.filgrp_det,
PUB.cl_prijs,
PUB.filgrp,
PUB.z_store,
PUB.cl_type,
PUB.cl_systeem,
PUB.cl_mat,
PUB.dim_tijd_week
WHERE
( PUB.filgrp.groepnaam=PUB.filgrp_det.groepnaam )
AND ( PUB.z_store.store=PUB.filgrp_det.store )
AND ( PUB.z_store.store=PUB.stat_cl.store )
AND ( PUB.stat_cl."Type"=PUB.cl_type."type" )
AND ( PUB.stat_cl.Mat=PUB.cl_mat.mat )
AND ( PUB.cl_prijs.systeem_id=PUB.cl_systeem.systeem_id )
AND ( PUB.stat_cl.mat =PUB.cl_prijs.mat and
PUB.stat_cl."Type" =PUB.cl_prijs."type" and
PUB.stat_cl."cl-gelcode" =PUB.cl_prijs.systeem_id and PUB.cl_prijs.land_kode=10 and
cl_prijs.cl_prijsgrp_id=0 )
AND ( PUB.dim_tijd_week.jaar=PUB.stat_cl."stat-year" and PUB.dim_tijd_week.week=PUB.stat_cl."stat-prd" )
AND (
(PUB.stat_cl."stat-year" = year(sysdate - 365)
OR PUB.stat_cl."stat-year" = year(sysdate))
AND PUB.dim_tijd_week.periode IN (1, 2, 3)
AND PUB.filgrp.groepnaam = 'ned00'
)
GROUP BY
PUB.stat_cl."stat-year",
PUB.stat_cl."type",
PUB.z_store.store,
PUB.cl_systeem.omschr,
PUB.cl_type.torisch,
PUB.cl_type.meervoudig,
PUB.z_store.rayon,
PUB.z_store.soort,
PUB.z_store.xl,
PUB.z_store.compatible,
PUB.dim_tijd_week.periode,
PUB.cl_type.omschr,
PUB.stat_cl."cl-gelcode",
PUB.cl_mat.basis,
PUB.stat_cl.Mat

PUB.stat_cl is the large table, the others are realy small.
After a while the next error appears in a box:

[MERANT][ODBC PROGRESS driver][PROGRESS]Unable to allocate disk block for temp table use [MM - No data block] (7631)-16001

The temp file on the server is 325 Mb

What can i do about it ?

Twan Rekkers
 
Top