List:MaxDB« Previous MessageNext Message »
From:Alexei Novakov Date:June 4 2005 7:27pm
Subject:[-9111]: System error: Move error
View as plain text  
Hi List,

I trying out latest MaxDB version 7.5.0.26 and ran
into a problem with extremely simple query:

select T1.ENTITY_ID, T2.ENTITY_DOWN_FK
from ENTITY_E T1, RELATIONSHIP_R T2
where T1.ENTITY_ID = 3640722049958068233
and T2.TYPE_FK = 201104
and 3640722049958068233 = T2.ENTITY_UP_FK
order by T2.ORDER_R, 1, 2

It results: "[-9111]: System error: Move error" I
guess this is some kind of internal error. It supposed
to return 3 records in result set. It starts working
OK if I remove and of listed columns in "ORDER BY"
clause (for instance "order by T2.ORDER_R, 1" works
fine). It also works fine if I add T2.ORDER_R into
select.

Any ideas?

Regards
Alexei Novakov
Thread
[-9111]: System error: Move errorAlexei Novakov4 Jun
  • Re: [-9111]: System error: Move errorPeter5 Jun
RE: [-9111]: System error: Move errorHolger Becker6 Jun
  • RE: [-9111]: System error: Move errorAlexei Novakov6 Jun
RE: [-9111]: System error: Move errorHolger Becker7 Jun