Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error while importing data from local csv file using HANA Studio

Hi Experts,

While trying to import data to an existing table in HANA from a local CSV file using HANA Studio, I am getting following error message. I have made sure there's nothing wrong with data (or data types) in the file that I am trying to import. In fact, I tried to import data to multiple tables and ended up with same error message. I am running SAP HANA SP5 Revision 48 and HANa Studio 32bit Version:1.0.48 Build id: 201301130825 (372847)

Message :

Batch from Record 2 to 4622 Failed: SAP DBTech JDBC: Cannot convert Java type java.io.InputStream to SQL type CHAR.: SAP DBTech JDBC: Cannot convert Java type java.io.InputStream to SQL type CHAR.

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot convert Java type java.io.InputStream to SQL type CHAR.

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:363)

at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateSQLException(SQLExceptionSapDB.java:146)

at com.sap.db.jdbc.translators.DBTechTranslator.newSetException(DBTechTranslator.java:1044)

at com.sap.db.jdbc.translators.StringTranslator.transBinaryStreamForInput(StringTranslator.java:333)

at com.sap.db.jdbc.CallableStatementSapDB.setBlob(CallableStatementSapDB.java:2954)

at com.sap.db.jdbc.trace.PreparedStatement.setBlob(PreparedStatement.java:269)

at com.sap.ndb.studio.bi.filedataupload.deploy.populate.PopulateSQLTable.populateTable(PopulateSQLTable.java:89)

at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.uploadFlatFile(FileUploaderJob.java:197)

at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.run(FileUploaderJob.java:60)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Please help me resolve this issue

Thanks,

Hardik

Former Member
Not what you were looking for? View more on this topic or Ask a question