SAP HANA SDI - HanaTransform object error

[Former Member]

Hi together,

I am facing an error message while using SAP HANA SDI (I try to get some Address Cleansing and Geocode generation done).

My scenario is a simple hdbflowgraph, with a table with some addresses as data source, a Geocode Object (as Data Provisioning) and a data sink for the output (I tried to do this with a template table and with a fixed table).

Anyway, the validation of the flowgraphs shows no error, but when I execute the Task, I get the following Message in the SQL Console:

Could not execute 'START TASK "********"."*******.SDI::GEOCORD"' in 6.030 seconds .

SAP DBTech JDBC: [2048]: column store error: task framework:  [2620] executor: plan operation failed;Execution of Adapter operation within node GEOCODE_1********.SDI::GEOCORD_TEMPLATE_ failed: exception 141005: Failed to create or initialize HanaTransform object

My question now:

What is a HANA Transform object ? I was not able to get any information about this or the exception code "141005".

Do I need some special privileges to execute a hdbflowgraph with a GEOCODE object ?

(Other hdbflowgraphs work for me, for example address cleanse).

Thank you for any advice!

Johannes

[werner_daehn]

That is a bit outside my comfort zone, but as far as I know the geocode transform is using the GEO reference data, not the address reference data.

It seems you have download the address reference data for your country/countries, but not the GEO. Is this possible?

PAM talks about that on page 17

https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/TIP/PAM_HANA_SDI_1_0.pdf