SAP Knowledge Base Article - Preview

3463779 - Not able to get table from source DB because of division by zero error

Symptom

  • Error in the tool:
    • Connection test and/or dictionary update fails with the error SAP DBTech JDBC 403: Internal error: Cannot get remote source objects: Could not get tables.
  • Error in the framework.trc file:
    • 2024-04-02 16:13:43,629 [DEBUG] [4c5a1102-44ce-4521-b0eb-1c56a8c839be97094] ReconnectableConnection | ReconnectableConnection.getJdbcConnection [] - Test the connection validity. Validation query: SELECT 1 FROM DUMMY
      2024-04-02 16:13:43,644 [ERROR] [4c5a1102-44ce-4521-b0eb-1c56a8c839be97094] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: / by zero Context: java.lang.ArithmeticException: / by zero
                                      at com.sap.hana.dp.hanaadapter.SDAAdapterDelegate.browseMetadata(SDAAdapterDelegate.java:314)
                                      at com.sap.hana.dp.hanaadapter.SDAAdapterDelegate.browseMetadata(SDAAdapterDelegate.java:279)
                                      at com.sap.hana.dp.cdcadaptercommons.BaseAdapterCDC.browseMetadata(BaseAdapterCDC.java:733)
                                      at com.sap.hana.dp.hanaadapter.HanaAdapterDelegate.browseMetadata(HanaAdapterDelegate.java:222)
                                      at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDCProxy.browseMetadata(StatefulAdapterCDCProxy.java:204)
                                      at com.sap.hana.dp.adapter.sdk.decorator.AdapterCDCDelegate.browseMetadata(AdapterCDCDelegate.java:78)
                                      at com.sap.hana.dp.adapter.framework.core.WorkerThread.processBrowse(WorkerThread.java:1819)
                                      at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:281)
                                      at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2143)
                                      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:838)
                                      / by zero
                                      at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:435)
                                      at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2143)
                                      at java.util.concurrent.ThreadPoolExe...


Read more...

Environment

SAP HANA smart data integration

Product

SAP HANA smart data integration all versions

Keywords

division by zero, dictionary, refresh, test , 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.