SAP Knowledge Base Article - Preview

3552963 - Error: "Exception: Failed to create route route32" while testing connection for remote source created through CamelJdbcAdapter- SAP HANA Smart Data Integration

Symptom

  • Create remote source through CamelJdbcAdapter and test connection failed with error
  • Error in framework.trc file.
    DPFramework | WorkerThread.processAdapterOpen [] - Open request failed, terminating session[***]. Exception: Failed to create route route32 at: >>> Choice[[When[simple{${header.DpCommand} == 'browse' or ${header.DpCommand} == 'import'} -> [SetHeader[DpMetadataBrowser, simple{jdbc}], To[dpmetadata:dataSource]]], When[simple{${header.DpCommand} == 'query' or ${header.DpCommand} == 'update'} -> [Choice[[When[simple{${header.DpCommand} == 'query'} -> [To[jdbc:dataSource?useHeadersAsParameters=true&resetAutoCommit=false&outputType=StreamList], SetHeader[DpResultType, simple{map}]]], When[simple{${header.DpCommand} == 'update'} -> [To[jdbc:dataSource?useHeadersAsParameters=true&resetAutoCommit=true], SetHeader[DpUpdateCount, simple{${in.header.CamelJdbcUpdateCount}}]]]]], To[dpresult:dpresult]]]] Otherwise[[Stop]]] <<< in route: Route(route32)[From[direct:sda] -> [Choice[[When[simple{${he... because ...
    DPFramework | AdapterManager.terminateSessionSync [] - Failed to close adapter instance in terminateSessionSync session [***] java.lang.NullPointerException: while trying to invoke the method com.sap.hana.dp.cameladapter.SDAAdapterDelegate.close() of a null object loaded from field com.sap.hana.dp.cameladapter.CamelAdapter.sdaAdapter of an object loaded from local variable 'this'
                                    at com.sap.hana.dp.cameladapter.CamelAdapter.close(CamelAdapter.java:84)
                                    at com.sap.hana.dp.cameladapter.AdapterWithBundleClassLoader.close(AdapterWithBundleClassLoader.java:99)
                                    at com.sap.hana.dp.adapter.framework.core.AdapterManager.terminateSessionSync(AdapterManager.java:500)
                                    at com.sap.hana.dp.adapter.framework.core.WorkerThread.processAdapterOpen(WorkerThread.java:1916)


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

DP Agent, DPA, SDI, camelJDBCAdapter, route , 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.