SAP Knowledge Base Article - Preview

3780506 - Error: "Failed to query schemas. java.sql.SQLException: Authentication failed: Unauthorized" while connecting to trino through CamelJDBCAdapter

Symptom

  • Create remote source through CamelJDBCAdapter to trino using kerberos and keytab
  • Remote source connection failed with error, detail in framework.trc file
    JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas.java.sql.SQLException: Authentication failed: Unauthorized
                                    at io.trino.jdbc.TrinoStatement.internalExecute(TrinoStatement.java:284)
                                    at io.trino.jdbc.TrinoStatement.execute(TrinoStatement.java:238)
                                    at io.trino.jdbc.TrinoStatement.executeQuery(TrinoStatement.java:77)
                                    at io.trino.jdbc.TrinoDatabaseMetaData.select(TrinoDatabaseMetaData.java:1519)
                                    at io.trino.jdbc.TrinoDatabaseMetaData.getSchemas(TrinoDatabaseMetaData.java:1402)
                                    at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getSchemas(DelegatingDatabaseMetaData.java:1149)
                                    at com.sap.hana.dp.camel.JdbcMetadataBrowser.browseSchemas(JdbcMetadataBrowser.java:99)
                                    at com.sap.hana.dp.camel.JdbcMetadataBrowser.browseMetadata(JdbcMetadataBrowser.java:85)
                                    at com.sap.hana.dp.camel.MetadataProducer.process(MetadataProducer.java:53)


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

SDI, CamelJDBCAdapter,kerberos,keytab , 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.