Hi Chris,
We have tried all of the following:
1)
...
PSAdminLibrary2007.WebResource.ResourceDataSet rds =
mainResource.ReadResource(resourceID);
rds.Resources[0].RES_NAME = "test";
if (rds.Resources[0].RES_TYPE < 100)
rds.Resources[0].RES_TYPE += 100;
mainResource.CheckOutResources(new Guid[] { resourceID });
mainResource.UpdateResources(rds, false, false);
...
Results: the name updates in both the published and the reporting databases.
RES_TYPE is updated ONLY in the published database (e.g. if it was 2
originally, it will now be 102 in published db and still 2 in reporting)
2)
...
mainResource.DeactivateResources(new Guid[] { resourceID }, false);
...
Results: RES_TYPE is updated ONLY in the published database as above.
Reporting db still has the old value, even if we later change some other
resource fields like name, custom fields, etc.
3)
Change resource status to inactive through Project Web Access
Results: RES_TYPE is updated ONLY in the published database as above
In the queue, we can see that the Reporting Synch job runs successfully.
However, RES_TYPE does not appear to be synching with the Reporting database.
We have service pack 1 installled.
Do you have any idea what is causing the RES_TYPE field to not synch with
the Reporting database?
Regards,
Chester
Chris Boyd said:
Hey,
You need to make an update to the resource (UpdateResource PSI) to kick off
a publish job which will update the RDB.
--
Chris Boyd
MS Project
Program Manager
Blog:
http://blogs.msdn.com/project_programmability/
:
Hi,
We have tried changing the resource status from active to inactive and vice
versa using PWA, and the results are the same: the resource type is modified
in the published database, but stays the same in the reporting database.
Could you please confirm whether this is intended behaviour (and if
possible, elaborate why this is so) or if this is, indeed, a bug?
Thank you in advance,
Chester
After further investigation, it appears that res_type value actually does
change appropriately in the Published database using DeactivateResource(...)
method, but this change does not propogate to the Reporting database.
We have even tried changing the name and setting res_type using the resource
data set. While the name change is reflected in the Reporting database, the
res_type still does not change.
Regards,
Chester
:
DeactiveResource(...) should work. Did any exceptions get thrown? Are there
any errors in the ULS logs? Also, can you provide a code snippet?
--
Chris Boyd
MS Project
Program Manager
Blog:
http://blogs.msdn.com/project_programmability/
:
Hi
We have tried to use DeactivateResources method, but the resource type had
not been changed.
According to MSDN PDS PSI equivalents we should use UpdateResources.
So what is DeactivateResources method for in this case?
Regards
