on 01-23-2014 5:47 PM
I am getting following error when I do data preview in a calculation view and add a filter on Text column. It works fine on the complete dataset or if the column is an integer but not on string column.
Error: SAP DBTech JDBC: [2048]: column store error: search table error: [1999] Error executing physical plan: general error (no further information available);BwPopSearch pop10(EDW:TBL_T_CDV90000en),in executor::Executor in cube:
Hi Bo,
Can you share the filter expression you are using? BwPoPSearch operator is for filtering and it is unable to filter , there must be something wrong in the expression .
Regards,
Krishna Tangudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-- SQL with Number (Integer). DISTRICT_NUM is an integer field and returns 6 rows
SELECT *
FROM "_SYS_BIC"."BO/CALV_DTL_ALERT"
('PLACEHOLDER' = ('$$IN_END_DATE$$', '2014-01-08'), 'PLACEHOLDER' = ('$$IN_BEGIN_DATE$$', '2014-01-08'))
WHERE ("DISTRICT_NUM" = 300002.0);
--SQL with NAME (STRING). DISTRICT is a string field and runs for the longtime and gives above error
SELECT *
FROM "_SYS_BIC"."BO/CALV_DTL_ALERT"
('PLACEHOLDER' = ('$$IN_END_DATE$$', '2014-01-08'), 'PLACEHOLDER' = ('$$IN_BEGIN_DATE$$', '2014-01-08'))
WHERE ("DISTRICT" = 'ARIZONA');
Hi Bo,
What are the number of rows expected to return on the data preview, approximately?
Regards,
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.