Tyger Guzman 2 Posted December 19, 2019 Share Posted December 19, 2019 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 More sharing options...
Motsu Aboshi Posted December 19, 2019 Share Posted December 19, 2019 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 More sharing options...
Tyger Guzman 2 Posted December 20, 2019 Author Share Posted December 20, 2019 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 More sharing options...
Tyger Guzman 2 Posted December 20, 2019 Author Share Posted December 20, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now