Deletion of records in Reporting DB ProjServer 2007 SP2

M

marie18

Hi everyone,

We have some problems with the deletion of projects and tasks and the time
assigned to them in the reporting db. In our scenario we delete all the data
from the publishing database and then we perform data import from third-party
system. What happens is that the deleted records from the published db stay
in the reporting db and after the import and the new records are copies to
the reporting db, thus making all records appearing multiple times.


Has anyone had a similar issue and can advise me on what is the best
approach to clean up the reporting db.

Thanks a lot.

Kind regards,

Maria
 
G

Gary L. Chefetz

Marie:

I think that because you're doing the external update, that the system is
generating new GUIDS, so it doesn't know that these are duplicates. What you
can do to fix this is force a rebuild of the RDB by backing up your
Enterprise Custom Fields using the Administrative backup feature and then
restore them. This will cause a complete refresh of the RDB.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleted timesheet resists in Reporting DB 6
Reporting DB sync Project Server 2007 2
Published or Reporting DB? 4
Ghost Project in Reporting DB 2007 1
New Resource Custom Field does not show on Reporting DB / OLAP 3
Where Timesheet custom field in the Reporting DB? 6
Inconsistant hours in Reporting DB and Timesheet cube/Timesheet vi 2
HUGE Reporting database 4

Top