Query Rowitems Time-Out

Joeri Vlemmings

Hi,

When printing in batch trough the SBO DocumentPrinting wizard, I get the following errormessage:

Query : RowItems has an error.Time-out has exceeded. De time-outperiod has exceeded before transaction was completed or server doesn't respond. 
/* Save all foreign translations for a given DocNum and LangCode */ 
SELECT T1.PK AS ItemCode,CAST(T0.Trans AS NVARCHAR(4000)) AS MLDesc INTO #SWA_LD_ITEMTEXTTRANS 
FROM MLT1 T0 INNER JOIN OMLT T1 ON T0.TranEntry = T1.TranEntry 
INNER JOIN INV1 T2 ON T1.PK = T2.ItemCode 
WHERE T1.TableName='OITM' AND T1.FieldAlias = 'UserText' AND T0.LangCode='16' AND T2.DocEntry=18001 
GROUP BY T1.PK,CAST(T0.Trans AS NVARCHAR(4000)) 
/* now get the items and the MLDesc if it exist */ 
SELECT T0.LineNum,T2.*, CASE WHEN T1.MLDesc IS NOT NULL THEN T1.MLDesc ELSE T2.UserText END AS DescML 
FROM INV1 T0 LEFT OUTER JOIN #SWA_LD_ITEMTEXTTRANS T1 ON T0.ItemCode = T1.ItemCode 
INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode 
WHERE T0.DocEntry = 18001 ORDER BY T0.VisOrder

Can you help me with this?

Thanks,

Joeri

Philipp Knecht

Hi Joeri

Just add a dummy query like:

/* @@TIMEOUT=[1000] */
SELECT 1

to the Layoutdefinition.

hth