Error "could not parse object name:" while creating virtual object from remote source.

[former_member669560]

Hello All,

I have created a Remote Sources in the Database Explorer when using Smart Data Integration (SDI) in HANA as a Service (Haas).

From Remote Source, I can see the excel files from the "share" folder then I selected the sheet1 from that excel and tried to create a virtual object in SYSTEM schema but it raises an exception "could not parse object name: Test.xlsx/sheet1". appreciate it if you can help me in this regard. Attached error screenshot for reference.

error-create-virtual-object.png

[jim_havlicek]

Hi,

this is a recently discovered issue in the UI for Hana as a Service.

The workaround is to create the virtual table via SQL using this syntax :

CREATE VIRTUAL TABLE <SCHEMA NAME>.<VIRTUAL TABLE NAME> AT <REMOTE SOURCE NAME>."<NULL>"."<NULL>".<Excel File Name/Sheet Name>;

Here's a link to an SAP Note that gives more detail, and some references for the workaround.

2918279 - Unable to create virtual table using ExcelAdapter or FileAdapterDatastore on Hana Cloud : ...

Let me know if that doesn't work for you.

thanks,

Jim