plan operation failed;currency/unit conversion error

[Former Member]

Hi All,

Could someone please help me on the below error?

It looks like Currenty Type (i.e Current Exchange rate) not maintained in currency table causing. How do i upload some dummy data into curries types, and currency tables into HANA?

Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [2620] executor: plan operation failed;currency/unit conversion error,could not read currency precisions from table "SAP_HANA_EPM_DEMO"."TCURX" - invalid table name:  Could not find table/view TCURX in schema SAP_HANA_EPM_DEMO: line 1 col 53 (at pos 52) at ptime/query/catalog/catalog.cc:4760

version: HANA SPS6 - Hana demo systems - 30days

Thanks for your help in advance.

thanks

suresh

[vivekbhoj · Accepted solution]

Hi Suresh,

Create Synonyms for Currency Tables, then only you will be able to use them.

Additionally, you can check this thread:

http://scn.sap.com/thread/3438496

Regards,

Vivek

[Former Member · Accepted solution]

thanks, problem resolved

[vivekbhoj · Accepted solution]

You can close this thread then

Regards,

Vivek