Skip to Content
0
Former Member
Jul 02, 2020 at 04:32 PM

Error when creating virtual object of remote source object in HANA

658 Views Last edit Jul 02, 2020 at 04:35 PM 3 rev

Hi,

I'm trying to create a virtual object in HANA from a remote source PostgreSQL object but somehow this doesn't work.

I can see the objects in Catalog->Remote Sources, but when I select one and try to create a virtual object of it, then HANA throws an exception:

An execution error occurred: invalid remote object name: Table '"pgsql_schema"."employee"'does not exist.: line 0 col 0 (at pos 0)

The DP agent reports pretty much the same:

2020-07-02 18:34:26,022 [ERROR] DPFramework | WorkerThread.processRequest - com.sap.hana.dp.adapter.sdk.AdapterException: Table '"pgsql_schema"."employee"'does not exist. Context: com.sap.hana.dp.adapter.sdk.AdapterException: Table '"pgsql_schema"."employee"'does not exist.
at com.sap.hana.dp.postgresqllogreaderadapter.metadata.impl.MetaDataQuerier.getMetadata(MetaDataQuerier.java:59)
at com.sap.hana.dp.postgresqllogreaderadapter.SmartDataAccessSession.importMetadata(SmartDataAccessSession.java:251)
at com.sap.hana.dp.postgresqllogreaderadapter.PostgreSQLLogReaderAdapter.importMetadata(PostgreSQLLogReaderAdapter.java:192)
at com.sap.hana.dp.adapter.sdk.decorator.AdapterCDCDelegate.importMetadata(AdapterCDCDelegate.java:133)
at com.sap.hana.dp.adapter.framework.core.WorkerThread.processImportMetadata(WorkerThread.java:1720)
at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:259)
at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2042)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:836)

Any idea why HANA tells me that the object doesn't exist, even though I'm 100% sure it's there?

Regards,

Niels