Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Erratic results via Business Objects
 
From:   Lee Vickers

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016