topic SAP HANA Invalid column name in Talend Studio

SAP HANA Invalid column name

karandama2006 — Tue, 12 Mar 2019 09:03:24 GMT

There is an issue , I'm not sure with Talend or SAP

When there is a column mentioned in Camel case in SAP HANA , eg: Wave

and we try to insert data into that column from Talend , we get invalid column name error

[FATAL]: apd_bi_pulse.j00_pulse_transfer_sql_hana_0_1.j00_pulse_transfer_sql_hana - tDBOutput_1 SAP DBTech JDBC: [260]: invalid column name: WAVE
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [260]: invalid column name: WAVE

Any leads on how to tackle this ?

Column names are usually case insensitive but they are not in SAP HANA

This is what I found :
Names are not case sensitive . For example, CUSTOMER and Customer are the same, but object names are converted to uppercase when they are stored in the SAP HANA database. However, if you enclose a name in quotation marks, it is case sensitive .

Re: SAP HANA Invalid column name

Anonymous — Mon, 18 Mar 2019 08:58:42 GMT

Hello,

The connection is established successfully from talend to SAP HANA? The table name and schema name which your are trying to query do exist in SAP HANA?

Are you able to fire direct query from tSAPHANARow component to query your column?

Best regards

Sabrina

Re: SAP HANA Invalid column name

karandama2006 — Mon, 18 Mar 2019 10:11:22 GMT

Hi Sabrina ,

The answer is YES to all your questions .
For now , I've asked the owner of HANA database to capitalize all their columns after that everything worked fine.

But this seems like a Bug in Talend.

Thanks ,

Karan

Re: SAP HANA Invalid column name

Anonymous — Thu, 21 Mar 2019 09:05:18 GMT

Hello,

For this case sensitive issue, could you please clarify in which Talend version/edition you are?

Best regards

Sabrina

Re: SAP HANA Invalid column name

karandama2006 — Thu, 21 Mar 2019 09:08:39 GMT

I'm on Talend 7.1.1 the latest version

Re: SAP HANA Invalid column name

Anonymous — Thu, 21 Mar 2019 09:35:34 GMT

Hello,

SAP HANA supports case sensitive columns for a table. While querying such tables it is necessary to have quotes around the fields name else it throws "Invalid column name" error.

With our SAP HANA Input component, you can manully modify the query and add quotes the field name. Does this issue only repro on SAP HANA output?

Best regards

Sabrina

Re: SAP HANA Invalid column name

karandama2006 — Thu, 21 Mar 2019 10:38:26 GMT

Hi Sabrina,
Thats right, In input components we can do manual modification, but the issue occurs in output component while trying to insert data.. I haven't tried adding quotes in the output schema but just changing the case does not work.
Regards,
Karan Dama

Re: SAP HANA Invalid column name

Anonymous — Fri, 22 Mar 2019 01:54:00 GMT

Hello @karandama2006

Thanks for your information. Indeed, we could add a feature to handle the case sensitive columns in SAP HANA table. I will report this issue/new feature to our PMs to see if there is any workaround for that. We will keep you posted.

Best regards

Sabrina

Re: SAP HANA Invalid column name

karandama2006 — Wed, 10 Apr 2019 08:16:04 GMT

Hi ,

I came across this type of table again which has case sensitive columns , I found a workaround to insert data through output component .
In edit schema - > dbcolumn
We need to surround the concerned column which is in Camel-case with quotes and escape sequence
So if the column name is Text , change it to \"Text\" in the output component schema in the "dbcolumn" column and it works.

It would be better if Talend does this automatically for us , may be in future release but for now this solution works.

Regards,

Karan Dama

Re: SAP HANA Invalid column name

Anonymous — Wed, 10 Apr 2019 09:01:48 GMT

Hello @karandama2006

Thanks for you feedback and sharing your solution with us on community.

Feel free to create a workitem jira issue on talend bug tracker.

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina