Error executing the query - SQL SCRIPT CALCULATION VIEW

Loed — Mon, 02 Mar 2020 09:19:31 GMT

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

Re: Error executing the query - SQL SCRIPT CALCULATION VIEW

bhavinvyas — Mon, 02 Mar 2020 10:21:21 GMT

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

Re: Error executing the query - SQL SCRIPT CALCULATION VIEW

Loed — Mon, 02 Mar 2020 12:41:34 GMT

Hi bhavin.vyas,

Thanks for the link but it cannot be applied in our BW server.

Loed

Question Re: Error executing the query - SQL SCRIPT CALCULATION VIEW in Technology Q&A

Error executing the query - SQL SCRIPT CALCULATION VIEW

Re: Error executing the query - SQL SCRIPT CALCULATION VIEW

Re: Error executing the query - SQL SCRIPT CALCULATION VIEW