exception 1000002: Allocation failed

[Former Member]

Hello,

we have recently migrated to rev 85(1.00.85.01.399276) from rev 70. after migration we are facing following issues.

Could not execute 'call "SCHEMA"."Procedure_Name"('xxx')' in 28.035 seconds .

[129]: transaction rolled back by an internal error:  [129] "SCHEMA"."Procedure_Name":   (at pos 823): [129] (range 3): transaction rolled back by an internal error: exception 1000002: Allocation failed

The Same procedure was running fine on Rev 70. Not only this procedure for most of our query's we are seeing similar kind of error.

We are using SAP HANA One in AWS. Instance Type is cc2.8xlarge.

Can you help us.

[glen_spalding]

any luck with this as we also have the same error

[Former Member]

Hi Glen,

After analysing complete procedure we found one update statement , because of which it is failing.
The query was using two tables. We have changed the joins conditions, after that it was running fine.