It's all about the answers!

Ask a question

Data collection job failing every night.

Glen Maxfield (916) | asked Mar 26 '15, 5:54 p.m.

We've got RTC 5.0.1, and the data collection job Work Items fails every night.  The Build, SCM, APT, Repository, and Common jobs all succeed.

In the logs, we're seeing this error

[26/03/15 0:08:08:301 CDT] 000001c8 SystemErr     R 2015/03/26 00:08:08:301 CDT [ERROR] VegaDataServices - The following exception was thrown while processing the url:[projectArea/archived=false]/(itemHistory/(type/id|foundIn/itemId|projectArea/itemId|teamArea/itemId|owner/uniqueId|target/itemId|resolver/uniqueId|resolution/(workflow/id|id)|category/itemId|state/(workflow/id|id|group)|severity/id|priority/id|creator/uniqueId|modifiedBy/itemId|id|itemId|uniqueId|@href|contextId|summary|tags|creationDate|modified|resolutionDate|dueDate|duration|correctedEstimate|timeSpent|stateId|predecessor|dayModified|commentCount|subscriberCount|integerComplexity|activationDate)|projectArea/archived)&modifiedsince=2015-02-20T00:00:00.000-0600&size=10&pos=80&id=_Bd_rQNN2EeSn0vZVuNjMVw

and it also says

Caused by:  [CRJAZ1316E The user "Jazz-SQL-DW-Admin" does not have permission to read items that have the Category access type.]
 < Internal Repository Error> Internal Repository Error

I'm going to try putting the DW Admin user into the Jazz Admins group, but I don't know if that's the right fix.  It might succeed through brute force, but I would prefer a more elegant solution if there is one.

Accepted answer

permanent link
Donald Nong (14.3k211) | answered Mar 26 '15, 7:56 p.m.
This should be the right fix as the data collection user has to be in the JazzAdmins group.
Glen Maxfield selected this answer as the correct answer

Your answer

Register or to post your answer.