Skip to Content
Author's profile photo Ashokkumar N

SDA – Remote objects limit (1000) reached

Hi All,

Here I am going to explain, how to create a virtual table using SDA(Smart Data Access) in HANA studio.

Once the Remote system is configured under SDA, Under ‘Remote sources’ we can see the list of tables from the source system(PFB screen shot). When you open any schema, only 1000 tables will be displayed and at the end, you get an message ‘Remote objects limit (1000) reached’  and we don’t have any filter option here to select a particular table.

So now, there are three ways to create a virtual table(If we can’t see the required table in that list displayed).

1) Increasing the limit of ‘Maximum number of Remote objects to be displayed’
2) Create Virtual table directly in the schema(Under Catalog)
3) Use SQL to create the virtual table.

I will be explaining step 1 and 2 here.

1) Increasing the limit of ‘Maximum number of Remote objects to be displayed’

Follow the below mentioned path in HANA studio.

System Monitor–>Configuration–>indexserver.ini–> smart_data_access–> remote_objects_tree_max_size

If this parameter is not available, Right click on the smart_data_access–>Add Parameter

Once the above configuration is maintained, all the tables will be displayed. Then it is possible to create Virtual table by right clicking on any table.

2) Create Virtual table directly in the schema(Under Catalog)

We can directly create Virtual table using this option. Filter option also available here 🙂

a) Under Catalog open any schema where you want to create the virtual table
b) Right click on the Tables and select ‘New Virtual Table’

c) Give a name for the Virtual table and click ‘Browse’
d) Give the table name you want to see, in the filter and open the schema(Note:Do not open the schema with out giving filter)

e)Select the required table, click OK, Execute/Save

A new virtual table is created under the selected schema.

Thank you.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks Ashok. It worked for me. Useful Blog.

      Author's profile photo Pierrick HORPIN
      Pierrick HORPIN

      Great !

      That's exactly what I was looking for !

      Author's profile photo Leoncio Cividanes Álvarez
      Leoncio Cividanes Álvarez

      Finally found what I’ve been looking for.

      Just enable “Fetch all database catalog objects” in Preferences > SAP HANA > Runtime > Catalog and you’ll get all your objects

      Author's profile photo Francisco Gaitan
      Francisco Gaitan

      Thanks Ashok. It worked for me too.