“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.

Environment:

Tool: SAP Information Design Tool 4.2 SP03

Database: SQL Server 2012

Connection Establishment through ODBC is successfull.

idt.png (5.0 kB)

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. Environment: Tool: SAP Information Design Tool 4.2 SP03 Database: SQL Server 2012 Connection Establishment through ODBC is successfull. idt.png (5.0 kB)

"Show Values Error Index:0" in IDT

Very Helpfull

User Rating: Be the first one !
Vice Professor Asked on May 26, 2017 in SAP PORTAL.
Add Comment
1 Answer(s)

    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.

    Thanks, Mahboob Mohammed

    Add Comment

    Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.