Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2002 @ 16:11:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We have a Business Objects report that contains a number of Universe queries, a number of Free-Hand SQL queries, and a Text File query. All these queries (except the Text File) run over Teradata.

Most of the time, this report can be refreshed with no problems. However, occasionally, one of the Free-Hand SQL queries (always the same one) will give unexpected results. When working correctly, this query will return ~6k rows; but when it goes awry it returns ~60k rows, the majority of which contain NULLs and Zeros.

This seems to be random in it's occurence. The query may go 'wrong' one minute, and be correct the next (with the same input parameters)

Has anyone ever seen this before?

Cheers,

Lee

	<Prev	Next>		<<First	<Prev	Next>	Last>>