Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Trying to change the parent give a CRJAZ1037I error

I am trying to change the parent of a task, but when I click save I get the following SQL error:

CRJAZ1037I The following SQL query did not execute properly on the server.

RelationQueryModel r = RelationQueryModel.ROOT;
AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r);
q.filter(r.target().itemId()._inLargeList)._and(r.source().itemId()._inLargeList)));

I am using RTC3.0

Some tasks have been migrated from a RTC2 instance, but mostly both child (task) and parent (stories) were created in RTC3.

Please help.

Cheers
Kay

0 votes



One answer

Permanent link
Hi,

I'd cosider to open a defect on Jazz.net or a PMR if under support.
You could also consider to try to validate the DB using the repotools, maybe that helps to locate the issue. Does that always happen or only for some WI's. I googled for the error and found some hits, but my connection is too slow to dig deeper.

Sorry, maybe someone comes up with a better solution,

Ralph

I am trying to change the parent of a task, but when I click save I get the following SQL error:

CRJAZ1037I The following SQL query did not execute properly on the server.

RelationQueryModel r = RelationQueryModel.ROOT;
AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r);
q.filter(r.target().itemId()._inLargeList)._and(r.source().itemId()._inLargeList)));

I am using RTC3.0

Some tasks have been migrated from a RTC2 instance, but mostly both child (task) and parent (stories) were created in RTC3.

Please help.

Cheers
Kay

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 13 '11, 10:55 a.m.

Question was seen: 4,689 times

Last updated: Apr 13 '11, 10:55 a.m.

Confirmation Cancel Confirm