OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Selects in union run only one time

From: Matteo Gattoni (matteo.gattoniicteam.it)
Date: Mon Jul 05 2004 - 09:21:01 CDT

Hi!
I have problem with a query that contains 11 select in union.
The first time that I run it, all works well.
The second time it fails with error

General error;-602 POS(1) System error: AK Catalog information not found:FF0000220146002000B200.

The query is a little complicated with about 5 joins for each select in it.

It seems to have problem with cache, isn't it?
Is there some parameter settings tha could resolve my problem?
Or it's due to other matters?

Thanks.
Bye,
Matteo Gattoni