on 03-02-2020 9:19 AM
Hi guys,
Anyone here already encountered this error?
Error: SAP DBTech JDBC: [2048]: column store error: search table error: [2620] executor: plan operation failed; error during currency/unit conversion, exception 70000000: No error; $message$=client not set in session context in parameter 'client'
So this is the scenario.
I have a query with currency conversion and I exposed it to EXTERNAL SAP HANA VIEW.
I used the said query in a GRAPHICAL CALCULATION VIEW and tested all the fields and they are working fine.
However, if I use the said query in SQL SCRIPT CALCULATION VIEW, I can activate the sql script view. But if I drag even just three (3) fields of the view, that's the time I encountered the error above.
This is the SQL SCRIPT:
/********* Begin Procedure Script ************/
BEGIN
var_out = SELECT
B.*
FROM
"system-local.bw.bw2hana::QUERY_TEST" B;
END
/********* End Procedure Script ************/
Thank you.
Loed
Please check if OSS note 2362127 - SQL error 2048 with 'currency/unit conversion error' is not a system error is useful to you.
Thanks,
Bhavin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.