Skip to Content
0
Former Member
May 02, 2013 at 08:44 PM

After upgrade to Revision 55 some of query getting out of memory issues

30 Views

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