JRS report doesn't show user name propely
hi,
2 answers
Hi Lior,
User names (CCM contributors) are stored in data warehouse table RIODS.RESOURCE. Run following query in Advanced section.
select NAME, FULL_NAME, URL from RIODS.RESOURCE
and see if the user in question has a proper full name. If not, change something for this member in CCM project members, save it, (and revert back to original, and save again). Now modifiedsince flag is on, and the user info will be updated by next DCC job (delta load). After the next DCC job, verify the query again if the full name gets updated.
Comments
I wasn't able to find this user name in the results I had received using the query, actually I didn't few others in the list and for all those which I didn't find the same issue appear regarding the user name..
Then follow my comment as above.
Change something for this member in CCM project members (such as add a role temporary), save it, revert back to original, and save again. Now modifiedsince flag is on, and the user info will be updated by next DCC job (delta load).
I guess DCC job had failed just after when you added these members in the project. If you know the date when it has been done by history and still keep dcc logs, verify what happened.
Hi,
Make sure to run DCC job "Jazz Foundation Services - Core" which loads the CCM contributors. If problem persists, contact IBM support for detailed investigation.
where is this job located at and how do I run it?