RQM error when adding user to team area via REST API

Marko Tomljenovic (316●43●105) | asked Jul 06 '18, 7:12 a.m.
edited Jul 06 '18, 7:13 a.m.

Hello,

we have developed some internal tools that help (for our use cases) to more efficiently do user management for RTC, DNG, RQM, .. than just using the out-of-the-box features provided via the web client.

Our tool is using the REST API for adding users to a team area. For all applications this works fine but RQM sporadically returns a http 500 result while adding a user to a team area.

CRJAZ0329E The database query could not be completed. Integrity constraint violation SQL: Insert Into {REPOSITORY.CONTEXT_MEMBERS} ({CONTEXT_UUID}, {MEMBER_UUID}) VALUES (?, ?) SQL Exception #1 SQL Message: ORA-00001: unique constraint (QM1USER.REPOSITOR_RPSTR_CNTXT_MMBRS_PK) violated

SQL State: 23000 Error Code: 1

Class: com.ibm.team.repository.service.internal.permission.read.dataaccess.ContextMembersInserter CRJAZ2676I Details about the error were written to the log file. To find this data, search the log file for this identifier: f7992ea6-e42f-48bb-b4d8-8a5a8a2d37ee.

Can somebody give a hint on what the uuid is referring to at the end? Or any other hint that explains the root cause of the error?

Thank you

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Masizane Marivate (23●7) | answered Jul 06 '18, 7:23 a.m.

I’m not sure why you getting that particular error however as per the review-api documentation on jazz.net forum you can’t update members of a team area as team area info is read-only. Check the crud table . I successfully ran a put script and got a 200 ok status but my team areas were not updated.

Comments

Marko Tomljenovic commented Jul 06 '18, 9:04 a.m. | edited Jul 06 '18, 9:05 a.m.

What do you mean by "Review-API". Was this a typo?

Apart from this sporadic errors it is definitely working fine on our side.

It's all about the answers!

Related questions

RQM error when adding user to team area via REST API

One answer

Your answer