Hello,
I have seen this in the past if there were duplicate entries for the projected for PERIOD_NUMBER=0 from PROJECT_ID/OBJECT_ID=<same project id>
SELECT INV_PROJECTS.*
FROM INV_INVESTMENTS, INV_PROJECTS
WHERE INV_INVESTMENTS.ID = <internal id of project>
and INV_INVESTMENTS.ID = INV_PROJECTS.PRID ;
SELECT BASEREC.*
FROM INV_INVESTMENTS, PRJ_BASELINE_DETAILS BASEREC WHERE INV_INVESTMENTS.ID
= <internal id for project> and INV_INVESTMENTS.BASELINE_ID = BASEREC.BASELINE_ID(+) and
'PROJECT' = BASEREC.OBJECT_TYPE(+) ;
SELECT EVREC.*
FROM PRJ_EV_HISTORY EVREC, INV_INVESTMENTS
WHERE INV_INVESTMENTS.ID = <internal id for project>
AND INV_INVESTMENTS.ID = EVREC.OBJECT_ID(+) AND 'PROJECT' =
EVREC.OBJECT_TYPE(+) AND 0 = EVREC.PERIOD_NUMBER(+) ;
This should be unchanged:
SELECT PAC_MNT_PROJECTS.*
FROM PAC_MNT_PROJECTS
WHERE ID = <internal project id for project>
To resolve do the following:
1. Backup database and test if possible in test env first.
2. Delete "Create Earned ValueSnapshot" job from system if exists
3. Remove the totals rows from the prj_ev_history table - being VERY careful
to include the where clause:
delete from prj_ev_history where period_number=0
4. Regenerate Total information
You have two choices here
A. Schedule a run of the Update Earned Value Totals Job. You can set
the specific project through the parameters on the job
B. You can have your PMs login to Clarity and click the Update Earned
Value button on the
Project Properties -> Baseline view for the projects they require
current EV field information for.
Once the job has run, please can you check whether the duplicate project
has gone from the listing?
Hope this helps.
Ruth
From: CA Clarity Global User Community [mailto:
CommunityAdmin@communities-mail.ca.com]
Sent: 04 February 2013 19:28
To:
mb.2277340.100196587@myca-email.ca.com
Subject: [CA Clarity General Discussion] RE: Project duplicate in list view
So the is duplicate only in the project list view and not in any view where there is a list or lookup of projects? And not in the results of a database query?
You do get the duplicate if you filter for the name or the code?
In what I have seen a database corruption or oddity is more common than a view corruption. If it is a view corruption is that for all users (system view) or jut one user (user modified view) and is it on more than one workstation (not cached in the browser)?
An SQL trace should give the query against which you can verify your results.
Further ways to outrule the duplicate record are object and query based portlets and simply adding a character to the name to see if both instances change.
Martti K.
Posted by:another_martink
--
CA Communities Message Boards
100199127
mb.2277340.100196587@myca-email.ca.com<mailto:
mb.2277340.100196587@myca-email.ca.com>
https://communities.ca.com