cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

henrique_pinto
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Hi Henrique,

Yes.

I am working with SAP Dev team to

Former Member
0 Kudos

Hi Ravindar,

  Did SAP ever get back to you on this? We are trying to connect BO to HANA tables and getting the same error. Also, tried to execute the SQL directly on HANA with similar result.

Former Member
0 Kudos

Hi Ravindra,

Can you please let me know the outcome of this, as I've upgraded to Rev 56 and now I cant even launch the SAP HANA Studio and it throws me out of memory exception while launching the studio ?

Thanks & regards,

Jomy

rama_shankar3
Active Contributor
0 Kudos

Jomy,

Check out http://scn.sap.com/message/14114494 blog.

Hope this helps.

Rama

former_member184768
Active Contributor
0 Kudos

Hi Jomy,

You already opened a message on the same issue. Kindly check my reply in your other message. It will help you fix the Studio issue.

Regards,

Ravi