cancel
Showing results for 
Search instead for 
Did you mean: 

Error executing the query

Former Member
0 Kudos

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:

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182302
Active Contributor
0 Kudos

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

Former Member
0 Kudos

-- 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');

former_member185165
Active Participant
0 Kudos

Hi Bo,

What are the number of rows expected to return on the data preview, approximately?

Regards,

Vijay

Former Member
0 Kudos


Base tables have about 100K rows and result set after filter should be around 17 rows