on 05-02-2013 9:44 PM
Hi All,
Hi,
We are getting error at the time of execution bellow Select Query
But it’s not creating an error log
Query :
select............................................................
....................................
From PV_BOOKINGS_MEASURE_TS1
PV_BOOKINGS_CHANNEL_MEASURE_TS1
PV_PARTNER_HIERARCHY
query dont have unions, and 2 or 3 joins only
i am getting this Error message :
Could not execute 'select BV_FISCAL_DAY_TO_YEAR.DV_FISCAL_QUARTER_ID, BV_FISCAL_DAY_TO_YEAR.FISCAL_YEAR_MONTH_INT, ...' in 8:49.211 minutes .
SAP DBTech JDBC: [2048]: column store error: search table error: [9] Memory allocation faile
But when I check using this query
SELECT * FROM M_EXPENSIVE_STATEMENTS WHERE START_TIME > add_days (now(),-1) AND ERROR_CODE <> '0' ORDER BY ERROR_TEXT
0 rows
It doesn't show any result(non of the query get fail)
And more over till yesterday(before upgrade to rev55) this was working really fine
And it’s not even giving a count on this query
can any one help me to find out what is wrong
Thanks
Regards
Ravindar
In theory rev55 was released, among other things, to solve some OOM issues.
However I wouldn't doubt there are some cases where the fix broke things that were working...
I'd open an OSS message to SAP with that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.