Skip to Content

"Show Values Error Index:0" in IDT

Dec 09, 2016 at 08:38 AM


avatar image
Former Member

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.

idt.png (5.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mahboob Mohammed Dec 09, 2016 at 07:24 PM

Hi Shaishav,

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.

Mahboob Mohammed

10 |10000 characters needed characters left characters exceeded