Symptom
- Select from Virtual table created from CamelJDBCAdapter connecting to MYSQL
- Error: "SAP DBTech JDBC: [403]: internal error: Remote execution error Camel execution failed "
- Error in framework.trc file
"CamelLogger.log - Failed delivery for (MessageId: *** on ExchangeId: ***). Exhausted after delivery attempt: 1 caught: java.lang.NumberFormatException: For input string: "***""
java.lang.NumberFormatException: For input string: "***"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:583)
at java.lang.Integer.parseInt(Integer.java:615)
at com.sap.hana.dp.adapter.sdk.AdapterRowElement.setValue(AdapterRowElement.java:1171)
at com.sap.hana.dp.adapter.sdk.AdapterRow.setColumnValue(AdapterRow.java:596)
at com.sap.hana.dp.camel.ResultProducer$AbstractExtractor.setColumnValue(ResultProducer.java:135)
at com.sap.hana.dp.camel.ResultProducer$MapExtractor.extract(ResultProducer.java:319)
at com.sap.hana.dp.camel.ResultProducer.extractRowSet(ResultProducer.java:96)
at com.sap.hana.dp.camel.ResultProducer.process(ResultProducer.java:53)
Read more...
Environment
SAP HANA Smart Data Integration
MYSQL
Product
SAP HANA smart data integration 2.0
Keywords
format, sdi, mysql, convert, int, unsigned , 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.