SAP Knowledge Base Article - Preview

3375102 - Failed to create a virtual table after upgrading DPAgent.

Symptom

  • After upgrading DPAgent from 2.5.2.0 to 2.7.1.1, the following error occurred when trying to create a virtual table via mssqllogreader adapter against the remote MSSQL server.
    • 2023-09-05 10:13:07,151 [INFO ] [66289a80-6ba8-4d01-8a4b-c2173359564924155] DPFramework | WorkerThread.processAdapterOpen [] - Open request for RS_SDI_TQL
      2023-09-05 10:13:07,825 [ERROR] [66289a80-6ba8-4d01-8a4b-c2173359564924155] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: The database name component of the object qualifier must be the name of the current database. Context: com.microsoft.sqlserver.jdbc.SQLServerException: The database name component of the object qualifier must be the name of the current database.
                                      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(..............
                                      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(................
  • After switching back to the original Agent Version (2.5.2.0), it's working again to create virtual tables again.


Read more...

Environment

  • SDI(Smart Data Integration)
  • DPAgent 2.7.1.1
  • MSSQL Server

Keywords

  • The database name component of the object qualifier must be the name of the current database, database name, MSSQL, virtual table, virtual
, KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.