Resource Center Issue - Enterprise Resources not in Resource Cente

[Anne]

I am not finding any newer Enterprise Resources in the Resource Center views.
I can see the proper data in two of the three tables (MSProject Resources
and Web Resources) that hold resource data. But the data is not in the cube
feeder table of MSP_Cube Resources table.

1. This process worked in the past - but can't identify what happened to
stop the cube from building correctly. In the Admin screen for "Update
resource tables and OLAP cube" - my cube status never changes from "The cube
building process was initiated on XX/XX/2005 at X:XX PM" - I never get a
confirmation that it was built.

2. Is there a way to refresh the MSP_Cube Resources table with the correct
data from the other two tables. I'm not able to see a function that I can
run to populate the data correctly. Even if I publish a new project with an
Enterprise resource assigned to a task, I can't get the data into the cube.

Thanks in advance for any help or guidance on this...

 

[mark.everett]

Anne -

In your Item I - the "The cube building process was initiated......" is
a problem. The process is hung for some reason and you should be
investigating why this happening. You might manually trigger an OLAP
build (do this at a low usage time of the day as this is usually a
processor intensive operation) and see if it completes, but if not, you
will need to look at the event logs on the SQL server to see why the
OLAP build is not completing.

I suspect that this is the root cause of the issue.

Mark Everett | PMP
www.quantumpm.com

 

[Anne]

Mark - thanks for your thoughts. If I use the Analysis Manager on the
Project Server itself, I can see the ProjServCube and process it from there -
with no errors. It completes, but doesn't' have the correct data. Thus
wondering how to populate the data back into that MSP_Cube_Resources table.
I believe that this is the table the cube is pulling from and its incorrect.

 

[Gary L. Chefetz [MVP]]

Anne:

Two things to check:

1) Have new resource names been added containing non alpha/numeric
characters?
2) Do you see any errors in the server application event log?

 

[Anne]

Gary -

1. My resources are brought in via an Active Directory Synch, so I have no
control over the characters that are being loaded in. The typical name that
is brought in is in the following format (taken from the PWA User Admin
screen)
User Name: "Adkison; David - Riverview"
Windows User Account: MNA\dadkison

If the semi colon or dash could be the problem, is there a way to strip
these out in the auto process? I wasn't aware of any customization I can do
to the Active Directory Synch Process.

2) Yes, I do get errors - there are usually three main errors...

The errors code on the server are...

1. Component: AD Connector
File: AutoADProcess
Line: -1
Description: <Description><![CDATA[AD Res Pool Sync - failed to issue the
PDS Resource update request]]></Description>

2. Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 4602
Error Number: 0x8c04000c
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjSvrSecurity
File: C:\Office\devsp\project\WebClient\source\serverutil\netapiutil.cpp
Line: 72
Error Number: 0x8c04000c
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

3. Component: AD Connector
File: AutoADProcess
Line: -1
Description: <Description><![CDATA[AD Res Pool Sync - failed to issue the
PDS Resource update request]]></Description>

 

[Gary L. Chefetz [MVP]]

Anne:

I believe that the semi-colons are "not supposed to cause problems."
However, the dash certainly will. The errors indicate a problem with
AD-synch, which appears to be not running correctly or at all. This can
easily domino into the cube. The errors you're citing are not cube related.
It would be interesting to know if any errors get logged if you kickoff the
cube build manually, but you need to address the resource naming convention
issue for any of this to work reliably.

 

[Anne]

Thanks for your thoughts Gary - I really appreciate your taking the time to
discuss!

Since I'm not an Active Directory "expert" , do you know of any way to strip
out the dash character on the way into Project Server? Maybe tap into the AD
Synch process and add a line of code? I highly doubt that my company's AD
group will allow me to change the display name field for these users....
Any ideas where I can go to research the AD Synch process?

Happy New Year to you!

Anne:

I believe that the semi-colons are "not supposed to cause problems."
However, the dash certainly will. The errors indicate a problem with
AD-synch, which appears to be not running correctly or at all. This can
easily domino into the cube. The errors you're citing are not cube related.
It would be interesting to know if any errors get logged if you kickoff the
cube build manually, but you need to address the resource naming convention
issue for any of this to work reliably.

Gary -

1. My resources are brought in via an Active Directory Synch, so I have no
control over the characters that are being loaded in. The typical name
that
is brought in is in the following format (taken from the PWA User Admin
screen)
User Name: "Adkison; David - Riverview"
Windows User Account: MNA\dadkison

If the semi colon or dash could be the problem, is there a way to strip
these out in the auto process? I wasn't aware of any customization I can
do
to the Active Directory Synch Process.

2) Yes, I do get errors - there are usually three main errors...

The errors code on the server are...

1. Component: AD Connector
File: AutoADProcess
Line: -1
Description: <Description><![CDATA[AD Res Pool Sync - failed to issue the
PDS Resource update request]]></Description>

2. Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 4602
Error Number: 0x8c04000c
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjSvrSecurity
File: C:\Office\devsp\project\WebClient\source\serverutil\netapiutil.cpp
Line: 72
Error Number: 0x8c04000c
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

3. Component: AD Connector
File: AutoADProcess
Line: -1
Description: <Description><![CDATA[AD Res Pool Sync - failed to issue the
PDS Resource update request]]></Description>