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