Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hello,
I have a object which is having around 30000 relationship with
different objects. When I try to delete this object it gives me the
error Long transaction aborted. If the object is having less
relationship (say 10000) then it works fine.
What could be the problem ? and how to resolve the problem.
Thanks & Regards
Jakir
↪ replying to Jakir
John Carlson — — source: Usenet: comp.databases.informix
On 20 Sep 2004 16:43:52 -0700, jakir@coolgoose.com (Jakir) wrote:
>Hello,
>
>I have a object which is having around 30000 relationship with
>different objects. When I try to delete this object it gives me the
>error Long transaction aborted. If the object is having less
>relationship (say 10000) then it works fine.
>What could be the problem ? and how to resolve the problem.
>
>Thanks & Regards
>Jakir
It sounds like you either need to increase the number of logical logs
or decrease the number of rows you delete at a time.
JWC
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.