Virtual Table: Remote Sources not visible after XSA Upgrate to 102

[Ajinkya_Jadhav]

Hi,

We recently upgraded to XSA 102, while creating the virtual table we are getting the following screen.

I think it is new UI for creating the virtual table. But our issue is no remote sources are visible to create virtual table.

Thanks

Best Regards,

Ajinkya

[former_member684310]

Hi,

I am having the exactly the same issue. Please let me know in case if you find the solution.

Thanks,

Sameer

[Ajinkya_Jadhav]

Hi Sameer,

No, yet we are not able to solve the issue but we have a workaround.

Instead of creating virtual table directly by right clicking and selecting virtual table You can select file and in the name of the file you can use extension as .hdbvirtual table. It will open virtual table editor, similar to what you had in previous version.

[Ajinkya_Jadhav · Accepted solution]

Add remote sources to the schema _RT user to make the remote sources visible

[HakanHaslaman]

Please verify, if it's possible to create virtual functions and procedures via the SQL Console. If yes, please open a support incident and report this issue, because it could be in investigation of the Development and support can verify this.