“Show Values Error Index:0” in IDT
When I Right Click on a table to see table values in Information Design Tool, it shows error message “Show Values Error Index:0”.
For few tables I am able to see values in data foundation layer, few tables show above mentioned error.
Tool: SAP Information Design Tool 4.2 SP03
Database: SQL Server 2012
Connection Establishment through ODBC is successfull.
For the tables which you get this error, would you please see how many rows are their in those? If there are millions of rows, can you find out if there is Indexing done on them at the database level?
Apart from that, if you’ve SQL Server Client tools install, can you run a simple select against those tables to get top 1000 rows, as Select top 1000 * from Tablename, please google for the correct syntax.
Thanks, Mahboob Mohammed