The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Views not returning all results


Tyger Guzman 2

Recommended Posts

After an upgrade of Tibco DV from 7.1.0 to 8.2.0 all of our Views are not returning the full results.

Doing a Select * from /folder/database/table doesn't return all results but when querying directly to the Teradata data source all results are shown. This is occuring for views that have count() , sum() or other functions along with just Select * from table where [column] = 'A'.

 

Is there a setting or somehthing that could have changed between versions

Link to comment
Share on other sites

Based on your post, you're running the queries in SQL Scratchpad If so, not returning all results is by design.

There is a button in studio (looks like a table with a green arrow) that will "Fetch More Results" , up to an administrative limit (Studio/Data section of the configuration menu - there are two settings).

If that's not the case, we'll likely need more information in order to help.

Link to comment
Share on other sites

In the example I posted I am testing in both the SQL scratch pad and pulling the data into spotfire. In both instaces the not all the results are returned even when trying to fetch more results (I am aware of the displayed records being limited in the environment the first 50 records are displayed and limited at viewing 1000). 

 

 A query that should return 65 rows only returns 8 while running the queries in both Teradata and TDV and having a view published in TDV being connected in Spotfire. 

 

 

 

--Returns only 8 in TDV/Spotfire but 65 in Teradata 
Select substr([column1],1,2) Col 
from /DB/Table 
where [column2] in ('A','B')
group by substr([column1],1,2);


--Returns only 8 in TDV/Spotfire but 65 in Teradata 
Select left([column1],2) Col 
from /DB/Table 
where [column2] in ('A','B')
group by left([column1],2);


--Returns no rows in TDV/Spotfire but thousands in Teradata
Select *
from /DB/Table 
where substr([column1],1,2) in ('ZA','ZB')

 

 

 

 

 

The above queries are put into Views in TDV and also tested in the SQL sractch pad. The views are pulled into spotfire and return the same results (IE: 8 rows instead of 65). There is no caching set for any of the introspected tables or created views.  The same queries do produce the correct results if they are changed to packaged queries from views but we have quite a bit that was set up already when it was previous working. 

Link to comment
Share on other sites

Turns out the issue was a setting that was changed during the upgrade.

Case Sensitivity & Ignore Trailing Spaces were set differently from before and caused these issues. After re-setting the problem ceased. To better safe guard from this issue select options were added to our Views.

{OPTION CASE_SENSITIVE="FALSE" , IGNORE_TRAILING_SPACES="TRUE"}

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...